Re: dataguard connection question
- From: Yechiel Adar <adar666@xxxxxxxxxxxx>
- To: joan.hsieh@xxxxxxxxx
- Date: Tue, 09 Jun 2009 13:52:42 +0300
IIRC:
Thin JDBC does not support TAF.
You have to open a new connection in the program.
You can ask the network people to define a floating IP address that will
be directed to the second computer in case of fail over.
This will need manual intervention, but at least it will require changes
in the application.
Adar Yechiel
Rechovot, Israel
Joan Hsieh wrote:
Hi List,
I have question regarding dataguard, the primary database is xytht1,
the standby is xytht2. the oracle is 11.1.0.7. Our client is using
jdbc thin client 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 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.
Joan
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
