Experiences with Oracle for Linux on zSeries

Experiences with Oracle for Linux on zSeries

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...

Descripción completa

Detalles Bibliográficos
Autor Corporativo: International Business Machines Corporation. International Technical Support Organization (-)
Otros Autores: Arrell, Kathryn (-), Dutcavich, Denny, Frank, Bruce, Gorman, Michael, Jaenen, Mark, Russell, Tom
Formato: Libro electrónico
Idioma:Inglés
Publicado: Poughkeepsie, NY : IBM, International Technical Support Organization 2003.
Edición:1st ed
Colección:IBM redbooks.
Materias:
Oracle (Computer file)
Linux.
Relational databases.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627137606719
Tabla de Contenidos:
  • 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.

Ejemplares similares