active passive RAC configuration
556923Jul 24 2007 — edited Jul 24 2007hi,
how can I change the active-active RAC database to active-passive RAC database?
1) Is it enough to change active_instance_count=1?
2) Is there any change required in client side tnsnames.ora file?
I want to install two databases, db1 is active in node1 and passive in node2.
And db2 is active in node2 and passive in node1.
3) For configuration of this, which method is best?
current client side tnsnames.ora file as follows:
DBRAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gcappdev-vip)(PORT = 1523))
(ADDRESS = (PROTOCOL = TCP)(HOST = gcwebdev-vip)(PORT = 1523))
(LOAD_BALANCE = yes)
(FAILOVER=ON)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DBRAC)
(FAILOVER_MODE = (TYPE=SELECT)(METHOD=BASIC))
)
)