Front cover -- Contents -- Figures -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Overview of Oracle Database 10g for Linux on zSeries -- 1.1 What is Linux -- 1.2 Linux on zSeries -- 1.3 Why Oracle9i and Oracle 10g for Linux on zSeries -- 1.3.1 Expanded application portfolio -- 1.3.2 Cost savings -- 1.3.3 Server consolidation and faster time to market -- 1.4 Oracle Database 10g for Linux on zSeries -- 1.4.1 Oracle9i Database Server and Oracle Database 10g -- 1.4.2 Oracle9i Application Server and AS 10g -- 1.4.3 Oracle application solutions for Linux on zSeries -- 1.5 What distributions of Linux Oracle supports -- 1.6 Obtaining a copy of Oracle Database 10g for Linux on zSeries -- 1.7 Sizing workloads for Oracle10g for Linux on zSeries -- Chapter 2. Best practices for installing an Oracle Database 10g on Linux on zSeries -- 2.1 Memory sizing and configuration -- 2.2 CPU allocation -- 2.2.1 Sizing -- 2.2.2 CP allocation -- 2.2.3 Setting shares -- 2.3 Paging, swap, and I/O considerations -- 2.3.1 z/VM paging -- 2.3.2 Swap space for Linux -- 2.3.3 I/O considerations -- 2.3.4 Monitoring the system -- 2.4 Summary -- Chapter 3. Installing Oracle 10g single instance -- 3.1 Installing Oracle Database 10g on zSeries with Linux -- 3.2 Preparing the system environment -- 3.2.1 Setting up the fixed buffer option with ECKD™ disks -- 3.3 Setting up an xWindows interface using VNC -- 3.4 Downloading the code -- 3.4.1 Finding the documentation -- 3.4.2 Checking the Linux kernel settings -- 3.5 Running the Universal Installer -- 3.5.1 Starting the OUI -- 3.5.2 Initial OUI panels -- 3.5.3 Inventory directory panel -- 3.5.4 Changing to root screen for oraInstroot script -- 3.5.5 File location panel -- 3.5.6 Installation type -- 3.5.7 Selecting database configuration.

3.5.8 Database configuration options -- 3.5.9 Selecting the database management options -- 3.5.10 Selecting the database file storage -- 3.5.11 Selecting the backup and recovery options -- 3.5.12 Choose the database passwords -- 3.5.13 Summary -- 3.5.14 Install completing -- 3.5.15 Configuration Assistant panel -- 3.6 Verifying that the database is running -- 3.7 Enabling Async IO -- 3.8 Using the LOCK_SGA parameter -- 3.9 Using OEM to manage an Oracle database -- Chapter 4. Installing an Oracle 10g Database with ASM -- 4.1 ASM overview -- 4.2 Setting up ASM -- 4.3 Binding disks to raw devices -- 4.4 Configuring ASM instance using DBCA -- 4.5 Managing ASM using SQL commands -- 4.5.1 Connect to the ASM instance -- 4.5.2 Creating a new diskgroup -- 4.5.3 Modifying an existing diskgroup -- 4.6 Managing ASM using OEM -- 4.7 ASM best practices -- Chapter 5. Installing CRS and RAC -- 5.1 VM set up -- 5.2 Linux setup -- 5.2.1 Setting the kernel values -- 5.2.2 Moving the scripts to both nodes -- 5.2.3 Creating the raw devices -- 5.2.4 Create Oracle account -- 5.2.5 Set up logical volumes -- 5.2.6 Making symbolic links -- 5.2.7 Binding the raw devices -- 5.2.8 Set up the /etc/host file -- 5.2.9 Set up ssh to work without password -- 5.3 Preparation review -- 5.4 Oracle CRS installation -- 5.4.1 Cleaning up CRS if you need to reinstall -- 5.5 Oracle RAC installation -- 5.5.1 VIP configuration -- 5.6 Oracle Database creation -- 5.6.1 Setting up the user profile -- Chapter 6. Using Tivoli Storage Manager and Tivoli Data Protect for Oracle Database 10g -- 6.1 IBM Tivoli Storage Manager overview -- 6.2 Tivoli Storage Manager architecture -- 6.3 Tivoli Data Protection for Oracle -- 6.4 RMAN and Tivoli Data Protection for Oracle -- 6.5 Overview of installation process of TSM and TDPO -- 6.5.1 Configuring RMAN -- 6.5.2 Installing TSM server.

6.5.3 Install Tivoli Data Protect for Oracle -- 6.6 Back up the user tablespace -- 6.7 Restore and recover the users Tablespace -- 6.7.1 Restore and recover process -- 6.8 Summary -- Chapter 7. Using Cobol and C/C++ with Oracle Database 10g -- 7.1 Working with Pro*Cobol and sample programs -- 7.1.1 Install the Pro*COBOL precompiler -- 7.1.2 Sample Pro*COBOL programs -- 7.2 Using ACUCOBOL-GT Version 6.1 -- 7.2.1 Relinking ACUCOBOL-GT with Oracle -- 7.2.2 Work with the Oracle Pro*COBOL samples -- 7.2.3 Prepare and run the sample programs -- 7.3 Running MicroFocus Cobol -- 7.3.1 Makefile for sample Pro*COBOL programs -- 7.3.2 Makefile output for sample1 program -- 7.3.3 Execution of sample1 program -- 7.3.4 User programs -- 7.4 Oracle 10g Pro*C/C++ Precompiler -- 7.4.1 Run the Installer -- 7.4.2 Pro*C/C++ demonstration programs -- 7.4.3 Creating demo tables -- 7.4.4 Precompile and compile C source -- 7.4.5 Creating and executing sample2 -- Chapter 8. Monitoring VM and Linux -- 8.1 Oracle measurements -- 8.2 Configuration guidelines -- 8.2.1 Minimize Total Storage Footprint® -- 8.2.2 SGA must fit in memory -- 8.2.3 Use Oracle direct I/O -- 8.2.4 Use virtual disk for swap -- 8.2.5 Enable the timer patch -- 8.2.6 Use virtual switch -- 8.2.7 Use expanded storage for paging -- 8.2.8 Ensure sufficient page space -- 8.3 Storage analysis -- 8.3.1 Detecting storage problems - Paging -- 8.3.2 Detecting 2 GB storage problems - Paging -- 8.3.3 Detecting 2 GB problems - Demand scan -- 8.3.4 Detecting 2 GB problems - State analysis -- 8.4 I/O subsystem -- 8.4.1 LVM -- 8.5 Processor analysis -- 8.6 LPAR weights and options -- 8.6.1 Physical LPAR overhead -- 8.6.2 Converting weights to logical processor speed -- 8.6.3 LPAR analysis example -- 8.6.4 LPAR options -- 8.6.5 Shared versus dedicated processors.

Chapter 9. Using Radius Server and z/OS RACF LDAP for Oracle DB user authentication -- 9.1 Overview -- 9.2 FreeRADIUS on Linux on z/OS -- 9.3 z/OS LDAP -- 9.4 Oracle DB Advanced Security Option (ASO) -- 9.5 Oracle client -- Appendix A. VM setup and useful commands -- VM setup -- VM guest definition -- VM System definition -- Cloning -- FLASHCOPY -- Booting same Linux either as VM guest or LPAR -- Useful VM commands -- How to remove Oracle code -- Appendix B. Overview of ESALPS -- ESALPS overview -- ESALPS features -- Critical agent technology -- Monitoring requirements -- Standard interface -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover.