Experiences with Oracle 10g database for Linux on zSeries / Kathryn Arrell ... [et al.].

Format:

Book

Author/Creator:

Arrell, Kathryn.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Database management.

Oracle (Computer file).

Physical Description:

1 online resource (256 p.)

Edition:

1st ed.

Place of Publication:

San Jose, CA : IBM, International Technical Support Organization, 2005.

Language Note:

English

System Details:

text file

Summary:

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 Oracle databases that exist in your enterprise. This IBM Redbooks publication describes experiences gained while installing and testing Oracle10g for Linux on zSeries, such as: -Installing a single instance database of Oracle10g instances for Linux on zSeries -Installing Cluster Ready Services (CRS) and Real Application Clusters (RAC) -Performing basic monitoring and tuning exercises -Using options such as: --IBM’s Tivoli Data Protector (TDP) and Tivoli Storage Manager (TSM) --Automated Storage Manager (ASM) --LDAP and Radius Server for security --COBOL and C programs with Oracle Interested readers include database consultants, installers, administrators, and system programmers.

Contents:

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.

Notes:

Bibliographic Level Mode of Issuance: Monograph

Includes bibliographical references (p. 227-228) and index.

OCLC:

614891045