Experiences with Oracle for Linux on zSeries

Book description

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.

Table of contents

  1. Notices
    1. Trademarks
  2. Preface
    1. The team that wrote this redbook
    2. Notice
    3. Comments welcome
  3. Chapter 1: Overview of Oracle9i on zSeries
    1. What is Linux
    2. What is Linux for zSeries
    3. Why Oracle9i on Linux for zSeries?
      1. Expanded application portfolio
      2. Cost savings
      3. Server consolidation and faster time to market
    4. What is Oracle9i for Linux on zSeries
      1. Oracle9i Database Server
      2. Oracle9i Application Server
      3. The Oracle e-business Suite
      4. The Oracle Collaboration Suite
    5. What distributions of Linux does Oracle support?
    6. Obtaining a copy of Oracle9i for Linux on zSeries
    7. Sizing Workloads for Oracle9i on Linux for zSeries
  4. Chapter 2: How to deploy Oracle9i on Linux/390
    1. Deployment options
      1. z/VM or LPAR?
      2. CPs or IFLs?
      3. SuSE or Red Hat?
      4. Network topology
      5. Capacity planning
      6. Customization of the SuSE distribution
  5. Chapter 3: Installing Oracle9i Database on zSeries with Linux
    1. The system environment
    2. The Linux environment
      1. Considerations if using Red Hat
    3. Downloading the code
    4. Finding the documentation
    5. Checking the Linux kernel settings
    6. Setting up the group and user ID for Oracle
    7. Set up your system for xWindows
    8. Getting the JDK
    9. Installing Oracle9i binaries
    10. Checking the environment
    11. Running the Universal Installer
    12. Setting up the .profile
    13. Connecting with a local client
    14. Connecting a remote client to the database
      1. Updating tnsnames.ora
      2. Starting the listener
      3. Testing the connection
    15. Using the non-interactive install process
    16. Restarting the OUI
    17. Testing the de-install process (1/2)
    18. Testing the de-install process (2/2)
  6. Chapter 4: Creating Linux virtual machines with shared Oracle binaries
    1. Overview
    2. Overview of the tests
      1. Description of test
      2. Hardware setup
      3. Set up of software (1/2)
      4. Set up of software (2/2)
      5. Set up Linux
      6. Installing Oracle9i
      7. Oracle experiences
    3. Conclusion
  7. Chapter 5: Migrating Oracle9i to Linux for zSeries
    1. The process for moving the database
    2. Overview
      1. Memory restrictions
      2. Database size: data files
      3. Compatibility issues
      4. Database functional issues
    3. Moving a small database
    4. Moving a large database (1/2)
    5. Moving a large database (2/2)
  8. Chapter 6: Using RMAN to handle backup and recovery
    1. Introduction
    2. Overview of RMAN
    3. RMAN Media Management Interface
    4. Activating archivelog mode
    5. Using RMAN without a recovery catalog
    6. Using RMAN with a recovery catalog
    7. Configuring RMAN
    8. Creating and using backup scripts
    9. Sample BACKUP operations
    10. Sample RESTORE/RECOVER operations
    11. Reporting functionalities of RMAN
  9. Chapter 7: Installing and configuring Oracle Enterprise Manager
    1. Documentation
    2. Introduction to Intelligent Agents and OEM
    3. Installing and configuring an OEM configuration
    4. Installing and configuring an IA on Windows 2000
    5. Installing the Oracle Enterprise Manager
    6. Installing the Intelligent Agent and Data Gatherer
      1. Introduction to Intelligent Agents and OEM
      2. Installation of the Intelligent Agent
      3. Starting the Intelligent Agent
  10. Chapter 8: Performance and scalability considerations
    1. Virtual machine scheduling by z/VM
      1. Processor usage
      2. Linux storage management and swapping
      3. Hints for tuning Linux usage
  11. Chapter 9: Using Statspack to collect VMSTAT information
    1. Statspack
    2. VMSTAT
    3. Gathering VMSTAT as part of Statspack
      1. Installing Statspack
      2. The VMSTAT shell script
      3. Procedure to run Statspack and shell script
    4. Summary
  12. Chapter 10: Implementing RAC on Oracle9i on Linux on zSeries
    1. Preparation
      1. z/VM setup
      2. Linux setup
    2. Oracle Cluster Manager install (1/2)
    3. Oracle Cluster Manager install (2/2)
      1. Starting Cluster Manager
    4. Oracle9i install
    5. Database creation
  13. Chapter 11: Using WebSphere with Oracle9i
    1. Overview
    2. Installing the repository database
    3. Configuration of the repository database
    4. Installing IBM HTTP server
    5. Installing WebSphere
    6. Running WebSphere as non-root user
    7. Starting the application server
    8. Testing the installation
  14. Appendix A: Frequently asked questions about Oracle9i for zLinux
  15. Appendix B: Tools for VM performance data collection and analysis
    1. z/VM Control Program (CP)
      1. The CP INDICATE command
      2. Accounting records
      3. CP Monitor Facility
    2. Optional programs
      1. VM Performance Reporting Facility (VMPRF).
      2. VM Real Time Monitor (RTM)
      3. RMF PM
      4. FCON/ESA
  16. Appendix C: Examples of setting up the xWindows Interface
    1. Using a Linux Intel system as a client
    2. Using VNC client and server
    3. Using Exceed with Telnet
  17. Appendix D: Linux Performance Data Collection and Analysis Tools
    1. VMSTAT
    2. XOSVIEW
    3. TOP
    4. IOSTAT & SAR
    6. RMF PM with support for Linux enterprise server
    7. ESALPS
      1. Monitoring requirements
      2. Standard interface
      3. Performance Database (PDB)
  18. Appendix E: Useful Linux information
    1. Useful vi command
    2. Useful Linux commands
    3. Linux directory structure
    4. Important Linux configuration files
    5. Tools to administrate Linux
      1. Putty
      2. WinSCP
  19. Appendix F: Sample of response file (1/6)
  20. Appendix F: Sample of response file (2/6)
  21. Appendix F: Sample of response file (3/6)
  22. Appendix F: Sample of response file (4/6)
  23. Appendix F: Sample of response file (5/6)
  24. Appendix F: Sample of response file (6/6)
  25. Abbreviations and acronyms
  26. Related publications
    1. IBM Redbooks
    2. Other resources
    3. Referenced Web sites
    4. How to get IBM Redbooks
      1. IBM Redbooks collections
  27. Index (1/2)
  28. Index (2/2)
  29. Back cover

Product information

  • Title: Experiences with Oracle for Linux on zSeries
  • Author(s): Viviane Anavi-Chaput, Kathryn Arrell, Denny Dutcavich, Bruce Frank, Michael Gorman, Mark Jaenen, Tom Russell
  • Release date: April 2003
  • Publisher(s): IBM Redbooks
  • ISBN: None