| 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.
|
|
|
|
|
|
|
|
|
|
| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
