Home Page Icon
Home Page
Table of Contents for
Front cover
Close
Front cover
by Richard Smrcina, David Simpson, Barton Robinson, Romain Pochard, Michael MacIsaa
Experiences with Oracle 11gR2 on Linux on System z
Front cover
Notices
Trademarks
Preface
Authors
Now you can become a published author, too!
Comments welcome
Stay connected to IBM Redbooks
Chapter 1. Why customers are choosing to use Oracle products on Linux on IBM System z
1.1 Virtualization capabilities of IBM System z
1.2 Ability to use existing disaster recovery plans
1.3 Trusted Security and Resiliency
1.4 System z is optimized for High Availability
1.5 Total cost of ownership advantages of IBM System z
1.6 Ease of interfacing with traditional data
1.7 Increased performance and scalability capabilities of System z, including zEC12, z114, and z196
1.8 Specialty engines available on IBM System z
1.9 IBM zEnterprise BladeCenter Extension
1.10 End-to-end solution for dynamic infrastructure data center
1.11 Cost savings
1.12 Ability to easily add more capacity
1.13 IBM Cloud Services
1.14 Summary
1.15 Oracle solutions available on IBM System z
Part 1 Setting up and installing Oracle 11gR2 on Linux on System z
Chapter 2. Getting started on a proof of concept project for Oracle Database on Linux on System z
2.1 Architecture
2.1.1 Single Instance database
2.1.2 Single Instance with Cluster Ready Services or RAC One-Node
2.1.3 Two-node RAC on the same LPAR
2.1.4 Multinode RAC on more than one LPAR on one CPC
2.1.5 Multinode RAC in two or more CPCs
2.1.6 Data Guard
2.1.7 Using GoldenGate for replication
2.1.8 Summary
2.2 Sizing
2.2.1 Sizing tool
2.2.2 Memory sizing
2.2.3 Threads for dedicated processes
2.2.4 Summary
2.3 I/O considerations
2.3.1 Fibre Channel Protocol
2.3.2 ECKD and DASD
2.3.3 Oracle Database recommendations
2.3.4 File system recommendations
2.3.5 Validation of the I/O subsystem
2.4 Considerations for network choices
2.5 Other performance considerations
2.6 Considerations for how to run a PoC project
2.6.1 Run PoC testing
2.7 Successful projects: Is the solution production-ready?
Chapter 3. Network connectivity options for Oracle on Linux on IBM System z
3.1 Overview
3.2 Network considerations for running Oracle RAC with Linux on System z
3.3 Virtual local area network tagging
3.4 Designing the network configuration for HA with Oracle on Linux on System z
3.5 Oracle RAC recommended configurations for Linux on System z
3.5.1 Other considerations: Using Oracle Server Pools
3.6 Setting up z/VM
3.7 Linux setup for Oracle RAC Interconnect Interfaces
3.7.1 Setting up the private VSWITCH
3.7.2 Setting up Ethernet bonding
3.7.3 Setting up Oracle HAIP
3.8 Notes and observations
3.9 Summary
Chapter 4. Setting up SUSE Linux Enterprise Server 11 SP2 and Red Hat Enterprise Linux 6.2
4.1 Installing Oracle 11gR2 on SUSE Linux Enterprise Server guest
4.1.1 Linux required RPMs for SUSE Linux Enterprise Server 11
4.1.2 Network Time Protocol TIME option
4.2 Installing Oracle 11.2.0.3 on a Red Hat Enterprise Linux 6 guest
4.2.1 Verify SELinux is permissive or disabled
4.2.2 Linux required RPMs for Red Hat Enterprise Linux installations
4.2.3 Setting NTP TIME for Red Hat Enterprise Linux (optional only for Oracle Grid installations)
4.3 Customization that is common to SUSE Linux Enterprise Server and Red Hat Enterprise Linux
4.3.1 Required parameters for Oracle
4.3.2 Oracle RAC installations only
4.3.3 Create and verify required UNIX groups and Oracle user accounts
4.3.4 Setting file descriptors limits for the oracle and grid users
4.3.5 Pre-create user directories for product installs
4.3.6 Other rpm for grid installs for SUSE Linux Enterprise Server and Red Hat Enterprise Linux
Chapter 5. Using the Cloud Control agent to manage Oracle databases
5.1 Basic Enterprise Manager Cloud Control Architecture
5.2 Creating Cloud Control infrastructure on x86 Linux
5.2.1 Downloading and extracting the installation files
5.2.2 Installing and configuring the Enterprise Manager Cloud Control 12c
5.3 Updating the Cloud Control Software Library in online mode
5.3.1 Upgrading Software Library by using the Self Update Feature in online
5.4 Updating the Cloud Control Software Library in offline mode
5.4.1 Upgrading Software Library by using the Self Update Feature in offline mode
5.5 Deploying the Agents from Cloud Control console
5.6 Deploying Management Agents in silent mode
5.7 Adding the databases for monitoring
5.8 Summary
Part 2 Managing an Oracle environment on Linux on System z
Chapter 6. Using z/VM Live Guest Relocation to relocate a Linux guest
6.1 Overview of z/VM 6.2 features
6.1.1 Single System Image feature
6.1.2 LGR
6.2 Lab environment
6.2.1 Overview of tested two node z/VM SSI cluster
6.2.2 Hardware configuration
6.2.3 z/VM Software
6.2.4 Solution that is used to simulate a database workload
6.3 Scenario 1: Relocating an active Oracle single-instance database by using LGR
6.3.1 Setup information
6.3.2 Simulating the client workload
6.3.3 Relocating an Oracle guest
6.4 Scenario 2: Relocating an Oracle RAC inactive node by using LGR
6.4.1 Setup information
6.4.2 Network configurations
6.4.3 Client configuration of Transparent Application Failover
6.4.4 Simulating the client workload
6.4.5 Stopping Oracle on one node
6.4.6 Relocating the Oracle guest
6.4.7 Restarting Oracle on relocated guest
Chapter 7. Tuning z/VM, Linux, and Oracle to run on IBM System z
7.1 Linux and z/VM
7.1.1 Architecture
7.1.2 Best practices
7.1.3 CPU performance analysis
7.1.4 Storage and memory performance
7.1.5 Disk I/O performance
7.2 Oracle
7.2.1 Architecture
7.2.2 Best practices: CPU
7.2.3 Best practices: Performance analysis
7.2.4 Best practices: Storage and memory
7.2.5 Best practices: I/O
7.3 Summary
Chapter 8. Cross-platform migration overview
8.1 Introduction
8.2 Considerations before any migration
8.2.1 Downtime
8.2.2 Technical compatibility
8.2.3 Application compatibility
8.2.4 In-house administration scripts
8.2.5 Network
8.2.6 Disk space requirement
8.2.7 Skills
8.3 Migration techniques
8.3.1 Export/Import with Oracle Data Pump
8.3.2 Transportable Tablespaces
8.3.3 Create Table As Select
8.3.4 Oracle Streams
8.3.5 Oracle GoldenGate
8.3.6 Other techniques
8.3.7 Considerations when migrating from File System to ASM or vice versa
8.4 Best practices
8.4.1 Sizing considerations
8.4.2 Performance measurement before and after migration
8.4.3 Real Application Testing feature
8.4.4 Preparing the data to be migrated
8.4.5 Determine the invalid objects in the database
8.4.6 Rebuilding indexes
8.4.7 Logging during migration
8.4.8 Redo Logs
8.4.9 Using Linux on System z infrastructure
8.4.10 Considerations when you are migrating from Oracle on z/OS to Oracle on Linux on System z
8.5 Example of migration by using Export/Import Data Pump
8.5.1 Infrastructure
8.5.2 Tasks list
8.5.3 Snapshot of the database status
8.5.4 Export source database
8.5.5 Creating a target database
8.5.6 Import on the target environment
8.6 Summary
Chapter 9. High Availability and Disaster Recovery environment for Oracle
9.1 High Availability
9.1.1 Planned downtime events
9.1.2 Unplanned downtime triggers
9.1.3 Defining the common requirements for High Availability
9.2 Oracle technologies for High Availability
9.2.1 Backup and recovery
9.2.2 Oracle Flashback Technology
9.2.3 Oracle Automated Storage Manager
9.2.4 Oracle Grid Control Cluster technology
9.2.5 Oracle RAC One Node technology
9.2.6 Oracle RAC technology
9.2.7 Oracle Application Failover technology
9.2.8 Oracle Data Guard technology
9.2.9 Oracle GoldenGate
9.3 High Availability with z/VM
9.4 Disaster Recovery solutions
9.5 Summary
Part 3 Provisioning an Oracle environment on Linux on System z
Chapter 10. Automating Oracle on System z
10.1 Infrastructure as a Service under z/VM
10.1.1 Configuring z/VM
10.1.2 Defining virtual machines
10.2 PaaS
10.2.1 Preparing to install Red Hat Enterprise Linux 6.2 on the golden image
10.2.2 Installing Red Hat Enterprise Linux 6.2 Linux on the golden image
10.2.3 Configuring the Red Hat Enterprise Linux 6.2 golden image
10.2.4 Copying a REXX EXEC on z/VM for cloning support
10.2.5 Testing the cloning a virtual machine
10.3 SaaS for Oracle stand-alone
10.3.1 Configuring a Linux system for the Oracle boot script
10.3.2 Cloning a virtual server
10.3.3 Silently installing Oracle Database
Chapter 11. Provisioning an Oracle environment
11.1 Introduction
11.2 Customizing a new Linux reference for Oracle
11.2.1 Requirements
11.2.2 System environment
11.2.3 New reference guest
11.3 Optimizing the Linux environment for Oracle workload
11.3.1 rpm checker
11.3.2 Optional rpm for Oracle Grid: cvudisk-1.0.9-1 rpm
11.3.3 Stopping the useless Linux services
11.3.4 Hosts file
11.3.5 Linux Kernel parameters
11.3.6 Creating and verifying the required UNIX groups and Oracle user accounts
11.3.7 Pre-creating user directories for product installs
11.3.8 Setting file descriptors limits for Oracle and grid users
11.3.9 Activating the swap in memory (VDisk)
11.4 Linux configuration for Tivoli Service Automation Manager environment
11.4.1 Python package
11.4.2 Installing rpm for Tivoli Service Automation Manager
11.4.3 Checking mount definitions in /etc/fstab
11.4.4 Disabling the boot menu at IPL
11.4.5 Disabling parallel boot option on SUSE Linux Enterprise Server 11
11.4.6 Verifying the configuration
11.5 Installing a new Oracle Single Instance database and recording the Silent Install file on a test server
11.5.1 Getting the Patchset for Oracle Database Server 11.2.0.3.0
11.5.2 Starting the Virtual Network Computing server
11.5.3 Starting a VNC client
11.5.4 Installing Oracle Database
11.5.5 Replaying the installation in Silent Mode
11.6 Customizing a script
11.6.1 Customizing the shell script
11.6.2 Customizing the Silent Installation file for new server
11.7 Creating the Tivoli Service Automation Manager and Tivoli Provisioning Manager objects and workflows for PaaS provisioning
11.7.1 Setting up an Oracle Image
11.7.2 Cataloging an Oracle Image
11.7.3 Creating a Workflow
11.7.4 Registering an Oracle PaaS
11.7.5 Requesting a new Oracle Service
11.7.6 Suppressing a provisioning project
11.7.7 Unregistering a z/VM project
11.8 Summary
Chapter 12. Using z/Pro as a Cloud infrastructure for Oracle
12.1 zPRO introduction
12.2 Cloud implementation overview
12.2.1 Requirements
12.2.2 Dirmaint configuration
12.2.3 Dirmaint direct access storage device configuration
12.2.4 SMAPI implementation
12.2.5 zPRO implementation
12.2.6 Using zPro
12.2.7 Cloning
12.3 Shared Binary Linux implementation: SUSE Linux Enterprise Server 11 SP2
12.3.1 Architecture
12.3.2 Adding kernel modules
12.3.3 Setting up for read-only root
12.3.4 Creating a Base Linux golden image
12.4 Shared Binary Oracle implementation: Oracle 11g
12.5 Cloning 100 Oracle Servers for Development: Oracle 11g
12.5.1 Cloning procedure
12.6 References
Part 4 Appendixes
Appendix A. Setting up Red Hat Enterprise Linux 6.3 for Oracle
A.1 Introduction
A.2 Step 1: Starting the Red Hat bootstrap loader
A.3 Step 2: Installing Red Hat Enterprise Linux
A.4 Step 3: Running oravalidate rpm to import all other rpms
A.5 Installing and setting up vncserver
A.6 Step 4: Customizing the Linux setup for Oracle
A.7 Summary
Appendix B. Installing Oracle and creating a database 11.2.0.3 on Red Hat Enterprise Linux 6
B.1 Obtaining the Oracle code and documentation
B.2 Installing the Oracle code
B.3 Upgrading to the latest patch set update level
B.4 Creating an Oracle database
Appendix C. Working effectively with Oracle support
C.1 Oracle Support for Linux on System z
C.2 Oracle patching process
C.3 Prior planning and preparation prevent poor performance
C.4 Oracle SRs
C.5 Tools
Appendix D. Additional material
Locating the Web material
Using the Web material
Source code listings
Sample script for preoracle.sh
Related publications
IBM Redbooks
Other publications
My Oracle Support notes
Online resources
Help from IBM
Back cover
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Note: Before using this information and the product it supports, read the information in “Notices” on page xi.
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset