Experiences installing Oracle Database 10g on z/OS / [Kathryn Arrell ... et al.].

Format:

Book

Contributor:

Arrell, Kathryn.

International Business Machines Corporation. International Technical Support Organization.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Relational databases.

Oracle (Computer file).

z/OS.

Physical Description:

xiv, 192 p. : ill.

Edition:

1st ed.

Place of Publication:

[S.l.] : IBM, International Technical Support Organization, c2004.

Language Note:

English

System Details:

text file

Summary:

This IBM Redbooks publication will help you install, tailor and configure the new Oracle Database 10g on z/OS. It describes experiences with the new installation process, and will be especially useful for anyone unfamiliar with the Oracle Universal Installer and IBM UNIX System Services who is installing Oracle Database 10g for the first time. The book is based on experiences gained during installations at: - The IBM/Oracle International Competency Center, San Mateo, California - The IBM ITSO zSeries Center in Poughkeepsie, New York - Oracle Headquarters, Redwood Shores, California

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

1.1 Overview of Oracle Database 10g

1.1.1 New features of Oracle 10g

1.2 Oracle 8, 8i and 9i - former architecture

1.3 Present architecture of Oracle 10g on z/OS

1.3.1 Multiple address spaces

1.3.2 IBM Language Environment® and Oracle Database 10g

1.3.3 z/OS UNIX System Services (USS) and Oracle Database 10g

1.3.4 Workload Manager and Oracle Database 10g

1.3.5 Oracle Enterprise Manager (OEM) and Oracle Database 10g

1.4 Summary

Chapter 2. Preparing to install Oracle Database 10g

2.1 Preinstallation tasks

2.2 Media and documentation

2.3 Verify the TCP/IP and X Windows connection

2.3.1 TN3270 connection

2.3.2 TCP/IP connection in line mode

2.3.3 X Windows connection

2.4 Verifying that USS facilities are functional

2.4.1 z/OS 1.4

2.4.2 Java

2.4.3 Perl

2.4.4 Make command

2.5 Choose the data set, user and group names

2.6 Add user IDs and groups

2.7 Verify file system size and permissions

2.7.1 The /tmp file system

2.7.2 The /oracle file system

2.8 Set program properties

2.9 AFP-authorize the Oracle AUTHLOAD library

2.10 Run the installer

Chapter 3. Installing the Oracle Libraries

3.1 Obtaining the CD-ROMs

3.2 Using the Oracle documentation

3.3 Set up your system for X Windows

3.4 Checking to see if you are ready to install

3.5 Connecting with the User ID to install Oracle

3.6 Running the Universal Installer

3.6.1 Inventory directory panel

3.6.2 File locations

3.6.3 Available products

3.6.4 Select High Level Qualifier (HLQ)

3.6.5 Allocate partitioned data sets

3.6.6 Exit

3.6.7 Some possible problem areas.

Chapter 4. Customizing the subsystem for Oracle

4.1 Choosing our values

4.2 Using the Oracle documentation

4.3 Creating PARMLIB and adding members to INSTLIB

4.4 Members in PARMLIB

Chapter 5. Creating the Oracle Database

5.1 Using the Oracle documentation

5.2 Running the jobs in INSTLIB

5.3 Creating the database by running the jobs

5.4 Review of files and jobs

5.4.1 Files at the completion of the database creation

5.4.2 Jobs to start and stop the database

5.4.3 Commands to start and stop the database service

Chapter 6. Connecting to the Oracle Database with SQLPlus

6.1 Connecting from USS (OMVS) or a telnet session

6.2 Connecting with a TSO client

6.3 Connecting a remote client to the database

Chapter 7. Managing Oracle workload with z/OS Workload Manager

7.1 Introduction to z/OS Workload Manager

7.2 WLM vocabulary

7.2.1 Service class

7.2.2 Goals

7.2.3 Velocity goals

7.2.4 Response goals

7.2.5 CPU service unit

7.2.6 Service class period

7.2.7 Resource group

7.3 Classifying the Oracle server address spaces

7.4 Classifying local clients

7.4.1 TSO

7.4.2 CICS and IMS

7.4.3 Batch

7.4.4 NET clients

7.5 Enclaves

7.6 Enclave resource accounting

7.7 Implementation of the WLM policy

7.7.1 The system under test

7.8 CPU accounting with Oracle 10g and enclaves

Chapter 8. Installing the Intelligent Agent

8.1 Introduction to intelligent agents and OEM

8.2 Configuring the intelligent agent

Chapter 9. Using an IBM ESS with an Oracle database

9.1 Overview of ESS

9.2 RAID arrays

9.3 Disk and I/O

9.3.1 Random reads

9.3.2 Sequential reads

9.3.3 Sequential writes

9.3.4 Random writes

9.4 Conclusion

Appendix A. Options for setting up the X Windows environment

Using a Linux Intel system as a client.

Using the VNC client and server

Using VNC on a Linux guest on zSeries

Using Exceed with telnet

Using CYGWIN

Preventing the OUI from waiting for OMVS input

Appendix B. Creating a Hierarchical File System (HFS)

Alternative way to create an HFS

Appendix C. Installing the Oracle Client

Installing Oracle Client code

Appendix D. Restarting the OUI using the deinstall option

Starting over

Testing the deinstall process

Appendix E. Silent install example

Using the non-interactive install process

Performing a silent install

Related publications

IBM Redbooks

Other publications

Online resources

How to get IBM Redbooks

Help from IBM

Index

Back cover.

Notes:

"June 2004.

"SG24-7055-00."

Includes bibliographical references and index.

OCLC:

939263539