O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Oracle on LinuxONE

Book Description

Abstract

Oracle Database 12c Release 1 running on Linux is available for deployment on IBM® LinuxONE. The enterprise-grade Linux on LinuxONE 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 LinuxONE. 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 Linux without limits
    2. 1.2 Solution overview
    3. 1.3 LinuxONE 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 LinuxONE
      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 Enterprise Linux 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 LinuxONE (online)
      1. 3.3.1 Configuring the Software Library storage space
      2. 3.3.2 Acquiring the LinuxONE 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 Downloading and applying the LinuxONE Management Agent Software
    4. 3.4 Updating the agent at the Enterprise Manager Cloud Control to monitor Oracle Databases on LinuxONE (offline)
      1. 3.4.1 Acquiring the LinuxONE 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 LinuxONE
    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
      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 Linux running on LinuxONE
      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 LinuxONE 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 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 LinuxONE
      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 LinuxONE
    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 LinuxONE
    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