Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Configuring TAF via jdbc

ChristianSep 5 2012 — edited Oct 11 2012

Hey, I am running a two node rac on 11.2.0.3 with gi 11.2.0.3

My application is using the jdbc:oracle:oci driver.

My connection string looks like

@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.4)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.5)(PORT=1521))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))))

The remote_listener parameter is set to the vip addresses.
TAF is working as well, but it takes quite long to get reconnect.

Do you have any experiences regarding the retries and delay settings ?
would that be too short ? (RETRIES=3)(DELAY=3)

Is there any other point to configure taf while using the jdbc oci driver ? Anything within the database or in oracle net ? Listener ? Tnsnames ?

Chris

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2012

Added on Sep 5 2012

#performance-availability, #real-application-clusters

6 comments

1,139 views