Skip to content

Archive for

Active/passive vs active /active Cluster


An active/passive cluster generally contain two identical nodes.At any time, one of the nodes is active and the other is passive.Oracle singel instance database software is installed on both nodes, but the database is located on shared storage.During normal operation, the Oracle database instance runs only on the active node.In the event of a failure of the currently active primary system,clustering software will transfer control of the disk subsystem to the secondary system, a process known as failover.As part of the failover process, the Oracle instance on the secondary nose is started, thereby recovering and resuming the service of the Oracle database. All connections to the instance on the primary system at the time of failure are terminated and must be reestablished withe the new instance on the secondary system.On resolution of the issue, the Oracle instance is cleanly shut down on the secondary system , control of the disk subsystem is transfered back to the primary system and oracle instance is started to resume normal operations.

a number of third party products are avilable to implement active /passive clustering on linux.


An active /active cluster has an identical hardware infrastruture to an active /passive one. However, Oracle instances run concurrenlty on both servers and access the same database. which is located on shared storage. The instances must communicated with each other to negotiate access to shared data in the database. In the event of a server failure, the remaining server can continue processing the workload and optionally failed sessions can be reconnected . the benefit of an active / active cluster over an active/passive cluster is that,during normal processing, the workload can be shared across both servers in the cluster

Oracle RAC is desighned to run in an active / active enviornment.

RAC first day class

Today I went to attend the my first day class about Oracle Real Application Cluster. The class taken by Mr.Syed Jaffar Hussian.I thought Why i want to explain about himself.Because almost all of them(oracle Community) know about him,He is one of the famous person and outstanding DBA in this world.However I briefly explain about my trainer.He is an Oracle Certified Master (First person in Saudi Arabia) and He also Oracle ACE member and he is one of the author of upcoming book of Oracle R1/R2 RAC handbook and He is reviewer of Oracle books and he given seminar for some Organization about RMAN and RAC .I hope I will become a RAC expert after finish this course.

Today He given overviwed about Course Agenda what he will take class in future..

Cluster Introduction with its advantages.

What is Oracle RAC?

Oracle RAC architecture

Advantage of Oracle RAC

Single instance and RAC

Installation Prequistes like Hardware, Network , Storage, OS groups and users and SSH/RCP preconfiguration

Cluster utility (cluvfy) overview and usage

RAC Installation – Clustware ,ASM and RDBMS

RAC Database Creation

Common Initilization Parameters

OCR (oracle cluster registry) & Voting Disk

Enabling and Disabling automatic cluster stack start and stop

Clustware administration

RAC workload management and services -Hig avilbilty, load balance

RAC internals

Troublshooting – Node eviction Issues

Performance Tuning

Node addition and Deletion

Single instance database conversion to RAC

New features of 11g R2.