Oracle Database 10g R2: Administering RAC

Oracle Database 10g R2: Administering RAC

The Oracle Database 10g R2: Administering RAC (1Z0-048) exam is primarily intended for the implementation consultants that have the training and knowledge to efficiently configure and administer a database for use with Real Application Clusters.

Oracle Partners passing this exam will be recognized as OPN Certified Specialists. Prerequisites or additional requirements apply. Please click on the certification link for further clarification. This certification helps their companies qualify for the Oracle Real Application Clusters Specialization.

Exam Number:
135 minutes
Total for both sections
Associated Certifications:
Oracle Database 10g: Real Applications Clusters Administrator Certified Expert

OPN Certified Specialist
Number of
for both sections combined.
Exam Price:
US $195
Pricing may vary slightly by country or by localized currency. Check Pearson VUE’s website for exact pricing in your country.
RAC Administration Section: 60%
Cluster Management Section: 60%

There are two sections to this exam. Both sections of the exam MUST be passed in order the pass the exam.

Passing score subject to change. View Details
Click Here to Register:


Recommended Training Additional Information & Resources Exam Topics Fraudulent Activity Policy

Mandatory Training
Candidates who are not already certified as 10g or 11g DBA OCPs must complete one of the online or in class instructor led courses below to obtain this certification. Candidates who already hold a 10g or 11g DBA OCP do not need to complete the training requirement.

Oracle Database 10g: RAC for Administrators Release 2 OR
Oracle Database 11g: RAC Administration OR
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated Release 2 OR
Oracle 10g Database: RAC Deployment Workshop OR
Oracle Database 10g: Real Application Clusters



Recommended Training
Oracle Database 10g R2: Administering RAC - Exam Study Guide

OPN Guided Learning Path
Oracle Real Application Clusters 10g Implementation Specialist

Oracle University Training
Oracle Database 10g: RAC for Administrators Release 2



Additional Information & Resources
Exam Retake Policy
Specialization Catalog (PDF) for all launched and planned Specializations
Product Mapping to Specialization (XLS)
Sample Questions
Oracle Database 10g: RAC Expert Candidate Guide

The exam is based on Oracle Database 10g R2. Those who prepared using the Oracle Database 10g: Real Application Clusters training for Release 1 will need to ensure they are familiar with changes between R1 and R2.

Both sections of the exam MUST be passed in order the pass the exam. The final score is not cumulative.



Exam Topics

Section I : RAC Administration
RAC Installation

  • Install and configure Automatic Storage Management (ASM)
  • Install the Oracle database software
  • Perform pre-database creation tasks

Database Creation

  • Install the Enterprise Manager agent on each cluster node
  • Create a cluster database
  • Perform post-database creation tasks

RAC DB Administration

  • Use Enterprise Manager cluster database pages
  • Define and manage redo log files in a RAC environment
  • Define and manage undo tablespaces in a RAC environment
  • Start and stop RAC databases and instances
  • Modify initialization parameters in a RAC environment
  • Create and manage ASM instances in a RAC environment
  • Create and manage ASM Disk Groups and ASM Files

Backup and Recover a RAC DB

  • Configure the RAC database to use ARCHIVELOG mode and the flash recovery area
  • Configure RMAN for the RAC environment
  • Explain the implications of OracleNet for connecting RMAN for parallel backups

RAC DB Monitoring and Tuning

  • Explain RAC-specific tuning considerations and techniques in an environment involving mixed workloads
  • Tune instance recovery in RAC
  • Determine RAC-specific wait events, global enqueues, and system statistics
  • Diagnose and improve common RAC-specific performance problems involving indexes, sequences and undo
  • Use the Cluster Database Performance pages
  • Use the Automatic Workload Repository (AWR) in RAC
  • Use Automatic Database Diagnostic Monitor (ADDM) in RAC


  • Configure and manage services in a RAC environment
  • Connect your client to a RAC database using services
  • Use services with the Database Resource Manager
  • Use services with the Scheduler
  • Set performance-metric thresholds on services
  • Configure services aggregation and tracing

High Availability of Connections

  • Configure client-side connect-time load balancing
  • Configure client-side connect-time failover
  • Configure server-side connect-time load balancing
  • Use the Load Balancing Advisory (LBA)
  • Describe the uses of Fast Application Notification
  • Describe the uses of server-side callouts
  • Describe the purposes of server- and client-side ONS
  • Configure Transparent Application Failover (TAF)

Design for HA

  • Design a Maximum Availability Architecture in your environment
  • Determine the best RAC and Data Guard topologies for your environment
  • Explain Data Guard Broker configuration files in a RAC environment
  • Decide on the best ASM configuration to use
  • Patch your RAC system in a rolling fashion

RAC Technology Overview

  • Recommend appropriate use and possible application of RAC technology to address scalability, high availability and grid provisioning requirements

Section II : Cluster Management Oracle Clusterware Installation

  • Describe the capabilities and features of Oracle Clusterware
  • Perform preinstallation and cluster setup tasks
  • Install Oracle Clusterware
  • Describe the different storage options and their implications (OCFS, raw disks, ASM)

Oracle Clusterware Administration

  • Manually control the Oracle Clusterware stack
  • Change voting disk configuration
  • Back up and recover your voting disks
  • Manually back up and recover the OCR, and repair the OCR configuration
  • Explain application VIPs and change VIP addresses
  • Use Clusterware to protect non-Oracle applications
  • Prevent automatic instance restarts

Diagnosing the Oracle Clusterware components

  • Enable and collect diagnostics for Oracle Clusterware
  • Set debugging flags for OCR-related tools
  • Enable Oracle Clusterware debugging
  • Enable tracing for Java-based tools
  • Use Cluster Verify

Node Addition and Removal

  • Add a new node to your cluster database
  • Remove a node from your cluster database



Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.

View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.

 E-mail this page  Printer View