Oracle on IBM z Systems

Oracle on IBM z Systems

by Lydia Parziale, Sam Amsavelu, Armelle Chevé, Helene Grosch, Moshe Reder, David J Simpson, Narjisse Zaki
Released May 2017
Publisher(s): IBM Redbooks
ISBN: 9780738442617

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Abstract

Oracle Database 12c Release 1 running on Linux is available for deployment on IBM® z Systems®. The enterprise-grade Linux on IBM z Systems solution is designed to add value to Oracle Database solutions, including the new functions that are introduced in Oracle Database 12c.

In this IBM Redbooks® publication, we explore the IBM and Oracle Alliance and describe how Oracle Database benefits from IBM z Systems®. We then explain how to set up Linux guests to install Oracle Database 12c. We also describe how to use the Oracle Enterprise Manager Cloud Control Agent to manage Oracle Database 12c Release 1.

We also describe a successful consolidation project from sizing to migration, performance management topics, and high availability.

Finally, we end with a chapter about surrounding Oracle with Open Source software.

The audience for this publication includes database consultants, installers, administrators, and system programmers. This publication is not meant to replace Oracle documentation, but to supplement it with our experiences while installing and using Oracle products.

Table of contents

  1. Front cover
  2. Notices
    1. Trademarks
  3. Preface
    1. Authors
    2. Now you can become a published author, too!
    3. Comments welcome
    4. Stay connected to IBM Redbooks
  4. Chapter 1. A shared commitment to client value with IBM and Oracle Alliance
    1. 1.1 Discover the new possible
    2. 1.2 Solution overview
    3. 1.3 IBM z Systems family overview and architecture
    4. 1.4 How it works
    5. 1.5 Competitive advantage
  5. Chapter 2. Setting up Linux guests to install Oracle Database 12c Release 1
    1. 2.1 Obtaining Oracle documentation, Oracle code, and My Oracle Support notes
      1. 2.1.1 Master Note of Linux OS Requirements for Database Server
      2. 2.1.2 Pre-installation requirements documentation
      3. 2.1.3 Obtaining code for Oracle 12cR1 on IBM z Systems
      4. 2.1.4 Oracle database pre-installation tasks in Oracle online Documentation
      5. 2.1.5 Linux Large Pages and Oracle Databases
    2. 2.2 Red Hat Enterprise Linux and SUSE Linux Enterprise server setup
      1. 2.2.1 Important information
      2. 2.2.2 Pre-installation checking
    3. 2.3 Red Hat 6 or 7 Enterprise Linux server-specific setup
      1. 2.3.1 Important information
      2. 2.3.2 Pre-installation checking
    4. 2.4 SUSE Linux Enterprise Server specific setup
      1. 2.4.1 Important information
      2. 2.4.2 Pre-installation checking
    5. 2.5 Installation
      1. 2.5.1 Oracle Universal Installer
      2. 2.5.2 Updating the Oracle user profile
      3. 2.5.3 Creating the database
  6. Chapter 3. Using Oracle Enterprise Manager Cloud Control Agent to manage Oracle Database 12c Release 1
    1. 3.1 Basic Enterprise Manager Cloud Control Architecture
    2. 3.2 Creating the Enterprise Manager Cloud Control Architectures
      1. 3.2.1 Downloading the installation files
      2. 3.2.2 Installing and configuring Enterprise Manager Cloud Control 13c
    3. 3.3 Updating the agent at the Enterprise Manager Cloud Control to monitor Oracle Databases on IBM z Systems (online)
      1. 3.3.1 Configuring the Software Library storage space
      2. 3.3.2 Acquiring the Linux on IBM z Systems agent in online mode
      3. 3.3.3 Setting up My Oracle Support Credentials
      4. 3.3.4 Verifying that Enterprise Manager Cloud Control is in online mode
      5. 3.3.5 Applying the Linux on IBM z Systems Management Agent Software
    4. 3.4 Updating the agent at the Enterprise Manager Cloud Control to monitor Oracle Databases on Linux on IBM z Systems (offline)
      1. 3.4.1 Acquiring the Linux on IBM z Systems agent in offline mode
      2. 3.4.2 Verifying that Enterprise Manager Cloud Control is in offline mode
      3. 3.4.3 Updating the agents in Enterprise Manager Cloud Control using the Self Update feature
    5. 3.5 Deploying the agents from the Cloud Control console
    6. 3.6 Deploying the agents in silent mode
    7. 3.7 Adding the databases for monitoring
    8. 3.8 Summary
  7. Chapter 4. Successful consolidation project: From sizing to migration
    1. 4.1 Delimitation of the project scope
      1. 4.1.1 Certification and support
      2. 4.1.2 Best candidates for consolidation
      3. 4.1.3 Non-functional requirements
      4. 4.1.4 Business value analysis
    2. 4.2 Sizing
      1. 4.2.1 CPU
      2. 4.2.2 Memory
      3. 4.2.3 I/O
    3. 4.3 Proof of concept
      1. 4.3.1 PoC qualification
      2. 4.3.2 Execution
      3. 4.3.3 Analyzing and reporting
    4. 4.4 Migration
      1. 4.4.1 Considerations before migration
      2. 4.4.2 Available techniques for cross-platform migration
      3. 4.4.3 Considerations when migrating from File System to ASM or vice versa
      4. 4.4.4 Best practices
    5. 4.5 Successful production
  8. Chapter 5. Performance management for IBM z/VM, Linux, and Oracle on IBM z Systems
    1. 5.1 Oracle performance monitoring overview
    2. 5.2 Oracle database tools
      1. 5.2.1 Oracle Diagnostics Pack
      2. 5.2.2 Oracle Tuning Pack for Oracle Database
      3. 5.2.3 Oracle Enterprise Manager Cloud Control
      4. 5.2.4 STATSPACK
      5. 5.2.5 Oracle Real Application Testing
      6. 5.2.6 Oracle Orion tool
      7. 5.2.7 Downloadable tools from Oracle
    3. 5.3 Hypervisor monitoring tools
      1. 5.3.1 IBM Performance Toolkit for VM feature
    4. 5.4 zVPS
    5. 5.5 IBM Wave for z/VM
    6. 5.6 OMEGAMON XE on z/VM and Linux
    7. 5.7 Linux monitoring tools
    8. 5.8 Summary
  9. Chapter 6. High availability
    1. 6.1 Oracle HA options
      1. 6.1.1 Oracle Real Application Clusters (RAC)
      2. 6.1.2 Oracle RAC One Node
      3. 6.1.3 Oracle Clusterware
      4. 6.1.4 Edition-based redefinition
      5. 6.1.5 Online Reorganization and Redefinition
      6. 6.1.6 Oracle Flashback
      7. 6.1.7 Oracle Data Guard/Active Data Guard
      8. 6.1.8 Application Continuity
      9. 6.1.9 Oracle GoldenGate
      10. 6.1.10 Global Data Services
      11. 6.1.11 Storage-based replication
      12. 6.1.12 Oracle Site Guard
      13. 6.1.13 Oracle Recovery Manager
      14. 6.1.14 Oracle Secure Backup
      15. 6.1.15 Oracle Multitenant
    2. 6.2 HA building blocks for Oracle Database on IBM z Systems
      1. 6.2.1 Hardware provided HA
      2. 6.2.2 Operating system HA
      3. 6.2.3 Oracle provided HA
    3. 6.3 IBM z Systems with Oracle Database: Considerations and examples for HA
      1. 6.3.1 Networking
      2. 6.3.2 Oracle HA networking options
      3. 6.3.3 Oracle RAC Interconnect z/VM Link Aggregation
      4. 6.3.4 Oracle RAC interconnect considerations
      5. 6.3.5 I/O channel failover considerations
      6. 6.3.6 Banking example: High availability architecture
      7. 6.3.7 Government Client Example: Oracle MAA RAC and Data Guard
    4. 6.4 Summary and recommendations
  10. Chapter 7. Surrounding Oracle with open source software
    1. 7.1 Open source database managers on IBM z Systems
      1. 7.1.1 Database types
      2. 7.1.2 PostgreSQL
      3. 7.1.3 MongoDB overview
      4. 7.1.4 Integrating Apache Spark with Oracle and MongoDB databases that are running on IBM z Systems
    2. 7.2 Summary
  11. Appendix A. Oracle Database 11gR2 on Red Hat Enterprise Linux Servers 7
    1. A.1 Pre-installation requirements documentation
    2. A.2 Obtaining the code for Oracle 11gR2 on IBM z Systems
    3. A.3 Java version for 11gR2 installations on Red Hat 7
    4. A.4 Oracle RAC installation issue when version 11.2.0.4 is used with Red Hat Enterprise Linux server 7
    5. A.5 Security-Enhanced Linux
    6. A.6 Pre-installation checking
    7. A.7 Oracle Universal Installer
  12. Related publications
    1. IBM Redbooks
    2. Online resources
    3. Help from IBM
  13. Back cover

Product information

  • Title: Oracle on IBM z Systems
  • Author(s): Lydia Parziale, Sam Amsavelu, Armelle Chevé, Helene Grosch, Moshe Reder, David J Simpson, Narjisse Zaki
  • Release date: May 2017
  • Publisher(s): IBM Redbooks
  • ISBN: 9780738442617