RE: dataguard connection question
Date: Tue, 9 Jun 2009 10:40:35 -0400
Your biggest difficulty here is JDBC because it does not use the Oracle SQL*Net layer thereby making this a touch difficult. The following is something I pulled (in spirit only) from another project I worked on that had a requirement for a standby database & no manual intervention on the app side:
It helped in that setup and did work flawlessly, but yours may be different. Alternatively you might consider setting up a connection manager somewhere in your infrastructure. It can handle just this type of problem, but it's another layer of indirection.
Senior Oracle DBA
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joan Hsieh Sent: Monday, June 08, 2009 7:35 PM
Subject: dataguard connection question
I have question regarding dataguard, the primary database is xytht1, the
standby is xytht2. the oracle is 126.96.36.199. Our client is using jdbc thin
client to connect the primary database. the connection string is
jdbc:oracle:thin:_at_(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 to manually reconfigure to change the HOST and service name. This is not acceptable to our client. I have no knowledge on how to automatically switchover/failover for the client jdbc connection. Do you have any ideas on this? Thank you for any helps.
http://www.freelists.org/webpage/oracle-l Received on Tue Jun 09 2009 - 09:40:35 CDT