Oracle Internals
JulianDyke.com

Welcome

Consultancy

Seminars

Blog

Presentations

Diagnostics

Internals

 

Introduction Contents Errata

Pro Oracle Database 10g RAC on Linux

Contents

Chapter 1 Introduction to RAC
  A brief discussion of the advantages and disadvantages of RAC databases containing a look at the benefits and costs and comparisons with alternatives.
Chapter 2 Introduction to Linux
  Introduces the supported versions of Linux including Red Hat Enterprise Linux and SUSE Linux Enterprise
Chapter 3 RAC Concepts
  Includes a overview of RAC concepts including node applications, database structure, instances, parameters, background processes, workload management, administration, tools and utilities, monitoring, backup and recovery, and disaster recovery.
Chapter 4 RAC Design
  Describes RAC-specific design requirements including hardware architectures, storage, application and database design
Chapter 5 Benchmarking Concepts
  Contains an introduction to benchmarking requirements
Chapter 6 Hardware
  Describes the hardware required for a successful RAC deployment including processors, memory and networking considerations
Chapter 7 Storage
  Contains a detailed introduction into storage management. Includes configuration of EMC Clariion Storage Area Networks and Network Appliance Filers
Chapter 8 Oracle Cluster File System (OCFS)
  Includes OCFS Version 1 and the newly supported OCFS Version 2 (OCFS2)
Chapter 9 Automatic Storage Management (ASM)
  Describes the installation, configiuration and administration of Automatic Storage Management (ASM) available in Oracle 10.1 and above.
Chapter 10 Installing Linux
  Includes installation of both Red Hat Enterprise Linux 4.0 and SUSE Linux Enterprise 9.0
Chapter 11 Configuring and Verifying Linux
  Describes the configuration steps required for an Oracle RAC database server following operating-system installation. Covers kernel and network parameters, Secure shell (ssh) configuration, disk configuration, user and group creation. Also describes the new cluster verification utility (CLUVFY) introduced in Oracle 10.2.
Chapter 12 Installing and Configuring Oracle Software
  Includes installation of Oracle Clusterware and Oracle Database Software using the Oracle Universal Installer (OUI)
Chapter 13 Creating and Configuring Databases
  Describes the creating and configuration of databases using the Database Configuration Assistant (DBCA) tool. Also covers manual creation of databases using scripts generated by DBCA.
Chapter 14 Installing and Configuring Enterprise Manager
  Describes the installation and configuration of Enterprise Manager Database Control and Grid Control in both single-instance and RAC environments.
Chapter 15 Linux Administration
  A brief discussion of Linux operating system adminstration concentrating on areas where Linux differs signficantly from proprietary UNIX operating systems.
Chapter 16 Oracle Clusterware
  Describes Oracle Clusterware configuration and administration including tools such as CRSCTL, CRS_STAT, OCRCONFIG, OCRCHECK and OCRDUMP
Chapter 17 Application Development
  Highlights some portability issues for applications being migrated to RAC. Also describes developing applications which use Transparent Application Failover (TAF), Fast Application Notification (FAN), Fast Connection Failover (FCF) and the Oracle Clusterware High Availability Framework
Chapter 18 Using Administrative Tools
  Describes use of Enterprise Manager, SVRCTL and SQL*Plus to administer Oracle RAC databases
Chapter 19 Workload Management
  Includes new Oracle 10.2 workload management features. Also describes configuration and administration of Oracle database services.
Chapter 20 Adding and Deleting Nodes and Instances
  How to add a new node to an existing cluster and how to delete an existing node.
Chapter 21 Trace and Diagnostics
  How to configure and interpret trace and diagnostics created using symbolic dumps and the ORADEBUG tool
Chapter 22 RAC Internals
  Examines internal behaviour of Oracle RAC databases including Global Cache Services (GCS) and Global Enqueue Services (GES).
Chapter 23 Benchmarking Tools - Hammerora and Swingbench
  Includes a detailed examination of the freely available Hammerora and Swingbench load generation tools
Chapter 24 Performance Monitoring
  Performance monitoring and tuning using Automated Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Active Session History (ASH). Also discusses operating system performance monitoring tools.
Chapter 25 Backup and Recovery
  Includes a detailed look at backup and recovery using RMAN.
Chapter 26 Disaster Recovery
  Includes detailed examples of Oracle Data Guard physical standby database on a 2-node RAC database
Appendix Third Party Clustering Solutions
  Written by Kevin Closson, includes a brief look at the capabilities of Polyserve Matrix Server