Home » Server Options » RAC & Failsafe » SID failover in RAC?
SID failover in RAC? [message #74914] Thu, 02 September 2004 21:59 Go to next message
Scott.C
Messages: 1
Registered: September 2004
Junior Member
Hi,

In a situation where I have a client trying to access SID=ACCT1 which is part of a RAC configuration, and the server services ACCT1 fails does an other member of the RAC accept connection requests for ACCT1?

 

Thanx Scott
Re: SID failover in RAC? [message #74916 is a reply to message #74914] Tue, 07 September 2004 17:52 Go to previous messageGo to next message
dzg
Messages: 1
Registered: September 2004
Junior Member
no, if you want to failover you should use the service=xxx.
Re: SID failover in RAC? [message #74919 is a reply to message #74914] Wed, 08 September 2004 23:14 Go to previous message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

Well along with the service you have to configure a TAF enabled connection string at client side only then your connections can be taken by other nodes of RAC in case of failure. A typical example (from oracle corp.) of TAF enabled connection string is as follow:

db.us.acme.com=
(description=
(load_balance=on)
(failover=on)
(address=
(protocol=tcp)
(host=db1)
(port=1521))
(address=
(protocol=tcp)
(host=db2)
(port=1521))
(connect_data=
(service_name=db.us.acme.com)
(failover_mode=
(type=select)
(method=basic))))

Daljit Singh.
Previous Topic: New to RAC.help
Next Topic: Help: Cluster.
Goto Forum:
  


Current Time: Fri Mar 29 04:59:15 CDT 2024