Re: RAC behavior - with Oracle JDBC Thin Driver - is this expected behavior?
Date: Wed, 11 Feb 2009 08:39:00 +0300
Message-ID: <97b7fd2f0902102139x796f1a53x391bc76fb01b7e76_at_mail.gmail.com>
TAF callbacks (FAILOVER_MODE) doesn't supported by JDBC connections. In order to implement failover with JDBC thin connections, you need to implement FCF (fast connection failover). Following are the few references that might help you to configure FCF for your JDBC connection failover:
Note 433827.1<https://metalink2.oracle.com/metalink/plsql/showdoc?db=NOT&id=433827.1&blackframe=1>
How
To Verify And Test Fast Connection Failover Setup From a JDBC Thin Client
http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/fstconfo.htm#CIHJBFFC
Regards,
Jaffar
On Wed, Feb 11, 2009 at 3:42 AM, Pradeep Chetal < Pradeep.Chetal_at_mformation.com> wrote:
>
>
> Hi,
>
>
>
> We have a Java based app that runs with Weblogic and oracle 10gr2 as the
> DB.
>
>
>
> We use the following for the RAC string for JDBC connection
>
>
>
> *RAC_STRING = *
>
> * jdbc:oracle:thin:_at_(DESCRIPTION=** *
>
> * **(FAILOVER=ON)*
>
> * (LOAD_BALANCE=ON)*
>
> * (ADDRESS=(PROTOCOL=TCP)(HOST=dingo)(PORT=1521))*
>
> * (ADDRESS=(PROTOCOL=TCP)(HOST=wolf)(PORT=1521))*
>
> * (CONNECT_DATA=(SERVICE_NAME=msmdb)))*
>
> * *
>
> * *
>
> We use this with a 2-node RAC and all the API calls to our application are
> sort of evenly distributed between the 2 nodes.
>
>
>
> Now if for some reason, node 1goes down, we see that NOT all the new API
> calls go to node-2 RAC. Some of them are lost until we re-start the
> application.
>
>
>
> I thought the RAC_STRING will be dynamic and will NOT send calls to node 1
> if it is down.
>
>
>
> Are we missing any configuration parameters here?
>
>
>
> Thanks,
>
>
>
> -- Pradeep
>
>
>
> *Pradeep Chetal*
> Sr. Director - Infrastructure Architecture
> ------------------------------
> *Mformation Technologies Inc.*
> *Switchboard:* +1 732 692 6200
>
> ------------------------------
>
> Visit MFORMATION <http://www.mformation.com>at MWC in Barcelona, Hall 1
> Booth A56, Mobile World Congress 2009
> <http://www.mobileworldcongress.com/homepage.htm>and see how the
> MFORMATION SERVICE MANAGER can help you to transform your business.
>
> Please consider the environment before printing
>
>
-- Best Regards, Syed Jaffar Hussain Oracle Certified Master (10g) http://www.oracle.com/technology/ocm/shussain.html Oracle ACE http://apex.oracle.com/pls/otn/f?p=19297:4:1579866181463918::NO:4:P4_ID:126 OCP 8i,9i & 10g DBA RAC Certified Expert Official Oracle RAC SIG Representative for Saudi Arabian region ( http://www.oracleracsig.org/) I blog at http://jaffardba.blogspot.com/ -------------------- "Winners don't do different things. They do things differently." -- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 10 2009 - 23:39:00 CST