Home » Server Options » RAC & Failsafe » FAIL OVER in ORACLE 10g (Oracle 10g, RedHat Linux)
FAIL OVER in ORACLE 10g [message #573022] Thu, 20 December 2012 00:45 Go to next message
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
Re: FAIL OVER in ORACLE 10g [message #573031 is a reply to message #573022] Thu, 20 December 2012 01:37 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: FAIL OVER in ORACLE 10g [message #573042 is a reply to message #573031] Thu, 20 December 2012 03:15 Go to previous messageGo to next message
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
Re: FAIL OVER in ORACLE 10g [message #573043 is a reply to message #573042] Thu, 20 December 2012 03:23 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
Can you tell me how to achieve this in my jdbc url ?
Impossible.
Quote:
You'll need to configure FAN for that.
Re: FAIL OVER in ORACLE 10g [message #573044 is a reply to message #573043] Thu, 20 December 2012 03:24 Go to previous messageGo to next message
nittejoy
Messages: 4
Registered: December 2012
Location: India
Junior Member
oracle 10g supports FAN ?
Re: FAIL OVER in ORACLE 10g [message #573049 is a reply to message #573044] Thu, 20 December 2012 04:08 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Previous Topic: Fast Application Notification with OCI based app?
Next Topic: Cluster name not showing
Goto Forum:
  


Current Time: Fri Mar 29 06:37:18 CDT 2024