OraFAQ Forum: RAC & Failsafe » RAC & FAILOVER = HELP

Home » Server Options » RAC & Failsafe » RAC & FAILOVER = HELP

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

RAC & FAILOVER = HELP [message #143969]

Mon, 24 October 2005 07:52

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.

Report message to a moderator

Re: RAC & FAILOVER = HELP [message #143989 is a reply to message #143969]

Mon, 24 October 2005 09:53

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: RAC & FAILOVER = HELP [message #145155 is a reply to message #143969]

Tue, 01 November 2005 06:43

eldar52
Messages: 14
Registered: October 2005

Junior Member

Are you using JDBC oci driver ?

Report message to a moderator

Re: RAC & FAILOVER = HELP [message #145156 is a reply to message #143969]

Tue, 01 November 2005 06:47

asangapradeep
Messages: 128
Registered: October 2005
Location: UK

Senior Member

hi,

yes i'm using oci

Report message to a moderator

Re: RAC & FAILOVER = HELP [message #145316 is a reply to message #145156]

Wed, 02 November 2005 07:46

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 16:58:18 CDT 2025