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 |
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
3.Start the Site Controller Package cmmodpkg
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
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