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

Format:

Book

Contributor:

Arrell, Kathryn.

Dutcavich, Denny.

Frank, Bruce.

Gorman, Michael.

Jaenen, Mark.

Russell, Tom.

International Business Machines Corporation. International Technical Support Organization.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Relational databases.

Oracle (Computer file).

Linux.

Physical Description:

xiv, 254 p. : ill.

Edition:

1st ed.

Place of Publication:

Poughkeepsie, NY : IBM, International Technical Support Organization, 2003.

Language Note:

English

System Details:

text file

Summary:

This IBM Redbooks publication describes experiences gained while installing and testing Oracle9i for Linux on zSeries, such as: Setting up the development systems at Oracle for the Linux on zSeries environment Installing the Oracle9i instances for Linux/390 on zSeries Performing basic monitoring and tuning exercises. The book is based on real-world experiences gained by team members and technical professionals during development and early testing of this product at: The IBM Oracle EMEA Joint Solution Center, Montpellier, France The IBM Oracle International Competency Center, San Mateo, California Early customer installations Development systems at Oracle in Redwood Shores, California. This book will be of use to those customers who are using Oracle9i for Linux/390 on zSeries for the first time.

Contents:

Front cover

Contents

Notices

Trademarks

Preface

The team that wrote this redbook

Notice

Comments welcome

Chapter 1. Overview of Oracle9i on zSeries

1.1 What is Linux

1.2 What is Linux for zSeries

1.3 Why Oracle9i on Linux for zSeries?

1.3.1 Expanded application portfolio

1.3.2 Cost savings

1.3.3 Server consolidation and faster time to market

1.4 What is Oracle9i for Linux on zSeries

1.4.1 Oracle9i Database Server

1.4.2 Oracle9i Application Server

1.4.3 The Oracle e-business Suite

1.4.4 The Oracle Collaboration Suite

1.5 What distributions of Linux does Oracle support?

1.6 Obtaining a copy of Oracle9i for Linux on zSeries

1.7 Sizing Workloads for Oracle9i on Linux for zSeries

Chapter 2. How to deploy Oracle9i on Linux/390

2.1 Deployment options

2.1.1 z/VM or LPAR?

2.1.2 CPs or IFLs?

2.1.3 SuSE or Red Hat?

2.1.4 Network topology

2.1.5 Capacity planning

2.1.6 Customization of the SuSE distribution

Chapter 3. Installing Oracle9i Database on zSeries with Linux

3.1 The system environment

3.2 The Linux environment

3.2.1 Considerations if using Red Hat

3.3 Downloading the code

3.4 Finding the documentation

3.5 Checking the Linux kernel settings

3.6 Setting up the group and user ID for Oracle

3.7 Set up your system for xWindows

3.8 Getting the JDK

3.9 Installing Oracle9i binaries

3.10 Checking the environment

3.11 Running the Universal Installer

3.12 Setting up the .profile

3.13 Connecting with a local client

3.14 Connecting a remote client to the database

3.14.1 Updating tnsnames.ora

3.14.2 Starting the listener

3.14.3 Testing the connection

3.15 Using the non-interactive install process

3.16 Restarting the OUI

3.17 Testing the de-install process.

Chapter 4. Creating Linux virtual machines with shared Oracle binaries

4.1 Overview

4.2 Overview of the tests

4.2.1 Description of test

4.2.2 Hardware setup

4.2.3 Set up of software

4.2.4 Set up Linux

4.2.5 Installing Oracle9i

4.2.6 Oracle experiences

4.3 Conclusion

Chapter 5. Migrating Oracle9i to Linux for zSeries

5.1 The process for moving the database

5.2 Overview

5.2.1 Memory restrictions

5.2.2 Database size: data files

5.2.3 Compatibility issues

5.2.4 Database functional issues

5.3 Moving a small database

5.4 Moving a large database

Chapter 6. Using RMAN to handle backup and recovery

6.1 Introduction

6.2 Overview of RMAN

6.3 RMAN Media Management Interface

6.4 Activating archivelog mode

6.5 Using RMAN without a recovery catalog

6.6 Using RMAN with a recovery catalog

6.7 Configuring RMAN

6.8 Creating and using backup scripts

6.9 Sample BACKUP operations

6.10 Sample RESTORE/RECOVER operations

6.11 Reporting functionalities of RMAN

Chapter 7. Installing and configuring Oracle Enterprise Manager

7.1 Documentation

7.2 Introduction to Intelligent Agents and OEM

7.3 Installing and configuring an OEM configuration

7.4 Installing and configuring an IA on Windows 2000

7.5 Installing the Oracle Enterprise Manager

7.6 Installing the Intelligent Agent and Data Gatherer

7.6.1 Introduction to Intelligent Agents and OEM

7.6.2 Installation of the Intelligent Agent

7.6.3 Starting the Intelligent Agent

Chapter 8. Performance and scalability considerations

8.1 Virtual machine scheduling by z/VM

8.1.1 Processor usage

8.1.2 Linux storage management and swapping

8.1.3 Hints for tuning Linux usage

Chapter 9. Using Statspack to collect VMSTAT information

9.1 Statspack

9.2 VMSTAT

9.3 Gathering VMSTAT as part of Statspack.

9.3.1 Installing Statspack

9.3.2 The VMSTAT shell script

9.3.3 Procedure to run Statspack and shell script

9.4 Summary

Chapter 10. Implementing RAC on Oracle9i on Linux on zSeries

10.1 Preparation

10.1.1 z/VM setup

10.1.2 Linux setup

10.2 Oracle Cluster Manager install

10.2.1 Starting Cluster Manager

10.3 Oracle9i install

10.4 Database creation

Chapter 11. Using WebSphere with Oracle9i

11.1 Overview

11.2 Installing the repository database

11.3 Configuration of the repository database

11.4 Installing IBM HTTP server

11.5 Installing WebSphere

11.6 Running WebSphere as non-root user

11.7 Starting the application server

11.8 Testing the installation

Appendix A. Frequently asked questions about Oracle9i for zLinux

Appendix B. Tools for VM performance data collection and analysis

z/VM Control Program (CP)

B.0.1 The CP INDICATE command

B.0.2 Accounting records

B.0.3 CP Monitor Facility

B.1 Optional programs

B.1.1 VM Performance Reporting Facility (VMPRF).

B.1.2 VM Real Time Monitor (RTM)

B.1.3 RMF PM

B.1.4 FCON/ESA

Appendix C. Examples of setting up the xWindows Interface

Using a Linux Intel system as a client

Using VNC client and server

Using Exceed with Telnet

Appendix D. Linux Performance Data Collection and Analysis Tools

VMSTAT

XOSVIEW

TOP

IOSTAT &amp

SAR

BMC PATROL

RMF PM with support for Linux enterprise server

ESALPS

Monitoring requirements

Standard interface

Performance Database (PDB)

Appendix E. Useful Linux information

Useful vi command

Useful Linux commands

Linux directory structure

Important Linux configuration files

Tools to administrate Linux

Putty

WinSCP

Appendix F. Sample of response file

Abbreviations and acronyms

Related publications

IBM Redbooks

Other resources.

Referenced Web sites

How to get IBM Redbooks

IBM Redbooks collections

Index

Back cover.

Notes:

"April 2003."

"SG24-6552-00."

Includes bibliographical references and index.

OCLC:

137342209