So I have RAC setup ( Solaris 2.8 , Veritas DBE/AC 3.5 MP1 and HDS disks if you are interested) and I am attempting to setup my failover and loadbalancing from a client.
I brought down VLDBN1
and Thought I should fail over to VLDB2 ... but I did not.
Here is what I have in my tnsnames.ora:
VLDB =
(DESCRIPTION =
(FAILOVER=ON)
(LOAD_BALANCE = yes)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.250.25)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.250.26)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = VLDBN2)
(FAILOVER_MODE=
(BACKUP=SECONDAY)
(TYPE=select)
(METHOD=basic)
(RETRIES=5)
(DELAY=5)
)
)
)
(DESCRIPTION =
(FAILOVER=ON)
(LOAD_BALANCE = yes)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.250.25)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.250.26)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = VLDBN2)
(FAILOVER_MODE=
(BACKUP=SECONDAY)
(TYPE=select)
(METHOD=basic)
(RETRIES=5)
(DELAY=5)
)
)
)
SECONDARY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.250.26)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = VLDBN2)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.250.26)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = VLDBN2)
)
)
Any ideas?
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software