Re: dataguard connection question

From: Mathias Magnusson <mathias.magnusson_at_gmail.com>
Date: Tue, 9 Jun 2009 07:23:11 +0200
Message-ID: <8580d4110906082223k10587319ieb35c697f789c887_at_mail.gmail.com>

Read up on TAF. Transparent Application Failover.

You want to configure an alias the programs connect to so you can change the definition yourself and in one place and not in a set of property files. It works well once you get it set up. I suggest testing by hand with SQ*PLUS when you set it up so you can see that your session is kept when it fails over.

The basic thing is that the connection specification has to define both databases and specify some details on the failover of the session. It makes the specification fairly long and that is why you want to keep it in tnsnames and not spread it out in Java code or property files.

Mathias

On Tue, Jun 9, 2009 at 1:34 AM, Joan Hsieh <joan.hsieh_at_tufts.edu> 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:_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.
>
> Joan
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Tue Jun 09 2009 - 00:23:11 CDT