Re: dataguard connection question
- From: Mathias Magnusson <mathias.magnusson@xxxxxxxxx>
- To: adar666@xxxxxxxxxxxx
- Date: Tue, 9 Jun 2009 13:24:39 +0200
Adar,
I think jdbc handles it OK, is it not that it is the thin driver that
doesn't? When I implemented this on a previous engagement, we still used
jdbc, but we switched over to using the oci driver. It takes some setting
up, but once configured it worked very well for us.
Mathias
On Tue, Jun 9, 2009 at 12:52 PM, Yechiel Adar <adar666@xxxxxxxxxxxx> wrote:
> 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:
