Experiences with Oracle Database 12c Release 1 on Linux on System z

Experiences with Oracle Database 12c Release 1 on Linux on System z

by Mike Ebbers, Kathryn Arrell, Sam Amsavelu, Gaylan Braselton, Terry Elliott, Leon Rich, Barton Robinson, David Simpson
Released May 2014
Publisher(s): IBM Redbooks
ISBN: None

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

Oracle Database 12c Release 1 is now supported on Linux on IBM® System z®. This platform offers many advantages to customers who rely upon the IBM mainframe systems to run their businesses. Linux on System z takes advantage of the qualities of service in the System z hardware and in IBM z/VM®, making it a robust industrial strength version of Linux. This provides an excellent platform for hosting Oracle solutions that run in an enterprise.

This IBM Redbooks® publication shares experiences that are gained while installing and testing Oracle Database 12c Release 1:

  • Recommendations about how to set up an infrastructure

  • Installing an Oracle Grid Infrastructure

  • Installing Oracle 12C R1 Real Application Clusters (RAC) and creating a RAC Database, including a multitenant database

  • Using the Cloud Control Agent to manage Oracle Database 12c Release 1

  • Installing Oracle WebLogic Server 12c

  • Upgrading from an Oracle Database from 11gR2 to 12c Release 1


    • 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. What is new with Oracle on Linux on IBM System z
      1. 1.1 Myths about the mainframe
        1. 1.1.1 Don't Believe the Myths
      2. 1.2 IBM zEnterprise EC12
      3. 1.3 IBM zEnterprise BC12
      4. 1.4 IBM zEnterprise BladeCenter Extension
      5. 1.5 z/VM
        1. 1.5.1 Summary of the IBM hardware for Oracle Solutions
      6. 1.6 Linux distribution: New versions
        1. 1.6.1 Red Hat Enterprise Linux 6.4 and later
        2. 1.6.2 SLES 11 SP3 and later
      7. 1.7 Oracle new solutions
        1. 1.7.1 Oracle Database 12c R1
        2. 1.7.2 Oracle WebLogic Server 12c
        3. 1.7.3 Oracle Agent 12c on Linux on z for Oracle Grid Control
      8. 1.8 Summary
    5. Chapter 2. Setting up Linux guests to install Oracle Database 12c
      1. 2.1 Obtaining Oracle documentation, Oracle code, and My Oracle Support notes
      2. 2.2 Red Hat setup
        1. 2.2.1 SELinux permissive or disabled
      3. 2.3 SLES setup
      4. 2.4 Network considerations for RAC
      5. 2.5 Disk storage options for Linux on System z
        1. 2.5.1 FCP/SCSI disk configuration
        2. 2.5.2 ECKD/DASD disk configuration
        3. 2.5.3 Oracle ASM configuration
        4. 2.5.4 LVM file system configuration
        5. 2.5.5 Unit testing your I/O configuration
      6. 2.6 Summary
    6. Chapter 3. Installing an Oracle Grid Infrastructure
      1. 3.1 Getting started
      2. 3.2 Network considerations
      3. 3.3 Automatic Storage Management shared disks
      4. 3.4 CRS/ASM installation
      5. 3.5 Running the Oracle Grid Infrastructure installer
    7. Chapter 4. Installing Oracle Database 12c Oracle Real Application Clusters and creating a multitenant database
      1. 4.1 Installing the RAC binary files
      2. 4.2 Creating a non-CDB RAC database with DBCA
      3. 4.3 Creating a RAC CDB by using DBCA
      4. 4.4 Creating a PDB in the CDB by using DBCA
      5. 4.5 Summary
    8. Chapter 5. Using Oracle Enterprise Manager Cloud Control Agent to manage Oracle Database 12c Release 1
      1. 5.1 Basic Enterprise Manager Cloud Control Architecture
      2. 5.2 Creating Enterprise Manager Cloud Control Architectures on x86 Linux
        1. 5.2.1 Downloading and extracting the compressed installation files
        2. 5.2.2 Installing and configuring Enterprise Manager Cloud Control 12c
      3. 5.3 Updating the agent at the Enterprise Manager Cloud Control to monitor Oracle Databases on Linux on System z (online)
        1. 5.3.1 Configuring the Software Library storage space
        2. 5.3.2 Acquiring the Linux on System z agent in online mode
      4. 5.4 Updating the agent at the Enterprise Manager Cloud Control to monitor Oracle Databases on Linux on System z (offline)
        1. 5.4.1 Acquiring the Linux on System z agent in offline mode
      5. 5.5 Deploying the agents from the Cloud Control console
      6. 5.6 Deploying the agents in silent mode
      7. 5.7 Adding the databases for monitoring
      8. 5.8 Summary
    9. Chapter 6. Installation and initial tuning of Oracle WebLogic Server 12c on Linux on System z
      1. 6.1 Preparing the Linux guest
      2. 6.2 Downloading the code
      3. 6.3 Installation steps
      4. 6.4 Postinstallation tasks
        1. 6.4.1 Initial setting of the Java parameters
        2. 6.4.2 Creating a startup script
        3. 6.4.3 Updating the Managed Server JVM options
        4. 6.4.4 Monitoring WebLogic
      5. 6.5 Samples of Linux and JVM settings
      6. 6.6 Running a workload
    10. Chapter 7. Upgrading Oracle Database 11gR2 to a Oracle Database 12c on Linux on System z
      1. 7.1 Overview
      2. 7.2 Pre-upgrade
      3. 7.3 Database Upgrade Assistant
      4. 7.4 Post-upgrade tasks
      5. 7.5 Converting a non-CDB to a PDB
    11. Chapter 8. Upgrading a Oracle Real Application Cluster 11.2.0.4 database to version 12c R1
      1. 8.1 Upgrading the Oracle Grid Infrastructure
      2. 8.2 Upgrading Oracle Grid Infrastructure through the GUI
      3. 8.3 Data pump export of an Oracle RAC 11.2.0.4 table space
      4. 8.4 Installing the Oracle RAC 12c software and creating a PDB
    12. Chapter 9. Performance management topics for IBM z/VM, Linux, and Oracle on IBM System z
      1. 9.1 zVPS
        1. 9.1.1 Screens versus reports
      2. 9.2 Oracle analysis with zVPS
      3. 9.3 Processor performance management
        1. 9.3.1 Prioritizing work in a large virtualized system
        2. 9.3.2 CPU performance analysis
        3. 9.3.3 Processor summary
      4. 9.4 Storage and memory performance management
        1. 9.4.1 z/VM architecture
        2. 9.4.2 Linux storage
        3. 9.4.3 Oracle storage
      5. 9.5 Disk I/O performance
        1. 9.5.1 ECKD versus FCP
        2. 9.5.2 Disk size or LUN size
        3. 9.5.3 FCX/HPF
        4. 9.5.4 z/VM preferred practices
        5. 9.5.5 Measuring Oracle I/O activity
        6. 9.5.6 Oracle Application Profile
      6. 9.6 Oracle Database 11g experiences
      7. 9.7 Summary
    13. Appendix A. Details about the new IBM System z
      1. A.1 IBM zEnterprise EC12
      2. A.2 zEC12 elements
      3. A.3 IBM zEnterprise BladeCenter Extension (zBX)
      4. A.4 zBC12
      5. A.5 z/VM
    14. Related publications
      1. IBM Redbooks
      2. Oracle publications
      3. List of recommended Oracle My Oracle Support notes
      4. Online resources
      5. Help from IBM
    15. Back cover

    Product information

    • Title: Experiences with Oracle Database 12c Release 1 on Linux on System z
    • Author(s): Mike Ebbers, Kathryn Arrell, Sam Amsavelu, Gaylan Braselton, Terry Elliott, Leon Rich, Barton Robinson, David Simpson
    • Release date: May 2014
    • Publisher(s): IBM Redbooks
    • ISBN: None