OraFAQ Forum: RAC & Failsafe » FAIL OVER in ORACLE 10g

Home » Server Options » RAC & Failsafe » FAIL OVER in ORACLE 10g (Oracle 10g, RedHat Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FAIL OVER in ORACLE 10g [message #573022]

Thu, 20 December 2012 00:45

nittejoy
Messages: 4
Registered: December 2012
Location: India

Junior Member

Hi,

My application uses below jdbc url for database connectivity. Today one of the db node was down for one hour and FAIL OVER did not happen. Please can anyone tell what is the reason behind this ?

<connection-url>
jdbcracle:thin:@(DESCRIPTION=(LOAD_BALANCE=ON)(FAILOVER=ON )(ADDRESS=(PROTOCOL=TCP)(HOST=viphost1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=viphost2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=serv ice_name)))
</connection-url>

Regards,
Jaya

Report message to a moderator

Re: FAIL OVER in ORACLE 10g [message #573031 is a reply to message #573022]

Thu, 20 December 2012 01:37

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

Your connect URL should give connect-time fault tolerance, ie, you should establish a session against one instance or the other, but it will do nothing for failing over established sessions. You'll need to configure FAN for that.

And by the way, please be careful of typing errors, there are (at least) two in your post. Use copy-paste, with [code] tags instead.

Report message to a moderator

Re: FAIL OVER in ORACLE 10g [message #573042 is a reply to message #573031]

Thu, 20 December 2012 03:15

nittejoy
Messages: 4
Registered: December 2012
Location: India

Junior Member

Hi,

Thank you John. Application was able switch to another node when one of the database node was down earlier, only change in previous jdbc url LOAD_BALANCE was set to OFF. (Changed to ON as suggested by DBA later)

You said Quote:

URL should give connect-time fault tolerance, ie, you should establish a session against one instance or the other, but it will do nothing for failing over established sessions. You'll need to configure FAN for that.

Can you tell me how to achieve this in my jdbc url ?

Regards,
Jay

Report message to a moderator