dataguard connection question

From: Joan Hsieh <joan.hsieh@xxxxxxxxx>
To: oracle_l <ORACLE-L@xxxxxxxxxxxxx>
Date: Mon, 08 Jun 2009 19:34:53 -0400

Hi List,

I have question regarding dataguard, the primary database is xytht1, thestandby is xytht2. the oracle is 11.1.0.7. Our client is using jdbc thinclient to connect the primary database. the connection string is

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test-xythdb-01.uit.tufts.edu)(PORT=11003))(CONNECT_DATA=(SERVICE_NAME=XYTHT1)))JDBCConnectionPool:395

After I tested switchover, the client lost connection, and have tomanually reconfigure to change the HOST and service name. This is notacceptable to our client. I have no knowledge on how to automaticallyswitchover/failover for the client jdbc connection. Do you have anyideas on this? Thank you for any helps.


Joan

--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: dataguard connection question
From: Mathias Magnusson

RE: dataguard connection question
From: Mathias Zarick

Re: dataguard connection question
From: Yechiel Adar

RE: dataguard connection question
From: Goulet, Richard

dataguard connection question

Other related posts: