1.Run the cmviewcl command to view the disaster tolerant RAC database configuration in a Metrocluster.

Following is a sample output: cmviewcl

CLUSTER

STATUS

 

 

 

dbcluster

up

 

 

 

SITE_NAME

san_francisco

 

 

 

NODE

STATUS

STATE

 

 

SFO_1

up

running

 

 

SFO_2

up

running

 

 

SITE_NAME

san_jose

 

 

 

NODE

STATUS

STATE

 

 

SJC_1

up

running

 

 

SJC_2

up

running

 

 

MULTI_NODE_PACKAGES

 

 

 

PACKAGE

STATUS

STATE

AUTO_RUN

SYSTEM

SG-CFS-pkg

up

running

enabled

yes

sfo_crs_dg

up

running

enabled

no

sfo_crs_mp

up

running

enabled

no

sfo_crs

up

running

enabled

no

sjc_crs_dg

up

running

enabled

no

sjc_crs_mp

up

running

enabled

no

sjc_crs

up

running

enabled

no

sfo_hrdb_dg

down

halted

enabled

no

sfo_hrdb_mp

down

halted

enabled

no

sjc_hrdb_dg

down

halted

enabled

no

sjc_hrdb_mp

down

halted

enabled

no

sfo_flash_dg

down

halted

enabled

no

sfo_flash_mp

down

halted

enabled

no

sjc_flash_dg

down

halted

enabled

no

sjc_flash_mp

down

halted

enabled

no

sfo_hrdb

down

halted

disabled

no

sjc_hrdb

down

halted

disabled

no

UNOWNED_PACKAGES

 

 

 

PACKAGE

STATUS

STATE

AUTO_RUN

NODE

hrdb_sc

down

halted

disabled

unowned

2.Enable all nodes in the Metrocluster for the Site Controller Package. cmmodpkg –e–n SFO_1 –n SFO_2 -n SJC_1 –n SJC_2 hrdb_sc

3.Start the Site Controller Package cmmodpkg -e hrdb_sc

The Site Controller Package along with RAC stack will start up on local site (San Francisco).

4.Check the Site Controller Package log file to ensure clean startup.

Configuring Client Access for Oracle Database 10gR2 RAC

In Oracle Database 10gR2 RAC, the Oracle Clusterware configuration provides Virtual IP addresses (VIPs) through which database clients external to the cluster connect to the database. Oracle listeners gather information about service availability on the RAC servers and assist in making client connections to the RAC instances. Additionally, they provide failure notifications and load advisories to clients, thereby enabling fast failover of client connections and client-side load-balancing. These capabilities are facilitated by an Oracle 10g feature called Fast Application Notification (FAN). For more information on Fast Application Notification, see the following documents:

http://www.oracle.com/technology/products/database/clustering/pdf/twpracwkldmgmt.pdf

http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gR2_ClientFailoverBestPractices.pdf

Configuring Oracle RAC Database in a Site Aware Disaster Tolerant Architecture 381