Oracle 11g R1 / R2 Real Application Clusters Handbook


Oracle 11g R1 / R2 Real Application Clusters Handbook
eBook: $55.99
Formats: PDF, PacktLib, ePub and Mobi formats
$47.59
save 15%!
Print + free eBook + free PacktLib access to the book: $125.98    Print cover: $69.99
$62.99
save 50%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • Design, implement and support complex Oracle 11g RAC environments
  • Understand sophisticated components that make up your Oracle RAC environment such as the role of High Availability, the required RAC architecture, the RAC installation and upgrade process and much more!
  • Get hold of new RAC components such as ASM (Automatic Storage Management) features, performance tuning, and troubleshooting
  • Deploy Oracle 11g with complex standard off-the-shelf ERP systems like Oracle EBS
  • Packed with practical, real-world examples, expert tips, and troubleshooting advice on how to administer a complex Oracle 11g RAC environment
  • Bonus Oracle 11g RAC R2 information included

Book Details

Language : English
Paperback : 676 pages [ 235mm x 191mm ]
Release Date : July 2010
ISBN : 1847199623
ISBN 13 : 9781847199621
Author(s) : Ben Prusinski, Guenadi Jilevski, Syed Jaffar Hussain
Topics and Technologies : All Books, Enterprise Products and Platforms, Enterprise, Oracle

Table of Contents

Preface
Chapter 1: High Availability
Chapter 2: Oracle 11g RAC Architecture
Chapter 3: Oracle 11g RAC Installation
Chapter 4: Oracle 11g Automatic Storage Management
Chapter 5: Managing and Troubleshooting Oracle 11g Clusterware
Chapter 6: RAC Database Administration and Workload Management
Chapter 7: Backup and Recovery
Chapter 8: Performance Tuning
Chapter 9: Oracle 11g Clusterware Upgrade
Chapter 10: Real-world Scenarios
Chapter 11: Enabling RAC for EBS
Chapter 12: RAC and ASM for Advanced Users
Chapter 13: ASM 11gR2 New Features
Chapter 14: Maximum Availability
Appendix: Additional Resources and Tools for The Oracle RAC Professional
Index

    • High availability concepts
      • Planned versus unplanned downtime
      • Service Level Agreements for high availability
      • High availability interpretations
      • Recovery time and High Availability
      • System design for high availability
      • Business Continuity and high availability
        • Disaster Recovery
        • Business Continuity and Disaster Recovery guidelines
    • Fault tolerant systems and high availability
      • Requirements for implementing fault tolerance
      • Fault tolerance and replication
    • High Availability solutions for Oracle
      • Oracle Data Guard
      • Oracle Streams
      • Oracle Application Server Clustering
      • High Availability: Oracle 11g R1 Real Application Clusters (RAC)
      • High Availability: Oracle 11g R2 Real Application Clusters (RAC)
    • Summary
    • Oracle 11g RAC architecture
      • Certification matrix for Oracle 11g RAC architecture
    • Hardware architecture for Oracle 11g RAC
      • Server configurations for Oracle 11g RAC
      • CPU processors
        • Choosing between 32-bit and 64-bit CPU architectures
        • Dual core and multicore processors
    • Network architecture for Oracle 11g RAC
      • Private network and the Oracle 11g RAC interconnect
        • Choices for private interconnect and 11g RAC
      • Redundancy for Ethernet interconnects with 11g RAC
        • Network bonding (NIC teaming)
    • Storage architecture for Oracle 11g RAC
      • RAID configurations for Oracle 11g RAC
        • RAID 0 (striping)
        • RAID 1 (mirroring)
        • RAID 5 (striped with parity)
        • RAID 10 (striped mirrors)
      • Third-party RAID implementations
        • IBM AIX LPAR disk volume management for RAID
        • Linux volume management for RAID configuration
    • Storage protocols for RAC
      • SCSI
      • Fibre Channel
        • Point to Point (FC-P2P)
        • Fibre Channel Arbitrated Loop (FC-AL)
        • Fibre Channel Switched Fabric (FC-SW)
      • Which Fibre Channel topology is best?
      • iSCSI
      • Which storage protocol is best for RAC?
        • Asynchronous I/O versus Direct I/O for Oracle 11g RAC
    • Oracle 11g RAC components
      • Voting Disk
      • Oracle Cluster Registry
      • Oracle 11g R1 RAC background processes
        • ACMS Atomic Controlfile to Memory Service
        • GTX0-j Global Transaction Process
        • LMON Global Enqueue Service Monitor
        • LMD Global Enqueue Service Daemon
        • LMS Global Cache Service Process
        • LCK0 Instance Enqueue Process
        • RMSn Oracle RAC Management Processes
        • RSMN Remote Slave Monitor
      • Oracle 11gR2 RAC background processes
        • Grid Plug and Play
        • Grid Interprocess Communication
        • Multicast Domain Name Service
        • Oracle Grid Naming Service
      • How RAC differs from Oracle 11g single instance
    • New ASM features and RAC
      • New SYSASM privilege for Oracle 11gR1 ASM
      • Oracle 11gR2 ASM features
        • OCR and voting disk stored in ASM
        • Oracle Automatic Storage Management Cluster Filesystem (Oracle ACFS)
    • New Oracle 11g ASM Disk Group compatibility features
    • Summary
    • What's new in Oracle Clusterware installation and configuration?
    • Oracle Clusterware installation configuration requirements
      • Oracle Clusterware preinstallation tasks
    • Installing Oracle Clusterware 11gR1
    • Installing Oracle RDBMS software 11gR1
    • Installing Oracle Clusterware 11gR2
    • Installing Oracle RDBMS software 11gR2
    • Installing Oracle RDBMS software 11gR2 RAC ONE Node
    • Summary
    • A brief overview of Oracle Automatic Storage Management (ASM)
    • Understanding Automatic Storage Management concepts
      • ASM Instances
        • Single-node configuration with one ASM instance
        • ASM cluster configuration with Oracle RAC
        • ASM cluster with single-instance Oracle databases
      • ASM disk groups
      • Mirroring and failure groups
      • ASM disks
        • Allocation units
      • ASM files
        • Extents
        • ASM striping
        • File templates
    • Automatic Storage Management features in Oracle 11gR1
      • Improved scalability and performance
        • Fast mirror resync
        • VLDB support
        • Multiple allocation unit size
        • Faster rebalance with restricted mount option
        • Preferred mirror read
      • ASM rolling upgrades and patching
      • Manageability enhancements
        • Tablespace level Migration Wizard in Enterprise Manager
        • Disk Group compatibility attributes
        • New ASMCMD commands
        • SYSASM role
        • Mount/Drop FORCE disk group
    • Automatic Storage Management features in Oracle 11gR2
      • General purpose ASM Cluster File System
      • ASM Dynamic Volume Manager
      • Snapshot data service for ACFS
      • Oracle Clusterware OCR and Voting File Support
      • Extensions for system and database administrators
        • ASM installation and configuration tools
        • Full-featured ASMCMD extensions
      • Functional enhancements
        • ASM file Access Control
        • ASM disk group rename
        • ASM file mapping
        • ASM 4 K sector size support
      • Tunable performance
    • Summary
    • Oracle 11g RAC Clusterware administration
      • About Oracle Clusterware
      • Oracle 11g Clusterware concepts
        • Oracle Cluster Registry
        • Voting disk
        • Initialization and shutdown scripts for Clusterware
        • Oracle 11g Clusterware background processes
        • Cluster Ready Services Daemon
        • Additional background processes for Oracle 11g Clusterware
      • Fatal Clusterware processes and Oracle 11g RAC
    • Managing Oracle 11g Clusterware utilities
      • CRSCTL
      • CRS_STAT
      • OCRCHECK
      • OCRCONFIG
      • CLSCFG
      • CLUVFY
    • Troubleshooting Oracle 11g Clusterware
      • Failed, missing, or offline 11g Clusterware resources
        • Offline Clusterware resources for Oracle 11g RAC
      • Problems with the Voting disk and OCR
        • Vote Disk issues with 11g Clusterware resources
        • Failed or corrupted Vote Disks
      • Failed or corrupted OCR
        • How to recover the OCR from backup
        • Steps to perform recovery of lost and/or corrupted OCR
        • Check status 11g RAC Clusterware
        • Root cause analysis 11g RAC
      • Oracle 11g RAC node reboot issues
        • Oracle 11g RAC Clusterware processes—node reboot issues
        • Root cause analysis for solving node reboots with 11g RAC
        • OCSSD Reboots and 11g RAC
        • OPROCD failure and node reboots
        • OCLSOMON-RAC node reboot
      • Hardware, storage, and network problems with RAC
        • Hardware, storage, and network resolutions
    • New features in Oracle 11g R2 Clusterware
      • Oracle Real Application Clusters one node (Oracle RAC one node)
      • Improved Oracle Clusterware resource modeling
      • Policy-based cluster and capacity management
      • Cluster time synchronization service
      • Oracle Cluster Registry and voting disks within Oracle ASM
      • New features for upgrading to Oracle 11g Clusterware
      • Oracle 11gR2 Cluster Verification Utility new features
      • Zero downtime patching for Oracle Clusterware
  • Summary
    • RAC database configuration and creation
      • Creating a database using DBCA
        • Choosing database storage options
        • We have created a database using DBCA—now what?
    • What's new in Oracle 11g R1 and R2 database?
      • Automatic Memory Management
        • New AMM dynamic performance V$ views
        • Tuning AMM
      • Database smart flash cache
        • Configuring Smart Flash Cache
      • Instance caging
      • New background processes in Oracle 11g
        • Finding alert.log file location in Oracle 11g
        • Automatic Diagnostic Repository
        • V$DIAG_INFO view
    • RAC database administration
      • Using the Server Control Utility
    • Automatic Workload Management
      • Overview of services
        • Creating and managing services
    • What's new in Oracle 11g services behavior?
      • Scalability (Load Balancing)
        • Client Side Connect Time Load Balance
        • Server Side Listener Connection Load Balance
      • Transparent Application Failover
        • Configuring Transparent Application Failover
      • Fast Connection Failover
        • Configuring Fast Connection Failover
    • Summary
    • Backup and recovery strategies
      • Export and import
      • User backups with scripts
      • Using third-party tools for backup
      • RMAN backup and recovery
        • Let's back up
        • Let's restore and recover
    • RMAN new features
      • Oracle database 11g Release 1
        • Data Recovery Advisor
        • Multisection backups
        • Fast backup compression
        • Network-enabled database duplication
        • Virtual private catalog
        • Integration with Windows Volume Shadow Copy Services
      • Oracle Database Database 11g Release 2
        • Oracle secure backup (OSB) cloud module
        • DUPLICATE database command enhancements
        • RMAN tablespace point-in-time recovery (TSPITR) enhancements
        • Automatic block repair
        • SET NEWNAME options
        • CONVERT DATABASE option
        • Expanded backup compression levels
        • INCARNATION specifier enhancement
        • Backup command enhancements
    • OCR and voting disk backup and recovery
      • Backing up voting disks
        • Recovering voting disks
        • Adding and removing voting disks
      • Backing up OCR
        • Recovering the OCR using manually or autogenerated backups
        • Recovering the OCR using manually generated exports
    • Summary
    • Single-instance database versus parallel database tuning considerations
      • Oracle 11g single-instance database
      • Oracle RAC 11g database
      • Oracle Parallel Server (OPS)
    • New Oracle 11g performance tuning features
      • New performance features in Oracle 11gR1
        • Database Replay
        • SQL Performance Analyzer
        • Database Health Monitor
        • PL/SQL Native Compilation
        • Server Result Cache
        • Client Side Result Cache
        • SQL Tuning Automation
        • Enhanced statistics maintenance
        • SQL Plan Management
        • Automatic Database Diagnostic Monitor (ADDM) new features
        • Automatic Workload Repository new features
      • New performance features in Oracle 11gR2
        • In-Memory Parallel Execution
        • Auto Degree of Parallelism and Queuing
        • The DBMS_PARALLEL_EXECUTE package
        • Significant performance improvement of On Commit Fast Refresh
    • An overview of Oracle RAC Architecture
    • Tune Instance recovery in RAC
    • Analyzing the Cache Fusion impact on RAC performance
      • Cache Fusion
      • Latency statistics
      • RAC wait events
    • Examples of inter-instance communication
      • Global resources
      • Examples of known areas for tuning
        • RAC and Oracle sequences
        • RAC and undo
        • RAC and segments high watermark
    • Monitoring RAC cluster interconnect performance
      • Oracle cluster interconnects
      • Hardware solution
        • Sun aggregation and multipathing
        • HP Auto Port Aggregation
        • AIX etherchannel
        • Cisco EtherChannel
        • Linux IP Bonding
        • Windows NIC teaming
      • TCP/IP setup and tuning
        • Jumbo frames and MTU
        • UDP and TCP settings
        • Flow control
        • Full-bit rate
        • Full duplex versus half duplex
        • Network RAC specifics
    • Monitoring RAC-specific wait events, global enqueues, and system statistics
    • Summary
    • Overview of an upgrade
      • Upgrade sequence
    • Upgrading Oracle 10gR2 Clusterware to Oracle 11gR1
      • Kernel parameter values
      • Packages required on Linux 5
      • Oracle 11g R1 Clusterware upgrade steps
        • Performing preinstallation checks with cluvfy
        • Executing runInstaller.sh script
        • Post-upgrade steps for 11gR1 Clusterware
    • Upgrading to Oracle 11gR2 Clusterware
      • Overview of our environment
        • Upgrading nodes
        • 11gR2 upgrade changes and restrictions
        • Kernel parameter values
        • Packages required on Linux 5
        • Performing preinstallation checks with cluvfy
      • Oracle 11g R2 Clusterware upgrade steps
        • Executing the runInstaller.sh script
        • Post-upgrade checks for 11gR2 Clusterware
        • Post-upgrade steps for 11gR2 Clusterware
    • Downgrading Oracle Clusterware after an upgrade
    • Summary
    • Adding a new node to an existing cluster
      • Performing prechecks with cluvfy utility
        • addNode.sh
      • Adding a node in silent mode in Oracle 11gR2
      • Post-installation status checks for Clusterware
        • OCR file manual backup syntax
        • Voting Disk backup syntax
      • Installing ASM and RDBMS software using addNode.sh script
        • Cloning ASM software using addNode.sh script on Oracle 11gR1
        • Post-node addition steps
    • Removing a node from the cluster
    • Adding an RAC database instance
      • Adding new instance using DBCA
        • We have added an instance—what next?
        • Verifying new instance status
        • Using DBCA in silent mode to add an instance
        • Post-add instance steps
    • Deleting an RAC database instance
      • Using DBCA in silent mode to delete an instance
    • Converting a single-instance database to an RAC database
      • Overview of RCONFIG command-line tool
        • What you need to accomplish the conversion task
        • Example of a modified ConvertToRAC.xml input file
      • How to test a conversion without actually performing the conversion?
    • Converting a single-instance database to an RAC database
      • How to resume a failed rconfig operation?
      • Checking log files
    • How to optimize rconfig to run faster?
    • Post-conversion steps
  • Relocating an RAC database and instances across nodes
    • Relocating the instance
      • Adding the instance example
    • Workaround when a database and instance is configured on the same node
      • Adding the database example
    • Post-relocation steps
  • Summary
    • EBS architecture
    • Oracle 11g RAC suitability
    • Installing EBS 12.1.1
    • EBS implementation on Oracle 11g RAC
    • RAC enabling EBS 12.1.1
      • Cluster terminology overview
      • Configuration prerequisites
        • ASM and RAC enabling the EBS database with rconfig utility
        • Running AutoConfig
      • Establishing Applications Environment for Oracle RAC
        • Setting up load balancing
        • Configuring Parallel Concurrent Processing
    • Summary
    • What types of files does ASM support?
      • About ASM filenames
        • Single file creation request
        • Multiple file creation request
        • Fully qualified ASM filename
        • Numeric ASM filename
        • Alias ASM filenames
        • Alias ASM filename with template
        • Incomplete ASM filename
        • Incomplete ASM filename with template
    • Creating and referencing ASM files in the database
      • Creating ASM files using a default disk group specification
        • Creating a datafile using a default disk group
      • Using ASM filenames in SQL statements
    • Managing alias names for ASM filenames
      • Adding an alias name for an ASM filename
      • Renaming an alias name for an ASM filename
      • Dropping an alias name for an ASM filename
      • Dropping files and associated aliases from a disk group
    • Accessing ASM files with the XML DB virtual folder
      • Inside /sys/asm
        • Sample FTP session
    • Using DBMS_FILE transfer utility for ASM
    • Managing disk group directories
      • Creating a new directory
      • Renaming a directory
      • Dropping a directory
    • Managing disk group templates
      • Template attributes
      • Adding templates to a disk group
      • Modifying a disk group template
      • Dropping templates from a disk group
      • Creating tablespaces in ASM: Specifying redundancy and striping with templates
    • ASM Command-line utility
      • About ASMCMD
      • ASM files, filenames, directories, and aliases
        • System-generated filename or fully qualified filename
        • Directory
        • Aliases
        • Absolute path and relative path
        • Wildcard characters
      • Running ASMCMD
        • Preparing to run ASMCMD
      • ASMCMD command reference
        • cd command
        • cp command
        • du command
        • exit command
        • find command
        • help command
        • ls command
        • lsct command
        • lsdg command
        • lsdsk command
        • md_backup command
        • md_restore command
        • mkalias command
        • mkdir command
        • pwd command
        • remap command
        • rm command
        • rmalias command
    • Deploying ASM using SQL*Plus
      • Creating a database that uses ASM
      • Creating tablespaces in ASM
      • Creating redo logs in ASM
      • Creating control files in ASM
      • Creating archive log files in ASM
    • Summary
    • Automatic Storage Management Configuration Assistant (ASMCA)
      • Initiating ASMCA
      • Creating a new ASM Instance
      • Managing an ASM Instance
      • Managing ASM disks
        • Creating a new disk
    • Automatic Storage Management Dynamic Volume Manager (ADVM)
      • ADVM volume facts
      • Creating ASM volumes
        • Creating ASM volumes by ASMCA
        • Creating ASM volumes by ASMCMD
        • Creating and managing ASM volumes by ALTER DISKGROUP SQL statement
      • Query V$ASM views to obtain information about ASM volumes
    • Automatic Storage Management Cluster File System (ACFS)
      • Using ACFS as Oracle Database Homes
      • Oracle ACFS drivers
      • Prerequisites to create ACFS
      • ACFS creation methods
        • Creating an ACFS filesystem using ASMCA
        • Creating an ACFS filesystem for Oracle Binaries using ASMCA
        • Creating an ACFS filesystem using ASMCMD
      • An ACFS mount registry
      • Managing ACFS
        • acfsutil utility
      • ASM new background processes to support ACFS
        • Volume Driver Background (VDBG)
        • Volume Background process (VBGn)
        • ACFS Background process (ACFS)
        • Volume Membership Background processes (VMB0)
      • Query V$ASM views to obtain information about ACFS
    • ACFS snapshots
      • Creating a snapshot
      • Removing a snapshot
    • ASM Intelligent Data Placement (IDP)
      • Managing IDP settings
      • Finding IDP setting information
    • ASMCMD enhancements
    • Summary
    • Oracle 11g Streams for RAC
      • Oracle 11g Streams architecture for RAC
        • Capture
        • Staging
        • Propagation
        • Consumption
        • Default apply
        • User-defined function apply
        • Explicit de-queue
        • Understanding Oracle Streams rules
        • Transformations and Streams
        • Capture and apply processes in an RAC Instance
        • Streams in the RAC environment
      • New features in Oracle 11g Streams
        • Synchronous Capture
        • Splitting and merging of a Stream Destination
        • Tracking LCRs through a Stream
        • Streams Topology and Performance Advisor
        • Combined Capture and Apply
    • Best practices for Streams in an RAC environment
      • Additional configuration of RAC environments for a Source Database
        • Queue ownership
        • Propagation restart
        • Changing the GLOBAL_NAME of the source database
      • Additional configuration for RAC environments for the Apply Database
        • Changing the GLOBAL_NAME of the Target Database
    • New features for Streams in Oracle 11gR2
      • XStream
      • Statement DML Handlers
      • Ability to record table changes
      • SQL generation
      • Support for compressed tables
      • Support for SecureFile LOBs
      • Automatic splitting and merging
      • New Apply Process Parameter
      • Monitoring jobs
      • New 11g R2 Oracle Streams View
    • Oracle 11g Data Guard and RAC
      • New Features for Oracle 11g Data Guard
        • Active Data Guard
        • Snapshot Standby
      • Configuring Data Guard Physical Standby for 11g RAC
        • Configuring Oracle RAC primary database to send redo data
      • Design considerations in an Oracle RAC environment
        • Format for archived redo log filenames
      • Switchover considerations for 11g RAC and Data Guard
      • Troubleshooting Oracle 11g Data Guard and RAC
        • Switchover fails in an Oracle 11g RAC Configuration
        • How to recover from corrupt datafile on standby
        • How to recover from corrupt block on standby
        • Automatic repairing of corrupt data blocks
    • New features for Data Guard in Oracle 11gR2
      • New Oracle Data Guard 11g R2 features for Redo Apply
      • New Oracle 11g R2 Data Guard features for SQL Apply
    • Summary
    • Sample configurations
      • Reviewing and resolving manual configuration changes
        • adchkcfg utility
    • Oracle RAC commands and tips
      • Cluster deconfig tool for Oracle RAC
        • Using the cluster deconfig tool
        • Limitations of the cluster deconfig tool
        • Problems and limitations of the Cluster Deconfig tool
        • Starting the cluster deconfig tool
        • Silent mode operations using cluster deconfig
      • Manual cleanup for RAC
        • Repairing the RAC environment without reinstalling
      • Reinitializing OCR and Voting Disks without reinstalling RAC
      • Using ROOTDELETE.SH in debug mode
      • Using rootdeinstall.sh
      • Reinstalling CRS on the same cluster in another CRS_HOME
        • Stopping CRS processes
      • Reinstalling CRS on same cluster in another CRS_HOME
      • Oracle 11gR2 cluster removal tools for RAC
      • Tracing RAC issues with Oradebug
        • Using Oradebug to trace Oracle 11g Clusterware
      • Server Control Utility
        • Oracle 11gR2 SRVCTL commands
      • Managing Oracle Clusterware with the CRSCTL utility
        • Differences between 11gR1 and 11gR2 syntax for CRSCTL
    • Operating system-level commands for tuning and diagnosis
      • STRACE
      • TRUSS
      • GDB
    • Additional references and tips
    • Clusterware startup sequence for Oracle 11gR2
    • Log file locations for Oracle 11g RAC and ASM

 

Ben Prusinski

Ben Prusinski is an Oracle Certified Professional (OCP) and database architect with more than 14 years of experience with Oracle data warehouse and Oracle E-Business applications. As a corporate database consultant, Ben has provided services to dozens of Fortune 500 clients. He is an internationally recognized expert in Oracle high availability, performance tuning, database security, and ERP implementations. As a top Oracle expert, Ben received the prestigious Oracle ACE award in 2009 in recognition of his contributions to the Oracle community. As an Oracle RAC Certified Expert (OCE), Ben is also a popular speaker at major conferences such as Oracle OpenWorld, CLOUG in Latin America, IOUG, and Oracle Collaborate OAUG (Oracle Applications User Group). Ben also is a board member of the San Diego Oracle Applications User Group (SDOUAG) where he organizes events for southern California.

Guenadi Jilevski

Guenadi Jilevski is a Senior Oracle Professional with more than 20 years of industrial experience in high end Oracle technology starting with Oracle RDBMS version 6 up to 11g. He has been involved with multi platform High Availability Solutions starting with OPS and Veritas and Sun cluster as well as complex multiple node RAC 9i, 10g and 11g implementations on AIX, Linux, Solaris, and HP. He has experience in deploying disaster recovery solutions with standby databases compliant to Oracle MAA and third-party solutions such as Shareplex and Goldengate. As a former employee of Oracle Corporation Advanced Technology Solutions Consulting Practice in the Americas, Guenadi has been involved in multiple visible high-end projects for RAC enabling EBS, Peoplesoft, Siebel ERP applications, end-to-end performance tuning, architectured High Availability, and Disaster Recovery solutions to name a few. Presently he is working as a Senior Oracle Consultant in EMEA. He is a speaker on Oracle User Groups and also instructs users through his blog: "Oracle RAC, DG, EBS, DR and HA DBA". Guenadi is Oracle OCP 7, 8, 8i, 9i and Oracle OCM, Teradata Certified DBA, Informix Certified DBA.

 


Syed Jaffar Hussain

Syed Jaffar Hussain is an Oracle Certified Master (10g), Oracle ACE, Oracle RAC Certified Expert and OCP v8i, 9i, and 10g DBA having over 17 years of Information Technology experience, which includes over 9 years as an Oracle DBA. Over the past 9 years, he has worked as an Oracle consultant with many international clients (mostly in the banking sector) and has been involved in several challenging projects such as implementing RAC, setting up Data Guard for all the business critical databases, tuning databases to increase the throughput, and database migration/upgrade on various operating systems. Syed frequently participates in delivering Oracle University advanced 5-day courses and one-day RMAN seminars on behalf of Oracle EMEA. He also shares his knowledge in several Oracle-related forums and often updates his blog.

 

Sorry, we don't have any reviews for this title yet.

Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

Oracle 11g R1 / R2 Real Application Clusters Handbook +    Oracle User Productivity Kit 3.5 =
50% Off
the second eBook
Price for both: $68.60

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • Administer, implement, and manage Oracle 11g RAC environments for real-world deployments
  • Understand the high availability concepts and solutions that are available for Oracle 11g RAC
  • Discover the key architectural design and installation techniques required to successfully deploy Oracle 11g RAC
  • Add functionality to your RAC environment by incorporating new RAC features such as Automatic Storage Management
  • Effectively manage the complex 11g Clusterware, using key troubleshooting tips and techniques.
  • Successfully implement database creation methods, manage the RAC database, and handle workload in your RAC environment efficiently
  • Plan your backup and recovery strategy appropriately
  • Know when and how to upgrade your RAC environment effectively
  • Deploy Oracle 11g RAC with complex standard-off-the-shelf systems like Oracle EBS
  • Understand key new features for 11g R1/R2 RAC and ASM

In Detail

RAC or Real Application Clusters is a grid computing solution that allows multiple nodes (servers) in a clustered system to mount and open a single database that resides on shared disk storage. Should a single system (node) fail, the database service will still be available on the remaining nodes. RAC is an integral part of the Oracle database setup: one database, multiple users accessing it, in real time. This book will enable DBAs to get their finger on the pulse of the Oracle 11g RAC environment quickly and easily.

This practical handbook documents how to administer a complex Oracle 11g RAC environment. It covers all areas of the Oracle 11g R1 RAC environment, with bonus R2 information included, and is indispensable if you are an Oracle DBA charged with configuring and implementing Oracle11g. It presents a complete method for the design, installation, and configuration of Oracle 11g RAC, ultimately enabling rapid administration of Oracle 11g RAC environments.

Packed with real-world examples, expert tips, and troubleshooting advice, the book begins by introducing the concept of RAC and High Availability. It then dives deep into the world of RAC design, installation, and configuration, enabling you to support complex RAC environments for real-world deployments. Chapters cover RAC and High Availability, Oracle 11g RAC Architecture, Oracle 11g RAC Installation, Automatic Storage Management, Troubleshooting, Workload Management, and much more.

By following the practical examples in the book, you will learn every concept of the RAC environment and how to successfully support complex Oracle 11g R1 and R2 RAC environments for various deployments in real-world situations.

Approach

This is a handbook aimed at DBAs, which documents how to administer a complex Oracle 11g RAC environment. It covers new RAC components such as new features of ASM (Automatic Storage Management), performance tuning, and troubleshooting. It contains real-world examples, expert tips, and troubleshooting advice. This book focuses on Oracle RAC 11g R1 with additional 11g R2 information included.

Who this book is for

If you are an Oracle DBA who wants to administer Real Application Clusters, then this book is for you. Basic understanding of Oracle DBA is required, but no experience of RAC is needed.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software