From oracle-l-bounce@freelists.org Fri Sep 16 10:16:11 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8GFGAep017189 for ; Fri, 16 Sep 2005 10:16:10 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8GFG76H017175 for ; Fri, 16 Sep 2005 10:16:07 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 361871ED27A; Fri, 16 Sep 2005 10:16:00 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03942-09; Fri, 16 Sep 2005 10:16:00 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A660C1ED324; Fri, 16 Sep 2005 10:15:59 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5BAD1.3F82A19B" Subject: ODP.NET and 9.2.0.4 TAF Date: Sat, 17 Sep 2005 01:13:52 +1000 Message-ID: <18D551B1B928FF47A65B2D91F705906A01EE0DAC@HSNDON-EX01.hsntech.int> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: ODP.NET and 9.2.0.4 TAF Thread-Index: AcW60T93YwXvjWCmSOukSBLxDmC7/g== From: "Leng Kaing" To: X-OriginalArrivalTime: 16 Sep 2005 15:13:28.0564 (UTC) FILETIME=[31292B40:01C5BAD1] X-archive-position: 25583 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Leng.Kaing@hsntech.com Precedence: normal Reply-To: Leng.Kaing@hsntech.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.3 required=5.0 tests=AWL,BAYES_00,HTML_70_80, HTML_FONTCOLOR_UNKNOWN,HTML_FONT_BIG,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5BAD1.3F82A19B Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi everyone, =20 Need some help with ODP.NET and TAF please. It's 1am and I'm writing this email so you can see that I'm in dire straits! =20 We've managed to successfully failover via SQL*Plus, but having problems getting ODP.NET to failover succesfully. Error encountered is ORA-1012 when it tries to fail over to the second instance. =20 >From all the doco's we've read, it appears that ODP.NET should work with TAF and failover transparently. Is there anything special that we need to check for? Being a DBA we're not sure of what to check for at the ODP.NET end. Is there a setting that we need to use? Are there known bugs and work-arounds with 9.2.0.4 TAF? We're using ODP.NET v9.2.0.4.01 =20 Many thanks in advance, =20 Leng. =20 ---------------------------------------------- Leng Kaing Hansen Technologies 2 Frederick St; Doncaster VIC 3108 =20 Tel: +61-3-9840-3832 Fax: +61-3-9840-3102 =20 =20 =20 ------_=_NextPart_001_01C5BAD1.3F82A19B Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi =
everyone,

 Need some help with ODP.NET and =
TAF please. It's 1am and I'm writing
this email so you can see that =
I’m in dire straits!
 =
We've managed to successfully =
failover via SQL*Plus, but having
problems getting ODP.NET to =
failover succesfully. Error encountered =
is
ORA-1012 when it tries to fail =
over to the second instance.
 From all the doco's we've read, =
it appears that ODP.NET should work
with TAF and failover =
transparently. Is there anything special that =
we
need to check for? Being a DBA =
we're not sure of what to check for =
at
the ODP.NET end. Is there a =
setting that we need to use? Are =
there
known bugs and work-arounds with =
9.2.0.4 TAF? We're using ODP.NET
v9.2.0.4.01
 Many thanks in =
advance,
 Leng.

 

----------------------------------------------<=
/font>


Leng =
Kaing

Hansen Technologies

2 =
Frederick St; Doncaster VIC 3108

 

Tel: +61-3-9840-3832

Fax: +61-3-9840-3102

------_=_NextPart_001_01C5BAD1.3F82A19B-- -- http://www.freelists.org/webpage/oracle-l