add service
hi all,
I have a DB with 3 nodes RAC, tns that we use is ;
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = A)(PORT = 15219))
(ADDRESS = (PROTOCOL = TCP)(HOST = (PORT = 15219))
(ADDRESS = (PROTOCOL = TCP)(HOST = C)(PORT = 15219))
(LOAD_BALANCE = NO) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB_NAME)) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 30) (DELAY = 5)))
We need to make that : service is registered on node A, automatic failover on B, manually start on C in case of down of A and B , how can we make this ?
thanks,
I have a DB with 3 nodes RAC, tns that we use is ;
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = A)(PORT = 15219))
(ADDRESS = (PROTOCOL = TCP)(HOST = (PORT = 15219))
(ADDRESS = (PROTOCOL = TCP)(HOST = C)(PORT = 15219))
(LOAD_BALANCE = NO) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB_NAME)) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 30) (DELAY = 5)))
We need to make that : service is registered on node A, automatic failover on B, manually start on C in case of down of A and B , how can we make this ?
thanks,
0