Standby Database Server
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!
Thanks!!!
Software/Hardware used:
Software
"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!
Thanks!!!
Software/Hardware used:
Software
ASKED:
August 9, 2010 2:00 PM
UPDATED:
August 9, 2010 2:31 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
