Home » Server Options » RAC & Failsafe » RAC & FAILOVER = HELP
RAC & FAILOVER = HELP [message #143969] Mon, 24 October 2005 07:52 Go to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
Hi all,

need some clarification.
i got a RAC with two nodes. and their tnsnames.ora is something similar to

CLUS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = racvip1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = racvip2)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVICE_NAME = clus.tbx.net)
)
)


and the client application (a java program)connect to the instances from a different machine which has oracle client installed.


i want to have both load balacing and TAF. my question is where do i go and put TAF feature stuff. do i add them to the existing RAC tnsnaems.ora files or only to the client tnsnames.ora

from my searches i've found its on client's tnsnames.ora file but just want to be sure.

second is what's the "syntax" or "format" of it.
i've seen examples where it's given

(ADDRESS = (PROTOCOL = TCP)(HOST = racvip1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = racvip2)(PORT = 1521))
(LOAD_BALANCE = yes)


and in some cases
(LOAD_BALANCE = yes)
(ADDRESS = (PROTOCOL = TCP)(HOST = racvip1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = racvip2)(PORT = 1521))

what's the correct syntax or it doesn't matter where you put it?

right now to get TAF i use something like this

(DESCRIPTION =
(FAILOVER=ON)(enable=broken)
(LOAD_BALANCE = yes)
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP)(HOST = racvip1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = racvip2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = clus.tbx.net)(SERVER=DEDICATED)
(failover_mode=(type=select)(method=basic))
)
)


please point out any errors or adjustment to be made

thank you.
Re: RAC & FAILOVER = HELP [message #143989 is a reply to message #143969] Mon, 24 October 2005 09:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> do i add them to the existing RAC tnsnaems.ora files or only to the client tnsnames.ora

Tnsnames.ora is to do with the client connections.
if you run some programs ( like batch script) in server directly (thus using it as client), then use them in serverside tnsnames.ora.
Else
in all your client machines

http://www.oracle.com/technology/oramag/oracle/02-may/o32clusters.html
http://download-east.oracle.com/docs/cd/B19306_01/network.102/b14212/advcfg.htm#NETAG0131
Re: RAC & FAILOVER = HELP [message #145155 is a reply to message #143969] Tue, 01 November 2005 06:43 Go to previous messageGo to next message
eldar52
Messages: 14
Registered: October 2005
Junior Member
Are you using JDBC oci driver ?
Re: RAC & FAILOVER = HELP [message #145156 is a reply to message #143969] Tue, 01 November 2005 06:47 Go to previous messageGo to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
hi,

yes i'm using oci
Re: RAC & FAILOVER = HELP [message #145316 is a reply to message #145156] Wed, 02 November 2005 07:46 Go to previous message
eldar52
Messages: 14
Registered: October 2005
Junior Member
OCI configuration is quite simple - just configure tns entry on the client side where java is running .
Tns should include of course load_balance=on and failover=on.
OCI driver supports TAF but if you are in the middle of transaction then you should perform a rollback in case of failure.

ELdar
Previous Topic: thanks for the information
Next Topic: Location of sqlnet.ora with 2 servers and oracle failsafe
Goto Forum:
  


Current Time: Sun Dec 05 17:37:02 CST 2021