book

Pro Oracle Database 11g RAC on Linux

Name: Pro Oracle Database 11g RAC on Linux
ISBN: 9781430229582

by Steve Shaw, Martin Bach

September 2010

Intermediate to advanced

839 pages

24h 33m

English

Apress

Read now

Unlock full access

Copyright
About the Author
About the Technical Reviewer
Acknowledgments
1. Introduction
1.1. Introducing Oracle Real Application Clusters1.2. Examining the RAC Architecture1.3. Deploying RAC1.3.1. Maintaining High Availability1.3.1.1. Providing Fault Tolerance by Redundancy1.3.1.2. Making Failover Seamless1.3.1.3. Putting the Technology Stack in Perspective1.3.2. Defining Scalability1.3.2.1. Scoping Various Levels of Scalability1.3.3. Scaling Vertically vs. Horizontally1.3.4. Increasing Manageability1.3.4.1. Achieving Manageability Through Consolidation1.3.4.2. Enabling Database Consolidation1.3.4.3. Consolidating Servers1.3.5. Assessing the Cost of Ownership1.3.5.1. Choosing RAC vs. SMP1.3.5.2. Evaluating Service-Level Agreements1.3.5.3. Improving Database Management1.3.5.4. Factoring in the Additional Hardware Cost1.3.5.5. Assessing the Staff and Training Cost1.4. Clustering with Oracle on Linux1.5. Running Linux on Oracle1.5.1. Understanding the Role of Unix1.5.2. Liberating Software1.5.3. Developing Linux1.5.4. Expanding the Concept of Free with Open Source1.6. Combining Oracle, Open Source, and Linux1.6.1. Drilling Down on Unbreakable Linux1.6.2. Creating and Growing Red Hat Enterprise Linux1.6.3. Extending Red Hat with Oracle Enterprise Linux1.6.4. Drilling Down on SuSE Linux Enterprise Server1.6.5. Taking Linux to Asia1.7. Summary
2. RAC Concepts
2.1. Clustering Concepts2.1.1. Configuring Active/active Clusters2.1.2. Implementing Active/passive Clusters2.1.3. Configuring a Shared-All Architecture2.1.4. Configuring a Shared-Nothing Architecture2.2. Exploring the Main RAC Concepts2.2.1. Working with Cluster Nodes2.2.2. Leveraging the Interconnect2.2.2.1. Using an Ethernet-based Interconnect2.2.2.2. Implementing an Infiniband-based Interconnect2.2.3. Clusterware/Grid Infrastructure2.2.3.1. Planning a RAC Installation2.2.3.2. Choosing a Process Structure2.2.3.3. Configuring Network Components2.2.3.4. Setting up Shared Grid Infrastructure Components2.2.3.5. Implementing the Oracle Cluster Registry and Oracle Local Registry2.2.3.6. Configuring Voting Disks2.2.4. Leveraging Automatic Storage Management2.2.4.1. Working with ASM Disks2.2.4.2. Exploiting ASM Disk Groups2.2.4.3. Configuring Failure Groups2.2.4.4. Weighing Your ASM Installation and Administration Options2.2.5. Installing Real Application Clusters2.2.5.1. Sorting Through Your Installation Options2.2.5.2. Choosing Between a Single Instance and a RAC Database2.2.5.3. Working with Database Files2.2.5.4. Storing Information in Control Files2.2.5.5. Leveraging Online Redo Logs and Archiving2.2.5.6. Managing Undo Tablespaces2.2.5.7. Weighing Storage Options for RAC Databases2.2.5.8. Drilling Down on a RAC Database Instance2.2.6. Using the Global Resource Directory (GRD)2.2.6.1. Maintaining Cache Coherence with Global Cache Services (GCS)2.2.6.2. Managing Global Enqueues with Global Enqueue Services (GES)2.2.7. Transferring Data Between Instances with Cache Fusion2.2.8. Achieving Read Consistency2.2.9. Synchronizing System Change Numbers2.3. Exploring the New Features of 11g Release 22.3.1. Leveraging Grid Plug and Play2.3.2. Modeling Resources with Server Pools2.3.3. Ensuring POSIX Compliance with ACFS2.3.4. Using Oracle Restart Instead of RAC2.3.5. Simplifying Clusterd Database Access with SCAN Listener2.4. Summary
3. RAC Architecture
3.1. Availability Considerations3.1.1. Deciding the Number of Nodes3.1.1.1. Two-Node RAC Clusters3.1.1.2. Oracle RAC One Node3.1.1.3. Multi-Node RAC Systems3.1.2. Online Maintenance and Patching3.1.2.1. Patching Real Application Clusters Using opatch3.1.2.2. Opatch Operation Modes3.1.2.3. All Node Patch Mode3.1.2.4. Rolling Patch Mode3.1.2.5. Minimum Downtime Patch Mode3.1.2.6. Local Patch Mode3.1.3. Instance Recovery in RAC3.1.3.1. Enqueue Remastering3.1.3.2. Database Recovery3.2. Failover Considerations3.2.1. Transparent Application Failover3.2.1.1. Failover Modes3.2.1.2. Failover Methods3.2.2. Fast Connection Failover and Fast Application Notification3.3. Scalability Considerations3.3.1. Scalability Enhancers3.3.2. Scalability Inhibitors3.4. Standby Databases3.4.1. Introduction to Oracle Standby Databases3.4.2. Types of Standby Database3.4.2.1. Physical Standby Database3.4.2.2. Snapshot Standby Database3.4.2.3. Logical Standby Database3.4.2.4. Transient Logical Standby Database3.4.3. Active Data Guard3.4.3.1. Role Transitions3.4.3.2. Data Protection Modes3.4.3.3. The Data Guard Broker3.4.4. Extended Distance Clusters3.5. Oracle Streams3.5.1. Streams Processing3.5.2. Oracle Streams Prerequisites3.6. Cluster Topologies3.7. Summary
4. Hardware
4.1. Oracle Availability4.2. Server Processor Architecture4.2.1. x86 Processor Fundamentals4.2.1.1. x86-644.2.2. Multicore Processors and Hyper-Threading4.2.3. CPU Cache4.2.4. CPU Power Management4.2.5. Virtualization4.3. Memory4.3.1. Virtual Memory4.3.2. Physical Memory4.3.3. NUMA4.3.4. Memory Reliability4.4. Additional Platform Features4.4.1. Onboard RAID Storage4.4.2. Machine Check Architectures4.4.3. Remote Server Management and IPMI4.5. Network Interconnect Technologies4.5.1. Server I/O4.5.1.1. PCI4.5.1.2. PCI-X4.5.1.3. PCI-Express4.5.2. Private Interconnect4.5.2.1. Standard Ethernet Interconnects4.5.2.2. Fully Redundant Ethernet Interconnects4.5.2.3. Infiniband4.5.2.4. Private Interconnect Selection Summary4.6. Storage Technologies4.6.1. RAC I/O Characteristics4.6.1.1. Read Activity4.6.1.2. Write Activity4.6.1.3. Asynchronous I/O and Direct I/O4.6.2. Hard Disk and Solid State Disk Drive Performance4.6.3. RAID4.6.3.1. RAID 0 Striping4.6.3.2. RAID 1 Mirroring4.6.3.3. RAID 10 Striped Mirrors4.6.3.4. RAID 0+1 Mirrored Stripes4.6.3.5. RAID 54.6.3.6. Storage Cache4.6.3.7. RAID Summary4.6.4. Storage Protocols for Linux4.6.4.1. SCSI4.6.4.2. Fibre Channel and FCoE4.6.4.3. iSCSI4.6.4.4. SATA4.6.4.5. Using Block-Based Storage4.6.4.6. Linux I/O Scheduling4.6.4.7. NFS and NAS4.6.4.8. Evaluating Storage Performance4.7. Summary
5. Virtualization
5.1. Virtualization Definition and Benefits5.2. Oracle VM5.2.1. Oracle VM Server Architecture5.2.1.1. Paravirtualization5.2.1.2. Full Virtualization5.2.2. Oracle VM Design5.3. Oracle VM Server Installation5.4. Oracle VM Manager Installation5.5. Oracle VM CLI Installation and Configuration5.6. Configuring Oracle VM5.6.1. Network Configuration5.6.2. Server Pool Configuration5.6.2.1. Enabling High Availability5.6.2.2. Configuring Shared Storage5.6.2.3. Cluster Configuration5.7. Installing and Configuring Guests5.7.1. Importing a Template5.7.2. Creating a Guest from a Template5.7.3. Accessing a Guest5.7.4. Configuring a Guest for RAC5.8. Managing Domains5.8.1. Oracle VM Agent5.8.2. Oracle VM Manager5.8.3. Oracle VM Manager CLI5.8.4. The xm Command-Line Interface5.8.4.1. Displaying Information5.8.4.2. Managing Domains5.8.4.3. Managing Resources5.9. Summary
6. Linux Installation and Configuration
6.1. Selecting the Right Linux Software6.2. Reviewing the Hardware Requirements6.3. Drilling Down on Networking Requirements6.3.1. Configuring a GNS or a Manual IP6.3.2. Configuring DNS and DHCP6.4. Downloading the Linux Software6.5. Preparing for a Network Install6.6. Installing Oracle Enterprise Linux 56.6.1. Starting the Installation6.6.2. Installation Media Check6.6.3. Anaconda Installation6.6.4. Install or Upgrade6.6.5. Disk Partitioning6.6.5.1. Creating a Default Partitioning Scheme6.6.5.2. Creating a Partition Manually6.6.5.3. Creating an MBR Partition6.6.5.4. Creating an EFI Partition6.6.5.5. Customized Partitioning6.6.5.6. Configuring Swap Space6.6.5.7. Configuring RAID6.6.6. Configuring the Boot Loader and Network6.6.7. Selecting a Time Zone6.6.8. Configuring the Root Password6.6.9. Reviewing the Package Installation Defaults6.6.10. Selecting a Package Group6.6.11. Installing Packages6.6.12. Setting the Final Configuration6.6.13. Accepting the License Agreement6.6.14. Configuring the Firewall6.6.15. Configuring SELinux6.6.16. Enabling kdump6.6.17. Setting the Date and Time6.6.18. Creating a User6.6.19. Installing Additional CDs6.7. Configuring Oracle Enterprise Linux 56.7.1. Configuring a Server with the Oracle Validated RPM6.7.1.1. Configuring YUM6.7.1.2. Running the Oracle Validated RPM6.7.1.3. Using the up2date Command6.7.2. Verifying the Oracle Validated RPM Actions6.7.2.1. Creating the Oracle User and Groups6.7.2.2. Configuring Kernel Parameters6.7.2.3. Working with Shared Memory6.7.2.3.1. Setting the kernel.shmmax Parameter6.7.2.3.2. Setting the kernel.shmmni Parameter6.7.2.3.3. Setting the kernel.shmall Parameter6.7.2.4. Using Semaphores6.7.2.5. Setting Network Parameters6.7.2.5.1. Setting the net.ipv4.ip_local_port_range Parameter6.7.2.5.2. Setting the net.core.* Set of Parameters6.7.2.6. Message Queues6.7.2.7. Setting the Number of Open Files6.7.2.8. Configuring Asynchronous I/O6.7.2.9. Using Magic SysRq Keys6.7.2.10. Setting PAM Limits6.7.2.11. Setting Kernel Boot Parameters6.7.2.12. Setting Kernel Module Parameters6.7.3. Post Oracle Validated RPM Configuration6.7.3.1. Setting the Huge Pages Kernel Parameter6.7.3.2. I/O Fencing and the Hangcheck-Timer Kernel Module6.7.3.3. Configuring the oracle user6.7.3.4. Creating the Oracle Software Directories6.7.3.5. Setting Environment Variables6.7.3.5.1. Setting the ORACLE_BASE Variable6.7.3.5.2. Setting the ORACLE_HOME Variable6.7.3.5.3. Configuring the ORACLE_SID Variable6.7.3.5.4. Setting the ORA_CRS_HOME Variable6.7.3.5.5. Setting NLS_LANG and ORA_NLS106.7.3.5.6. Configuring the TNS_ADMIN Variable6.7.3.5.7. Setting the PATH Variable6.7.3.5.8. Setting the LD_LIBRARY_PATH Variable6.7.3.5.9. Setting the JRE_HOME and CLASSPATH Variables6.7.3.5.10. Configuring the ORACLE_PATH and SQLPATH Variables6.7.3.5.11. Setting the DISPLAY Variable6.7.3.5.12. Setting the TEMP and TMPDIR Paths6.7.3.6. Putting Environment Variables to Work6.7.4. Completing the Linux Configuration for RAC6.7.4.1. Configuring Hostnames and Name Resolution6.7.4.2. Using NTP6.7.4.3. Configuring Secure Shell6.7.5. Configuring Shared Storage6.7.6. Discovering and Configuring SAN Disk6.7.6.1. Partitioning Disks6.7.6.2. I/O Multipathing with Device-Mapper6.7.6.3. Preparing the Partitions for ASM with ASMLIB6.7.6.4. Preparing the Partitions for ASM with udev6.7.6.4.1. Configuring Udev Permissions6.7.6.4.2. Enabling Udev Persistence6.7.7. Network Channel Bonding6.7.8. I/O Fencing with IPMI6.8. Summary

7. Grid Infrastructure Installation
7.1. Getting Ready for Installation7.1.1. Obtain Software Distribution7.1.2. Configure X Environment7.1.2.1. Checking Prerequisites7.1.2.2. Starting an X environment in a console window7.1.2.3. Starting an X environment using VNC7.1.3. Determining Configuration Type7.2. Advanced Installation - Manual Configuration7.2.1. Network Configuration7.2.2. DNS Configuration7.2.3. Choosing an Installation Option7.2.4. Selecting an Advanced or Typical Installation Type7.2.5. Selecting a Language7.2.6. Configuring the Grid Plug and Play7.2.7. Configuring the Cluster Node Information Page7.2.8. Configuring the Network Interface Usage Page7.2.9. Configuring the Storage Option Information Page7.2.10. Creating an ASM Disk Group7.2.11. Specifying an ASM Password7.2.12. Specifying a Username and Password for IPMI7.2.13. Configuring Privileged Operating System Groups7.2.14. Setting the Installation Location7.2.15. Specify the Central Inventory's Location7.2.16. Performing Prerequisite Checks7.2.16.1. Identifying Typical Errors7.2.16.2. Getting More Detail7.2.16.3. Fixup Scripts7.2.16.4. Anatomy of Fixup Scripts7.2.16.5. Addressing Failed Checks7.2.17. Reviewing the Summary Page7.2.18. Setup Page7.2.19. Reviewing Execute Configuration Scripts7.2.19.1. Execution Order7.2.19.2. Running the orainstRoot.sh Script7.2.19.3. Executing the root.sh script7.2.20. Monitoring Configuration Assistants7.3. Implementing an Advanced Installation for Automatic Configuration7.3.1. Configuring a Network Configuration7.3.2. Configuring DNS7.3.3. Configuring DHCP7.3.4. Setting up the Grid Plug and Play Information Page7.3.5. Configuring the Cluster Node Information Page7.3.6. The Summary Page7.4. Typical Installation7.4.1. Choosing the Installation Type7.4.2. Specifying the Cluster Configuration Page7.4.3. Install Locations Page7.4.4. Reviewing the Summary Page for a Typical Installation7.5. Installing a Standalone Server7.5.1. Selecting an Installation Option7.5.2. Creating an ASM Disk Group Page7.5.3. Reviewing the Summary Page for a Standalone Installation7.5.4. Configuring the Execute Configuration Scripts7.6. Deinstalling the Grid Infrastructure Software7.7. Summary
8. Clusterware
8.1. Introducing Clusterware8.2. Examining the Hardware and Software Requirements8.3. Using Shared Storage with Oracle Clusterware8.3.1. Storing Cluster Information with the Oracle Cluster Registry8.3.2. Storing Information in the Oracle Local Registry8.3.3. Fencing with the Voting Disk8.3.4. Recording Information with the Grid Plug and Play Profile8.4. Using Background Processes8.4.1. Grid Infrastructure Software Stacks8.4.2. Drilling Down on the High Availability Stack8.4.3. Drilling Down on the Cluster Ready Services Stack8.4.4. Using Grid Infrastructure Agents8.4.5. Initiating the Startup Sequence8.5. Managing Oracle Clusterware8.5.1. Using the Enterprise Manager8.5.2. Using the Clusterware Control Utility8.5.3. Managing Resources with srvctl8.5.4. Verifying the Cluster with the CVU8.5.5. Configuring Network Interfaces with oifcfg8.5.6. Administering the OCR and OLR with ocrconfig8.5.7. Checking the State of the OCR and its Mirrors with ocrcheck8.5.8. Dumping Contents of the OCR with ocrdump8.6. Defining Server-Side Callouts8.7. Protecting Applications with Clusterware8.7.1. Managing Resource Profiles8.7.2. Configuring Active/Passive Clustering for Oracle Database8.7.3. Configuring Active/Passive Clustering for Apache Tomcat8.8. Using Oracle Restart8.9. Troubleshooting8.9.1. Resolving Startup Issues8.9.1.1. Failing to Start OHAS8.9.1.2. Failing to Start Agents Created by OHAS8.9.1.3. Failing to Start the Cluster Synchronization Services Daemon8.9.1.4. Failing to Start the Cluster Ready Services Daemon8.9.1.5. Failing to Start the GPnP Daemon8.9.1.6. Agents spawned by CRSD8.9.2. Resolving Problems with Java Utilities8.10. Patching Grid Infrastructure8.11. Adding and Deleting Nodes8.11.1. Adding Nodes8.11.1.1. Checking the Prerequisites8.11.1.2. Executing the addNode.sh Script8.11.1.3. Finishing the Node Addition8.11.1.4. Adding the RDBMS Software8.11.2. Deleting Nodes8.11.2.1. Removing the Clustered RDBMS Home8.11.2.2. Removing the Node from the Cluster8.11.2.3. Finishing the Node Removal8.12. Exploring More Advanced Topics8.12.1. Selecting non-Default Listener Ports8.12.2. Selecting a non-Default SCAN Listener Endpoint8.12.3. Changing the SCAN After Installation8.12.4. Maintaining Voting Disks8.12.4.1. Restoring Voting Disks8.12.4.2. Moving Voting Disks into ASM8.12.5. Maintaining Local and Cluster Registry8.12.5.1. Dealing With a Corrupt or Inaccessible OLR8.12.5.2. Dealing with a Corrupt or Inaccessible OCR8.12.5.3. Moving the OCR into ASM8.13. Summary
9. Automatic Storage Management
9.1. Introducing ASM9.1.1. ASM Terminology9.1.2. Supported File Types9.1.3. ASM Management9.1.4. ASM and RDBMS Support9.2. ASM Installation9.3. ASM Components and Concepts9.3.1. ASM Instances9.3.1.1. Instance Names9.3.1.2. SGA9.3.1.3. Background Processes9.3.1.4. Parameters9.3.2. Failure Groups9.3.3. ASM Files9.3.3.1. Naming Files9.3.3.2. Aliasing Files9.3.3.3. Managing Control Files9.3.3.4. Understanding Extents, Allocation Units, Types, and Templates9.3.4. Redundancy9.3.5. Striping9.3.6. Mirroring9.3.7. Intelligent Data Placement9.3.8. Access Control9.3.8.1. Understanding Access Privileges9.3.8.2. Preparing the ASM Disk Group9.3.8.3. Changing File Ownership and Permissions9.4. Maintaining ASM9.4.1. Creating an ASM Disk Group9.4.2. Extending an ASM Disk Group9.4.3. Dropping Disks from an ASM Disk Group9.4.4. Enabling Disk Discovery9.4.5. Understanding the ASM Header9.4.6. Installing the Grid Infrastructure9.4.7. Re-creating the ASM Disks9.5. ASM Cluster File System9.5.1. Creating and Mounting an ACFS Using ASMCA9.5.2. Creating and Mounting an ACFS Using the Command Line9.5.3. Maintaining the ACFS9.5.4. Using ACFS with Oracle Restart9.6. Administering ASM9.6.1. Using SQL*Plus to Administer ASM9.6.1.1. Setting the Environment9.6.1.2. Determining the User and Privilege9.6.1.3. Knowing Your Options9.6.1.4. Dealing with Connected Clients9.6.1.5. Checking for Corruption9.6.1.6. Manually Mounting a Disk Group9.6.1.7. Dropping a Disk Group9.6.1.8. Creating ADVM Volumes9.6.2. ASM Administration Using SRVCTL9.6.3. Accessing Files in ASM9.6.4. Using Files Instead of Devices9.6.5. Virtualization and Shared Disks9.7. Summary
10. RDBMS Installation and Configuration
10.1. Installing the RAC Software10.1.1. Start the Installer10.1.2. Configuring the Security Updates Page10.1.3. Configuring the Installation Options Page10.1.4. Configuring the Node Selection Page10.1.5. Configuring the Product Language Selection Page10.1.6. Configuring the Database Editions Page10.1.7. Configuring the Installation Locations Page10.1.8. Configuring the Privileged Operating Systems Group Page10.1.9. Configuring the Prerequisites Check Page10.1.10. Reviewing the Summary Page10.1.11. Executing Configuration Scripts10.2. Using the Database Configuration Assistant (DBCA)10.2.1. Starting the DBCA and Choosing an Operation10.2.1.1. Configuring the Welcome Page10.2.1.2. Configuring the Operations Page10.2.2. Creating a Database10.2.2.1. Configuring the Database Templates Page10.2.2.2. Configuring the Database Identification Page (Admin-Managed)10.2.2.3. Configuring the Database Identification Page (Policy-Managed)10.2.2.4. Management Options Page10.2.2.5. Database Credentials Page10.2.2.6. Database File Locations Page10.2.2.7. Setting up the Recovery Configuration Page10.2.2.8. Configuring the Database Content Page10.2.2.9. Configuring the Standard Database Components Page10.2.2.10. Configuring the Initializations Parameters Page10.2.2.10.1. Configuring the Memory Tab10.2.2.10.2. Configuring the Sizing Tab10.2.2.10.3. Configuring the Initialization Parameters Page10.2.2.10.4. Configuring the Connection Mode Tab10.2.2.11. Configuring the Database Storage Page10.2.2.12. Configuring the Creation Options Page10.2.3. Reviewing the Summary Page10.2.4. Configuring the Database Options10.2.5. Deleting a Database10.2.6. Managing Templates10.3. Building Database Creation Scripts10.3.1. Setting up Admin-Managed Database Scripts10.3.1.1. Executing the ADMIN1.sh Script10.3.1.2. Creating the ADMIN1.sql Script10.3.1.3. Generating the init.ora File10.3.1.4. Executing the CreateDB.sql Script10.3.1.5. Executing the CreateDBFiles.sql Script10.3.1.6. Executing the CreateDBCatalog.sql Script10.3.1.7. Executing the JServer.sql Script10.3.1.8. Executing the xdb_protocol.sql Script10.3.1.9. Executing the ordinst.sql Script10.3.1.10. Executing the intermedia.sql Script10.3.1.11. Executing the emRepository.sql Script10.3.1.12. Executing the apex.sql Script10.3.1.13. Executing the CreateClustDBViews.sql Script10.3.1.14. Executing the lockAccount.sql Script10.3.1.15. Executing the postDBCreation.sql Script10.3.2. Building Policy-Managed Database Scripts10.3.2.1. Executing the POLICY_1.sh Script10.3.2.2. Executing the POLICY_1.sql Script10.3.2.3. Executing the init.ora File for a Policy-Managed Database10.4. Deinstalling the RDBMS Software10.5. Summary
11. Workload Management
11.1. Introducing Services11.1.1. Creating an Administrator Managed Database vs. Policy-Managed Database11.1.2. Managing Services with the Database Scheduler11.1.3. Using Services with Shared Server11.2. Managing Services11.2.1. Managing Services with SRVCTL11.2.2. Managing Services with Enterprise Manager11.2.3. Managing Services with DBMS_SERVICE11.3. Balancing the Workload11.3.1. Configuring Client-Side Load Balancing11.3.2. Configuring Server-Side Load Balancing11.3.3. Exploring the Load Advisory Framework11.3.4. Using Transparent Application Failover11.3.4.1. Configuring Transparent Application Failover11.3.4.2. Using TAF with JDBC Applications11.3.5. Implementing Fast Connection Failover11.3.5.1. Implementing Fast Application Notification11.3.5.2. Implementing a Fast Connection Failover Example11.3.5.2.1. Configuring Tomcat11.3.5.2.2. Preparing the Code11.3.5.3. Establishing Connection Affinity11.3.5.4. Reading FAN events using the FAN API11.4. Using the Resource Manager11.5. Caging an Instance11.6. Database Resident Connection Pool11.7. Summary
12. Oracle Performance Monitoring
12.1. Enterprise Manager Database Control12.1.1. The Cluster Tab12.1.2. The Database Tab12.1.3. The Performance Tab12.2. AWR Reports12.3. Interpreting the RAC Statistics of an AWR Report12.3.1. Top 5 Timed Foreground Events12.3.2. Global Cache Load Profile12.3.3. Global Cache Efficiency Percentages12.3.4. Global Cache and Enqueue Services - Workload Characteristics12.3.5. Global Cache and Enqueue Services - Messaging Statistics12.3.6. Cluster Interconnect12.3.7. Foreground Wait Class12.3.8. Wait Event Histogram12.3.9. "SQL Statement" Sections12.3.10. RAC-Related Segment Statistics12.3.11. Dictionary Cache Stats (RAC)12.3.12. Library Cache Activity (RAC)12.3.13. Global Messaging Statistics12.3.14. Global CR Served Statistics12.3.15. Global Current Served Statistics12.3.16. Global Cache Transfer Statistics12.3.17. Interconnect Statistics12.3.18. Dynamic Remastering Statistics12.4. Active Session History12.5. Automatic Database Diagnostic Monitor12.5.1. Executing an ADDM Report12.5.2. Controlling ADDM12.5.3. The Report Format12.6. AWR SQL Report12.7. Performance Monitoring Using SQL*Plus12.7.1. GV$ Views12.7.2. System Statistics12.7.3. Segment Statistics12.7.4. Global Caches Services: Consistent and Current Reads12.7.5. Global Cache Services: Current Block Activity12.7.6. Global Enqueue Service12.7.7. Library Cache12.7.8. Dictionary Cache12.7.9. Lock Conversions12.8. Automatic Diagnostic Repository12.9. Summary
13. Linux Performance Monitoring
13.1. The uptime and last Commands13.2. The ps Command13.3. free, ipcs, pmap, and lsof13.3.1. The free Command13.3.2. The /proc File System13.3.3. The /sys/devices/system/node File System13.3.4. The ipcs Command13.3.5. The pmap Command13.3.6. The lsof Command13.4. top13.5. vmstat13.6. strace13.7. netstat, ss, and tcpdump13.7.1. Looking at Interface Statistics13.7.2. Summary Statistics13.7.3. Listening Socket Statistics13.7.4. Looking up Well-Known Ports13.7.5. Reporting on Socket Statistics Using ss13.7.6. Capturing and Displaying Network Packets13.8. iostat13.9. mpstat13.10. sar and kSar13.10.1. Configuring sar13.10.2. Invoking sar Directly13.10.3. Graphing the Results13.11. Oracle Cluster Health Monitor13.11.1. Installing the Oracle Cluster Health Monitor13.11.2. Starting and Stopping the Oracle Cluster Health Monitor13.11.3. Understanding the Architecture13.11.4. Installing the Client-Side GUI13.11.5. Viewing Current and Captured Activity13.12. OSWatcher13.12.1. Installing OSWatcher13.12.2. Starting OSWatcher13.12.3. Stopping OSWatcher13.12.4. Viewing Results Graphically13.13. nmon13.14. Summary
14. Parallel Execution
14.1. Parallel Execution Concepts14.1.1. Serial Execution14.1.2. Parallel Execution14.1.3. Producers and Consumers14.1.4. Bloom Filters14.1.5. Partitioning14.2. Parallel Execution Configuration14.2.1. cluster_interconnects14.2.2. db_block_size, db_cache_size, and db_file_multiblock_read_count14.2.3. instance_groups and parallel_instance_group14.2.4. large_pool_size, parallel_execution_message_size, and shared_pool_size14.2.5. parallel_adaptive_multi_user14.2.6. parallel_automatic_tuning14.2.7. parallel_degree_limit14.2.8. parallel_degree_policy, parallel_min_time_threshold, and parallel_servers_target14.2.8.1. Automatic Degree of Parallelism14.2.8.2. Statement Queuing14.2.8.3. In-memory Parallel Execution14.2.9. parallel_force_local14.2.10. parallel_io_cap_enabled14.2.11. parallel_max_servers, parallel_min_servers, parallel_threads_per_cpu, and processes14.2.12. parallel_min_percent14.2.13. pga_aggregate_target14.3. Parallel Execution Performance14.3.1. AWR Reports14.3.2. SQL*Plus14.3.3. Trace Files14.4. Summary
15. Upgrading to Oracle 11g Release 2
15.1. Upgrading Grid Infrastructure Components15.1.1. Installing the Prerequisites15.1.2. Running the Installer15.1.3. Specifying Options15.1.4. Running the Upgrade15.2. Upgrading RAC Software15.2.1. Running the Installer15.2.2. Running Configuration Scripts15.3. Preparing for the Database Upgrade15.3.1. Identifying the Upgrade Path15.3.2. Determine Upgrade Method15.3.3. Testing the Upgrade Process15.3.4. Running the pre-Upgrade Tool15.3.5. Performing Other Checks15.3.6. Saving Current Database Parameters15.3.7. Backing up the Database15.3.8. Configuring the Listener Process15.4. Upgrading Automatically with DBUA15.5. Upgrading a Database Manually15.5.1. Preparing the Parameter Files15.5.2. Preparing Password Files15.5.3. Modifying the Initialization Parameters15.5.4. Restarting the Database in UPGRADE Mode15.5.5. Running the Catalog Upgrade Script15.5.6. Configuring SPFILE15.5.7. Running the post-Upgrade Status Tool15.5.8. Running post-Upgrade Scripts15.5.9. Recompiling Invalid Packages15.5.10. Updating /etc/oratab15.5.11. Updating Environment Variables15.5.12. Updating the Oracle Cluster Registry15.5.13. Setting the Initialization Parameters for the New Release15.6. Performing the Necessary post-Upgrade Steps15.6.1. Completing Mandatory post-Upgrade Tasks15.6.2. Performing the Recommended Tasks15.7. Resolving Problems in Mixed-Database Environments15.8. Using a Swing Kit15.9. Summary

Overview

Pro Oracle Database 11g RAC on Linux provides full-life-cycle guidance on implementing Oracle Real Application Clusters in a Linux environment. Real Application Clusters, commonly abbreviated as RAC, is Oracle's industry-leading architecture for scalable and fault-tolerant databases. RAC allows you to scale up and down by simply adding and subtracting inexpensive Linux servers. Redundancy provided by those multiple, inexpensive servers is the basis for the failover and other fault-tolerance features that RAC provides.

Written by authors well-known for their talent with RAC, Pro Oracle Database 11g RAC on Linux gives you a rock-solid and technically flawless foundation on which to build your RAC-management skills. Authors Julian Dyke and Steve Shaw share their hard-won experience in building RAC clusters, showing you how to build for success using the very latest Oracle technologies, such as Automatic Storage Management (ASM) and Oracle Clusterware. You'll learn to troubleshoot performance and other problems. You'll even learn how to correctly deploy RAC in a virtual-machine environment based upon Oracle VM, which is the only virtualization solution supported by Oracle Corporation.

RAC is a complex and powerful technology. It demands expertise in its deployment. You can't just "wing it" in creating a RAC solution. Julian and Steve have earned the right to term themselves expert—in Pro Oracle Database 11g RAC on Linux, they offer a rigorous and technically-correct treatment of RAC that helps you build a solid foundation of expertise and achieve success.

Rigorous and technically accurate content
Complete coverage of RAC, from planning to implementation to rollout to ongoing maintenance and troubleshooting
Up-to-date with the very latest RAC features

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9781430229582Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills