Oracle on LinuxONE - IBM Redbooks

1 RedbooksFront coverOracle on LinuxONES usan AdamovichSam AmsaveluArmelle ChevHelene GroschGuilherme NogueiraJagannath RajuMoshe RederMariana RoveriDavid J SimpsonNarjisse ZakiInternational Technical Support OrganizationOracle on LinuxONEA ugust 2019SG24-8384-01 Copyright International Business Machines Corporation 2019. All rights to Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP ScheduleContract with IBM Edition (August 2019)This edition applies to Oracle Database 12cR1, Oracle Database 12cR2, SUSE Linux Enterprise Server and Red Hat Enterprise Linux Servers. Note: Before using this information and the product it supports, read the information in Notices on page vii. Copyright IBM Corp. 2019. All rights .. viiTrademarks .. viiiPreface .. ixAuthors .. ixNow you can become a published author, too!.

2 XiComments welcome.. xiStay connected to IBM Redbooks .. xiChapter 1. A shared commitment to client value with IBM and Oracle Alliance.. Discover the possible .. Solution overview .. LinuxONE family overview and architecture .. How it works .. Competitive advantage .. 3 Chapter 2. Setting up Linux guests to install Oracle Database 12c Release 1.. Obtaining Oracle documentation, Oracle code, and My Oracle Support notes.. Master Note of Linux OS Requirements for Database Server .. Pre-installation requirements documentation .. Obtaining code for Oracle 12cR1 on IBM LinuxONE .. Oracle database pre-installation tasks in Oracle online Documentation.. Linux Large Pages and Oracle Databases .. Red Hat Enterprise Linux and SUSE Linux Enterprise Server setup .. Important information .. Pre-installation checking.

3 Red Hat Enterprise Linux Server 6 or 7 Specific Setup .. Important information .. Pre-installation checking .. SUSE Linux Enterprise Server specific setup .. Important information .. Pre-installation checking .. Installation .. Oracle Universal Installer .. Updating the Oracle user profile .. Creating the database.. 22 Chapter 3. Using Oracle Enterprise Manager Cloud Control Agent to manage Oracle Database 12c Release 1.. Basic Enterprise Manager Cloud Control Architecture .. Creating the Enterprise Manager Cloud Control Architectures .. Downloading the installation files .. Installing and configuring Enterprise Manager Cloud Control 13c .. Updating the agent at the Enterprise Manager Cloud Control to monitor Oracle Databases on LinuxONE (online) .. Configuring the Software Library storage space .. Acquiring the LinuxONE agent in online mode.

4 Setting up My Oracle Support Credentials .. Verifying that Enterprise Manager Cloud Control is in online mode .. 30iv Oracle on Downloading and applying the LinuxONE Management Agent Software .. Updating the agent at the Enterprise Manager Cloud Control to monitor Oracle Databases on LinuxONE (offline) .. Acquiring the LinuxONE agent in offline mode .. Verifying that Enterprise Manager Cloud Control is in offline mode .. Updating the agents in Enterprise Manager Cloud Control using the Self Update feature.. Deploying the agents from the Cloud Control console .. Deploying the agents in silent mode .. Adding the databases for monitoring .. Summary .. 41 Chapter 4. Oracle encryption on LinuxONE .. Oracle Transparent Data Encryption on Oracle Database 12cR2 .. Benefits of the use of Transparent Data Encryption .. Installing Transparent Data Encryption.

5 Configuring and administering Transparent Data Encryption .. Enabling encryption on Oracle Database .. Managing TDE master keys and wallets .. Performance .. Using Oracle TDE on Oracle RAC .. Summary .. 60 Chapter 5. Successful consolidation project: From sizing to migration.. Delimitation of the project scope .. Certification and support .. Best candidates for consolidation .. Non-functional requirements .. Business value analysis .. Sizing .. CPU .. Memory .. I/O .. Proof of concept .. PoC qualification .. Execution .. Analyzing and reporting .. Migration .. Considerations before migration .. Available techniques for cross-platform migration .. Considerations when migrating from File System to ASM or vice versa.. Best practices .. Successful production .. 79 Chapter 6.

6 Performance management for IBM z/VM, Linux, and Oracle on Oracle performance monitoring overview .. Oracle database tools .. Oracle Diagnostics Pack .. Oracle Tuning Pack for Oracle Database .. Oracle Enterprise Manager Cloud Control .. STATSPACK.. Oracle real Application testing .. Oracle Orion tool .. Downloadable tools from Oracle .. 86 Contents Hypervisor monitoring tools.. IBM Performance Toolkit for VM feature.. zVPS .. IBM Wave for z/VM .. OMEGAMON XE on z/VM and Linux .. Linux monitoring tools .. Summary .. 91 Chapter 7. High Availability .. Oracle HA options .. Oracle real Application Clusters .. Oracle RAC One Node .. Oracle Clusterware .. Edition-based redefinition .. Online Reorganization and Redefinition .. Oracle Flashback .. Oracle Data Guard/Active Data Guard.

7 Application Continuity .. Oracle GoldenGate .. Global Data Services .. Storage-based replication .. Oracle Site Guard .. Oracle Recovery Manager .. Oracle Secure Backup .. Oracle Multitenant .. HA building blocks for Oracle Database on Linux running on LinuxONE .. Hardware provided HA .. Operating system HA .. Oracle provided HA.. IBM LinuxONE with Oracle Database: Considerations and examples for HA.. Networking .. Oracle HA networking options.. Oracle RAC Interconnect z/VM Link Aggregation .. Oracle RAC interconnect considerations .. I/O channel failover considerations .. Government Client Example: Oracle MAA RAC and Data Guard.. Summary and recommendations .. 109 Chapter 8. Surrounding Oracle with open source software .. Open source database managers on LinuxONE .. Database types.

8 PostgreSQL .. MongoDB overview .. Integrating Apache Spark with Oracle and MongoDB databases that are running on LinuxONE .. Summary .. 119 Appendix A. Oracle Database 11gR2 on Red Hat Enterprise Linux Servers 7 .. Pre-Installation requirements documentation .. Obtaining the code for Oracle 11gR2 on IBM LinuxONE .. Java version for 11gR2 installations on Red Hat 7 .. Oracle RAC installation issue when version is used with Red Hat Enterprise Linux server 7 .. Security-Enhanced Linux .. 124vi Oracle on Pre-installation checking .. Operating system requirements for IBM LinuxONE .. Oracle RPM Checker with Red Hat Enterprise Linux Server on LinuxONE .. Oracle Universal Installer .. 125 Related publications .. 127 IBM Redbooks .. 127 Online resources .. 127 Help from IBM .. 127 Copyright IBM Corp. 2019. All rights information was developed for products and services offered in the US.

9 This material might be available from IBM in other languages. However, you may be required to own a copy of the product or product version in that language in order to access it. IBM may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user s responsibility to evaluate and verify the operation of any non-IBM product, program, or service. IBM may have patents or pending patent applications covering subject matter described in this document.

10 The furnishing of this document does not grant you any license to these patents. You can send license inquiries, in writing, to:IBM Director of Licensing, IBM Corporation, North Castle Drive, MD-NC119, Armonk, NY 10504-1785, US INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some jurisdictions do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you. This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice.