Experiences with Oracle 10g database for Linux on zSeries

Experiences with Oracle 10g database for Linux on zSeries

Linux on zSeries offers many advantages to customers who rely upon IBM mainframe systems to run their businesses. Linux on zSeries takes advantage of the qualities of service in the zSeries hardware—making it a robust industrial strength Linux. This provides an excellent platform for consolidating O...

Descripción completa

Detalles Bibliográficos
Autor principal: Arrell, Kathryn (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: San Jose, CA : IBM, International Technical Support Organization 2005.
Edición:1st ed
Colección:IBM redbooks.
Materias:
Oracle (Computer file)
Database management.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627126806719
Tabla de Contenidos:
  • 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.

Ejemplares similares