I am using oracle 10g and I want to use a standby database for high availability of my database. I did almost everything; but I don't know how a user can connect to the standby server when the primary has failed. This is my connection string
"Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = my_host_name)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = my_service_name)))";
My problem is 'how can I make the host name and service_name dynamic?
I am waiting for your help!
August 9, 2010 2:00 PM
August 9, 2010 2:31 PM