SID failover in RAC? [message #74914] |
Thu, 02 September 2004 21:59 |
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 #74919 is a reply to message #74914] |
Wed, 08 September 2004 23:14 |
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.
|
|
|