RAC tnsnames.ora entries for TAF and CTF

Admin — Thu, 24 Jun 2010 15:51:04 GMT

TAF:

MYTNSADD.world =
(DESCRIPTION_LIST =
(FAILOVER = true)
(LOAD_BALANCE = true)
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = HOST1)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = MYSERVICE.COM)
(SERVER = dedicated)
(FAILOVER_MODE =
(BACKUP=HOST2)
(TYPE=select)
(METHOD=preconnect)
(RETRIES=10)
(DELAY=3)
)
)
)

BACKUP=HOST2. This names the backup node that will take over failed connections when a node1 crashes.
Primary server is host1, and TAF will reconnect failed transactions to the host2 instance in case of server failure.

TYPE=select. This tells TAF to restart all in-flight transactions from the beginning of the transaction.

METHOD=preconnect. This directs TAF to create two connections at transaction startup time: one to the primary host1
database and a backup connection to the host2 database. In case of instance failure, the host2 database will be ready
to resume the failed transaction.

RETRIES=5. This directs TAF to retry a failover connection up to 5 times.

DELAY=3. This tells TAF to wait three seconds between connection retries.

---------------------------------------------

CTF

myserviceName.com=
(description=
(load_balance=on)
(failover=on)
(address=
(protocol=tcp)
(host=node1)
(port=1521))
(address=
(protocol=tcp)
(host=node2)
(port=1521))
(connect_data=
(service_name=myserviceName.com))))

FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / Oracle RAC - Real Application Clusters Forum / RAC tnsnames.ora entries for TAF and CTF / Latest Posts

RAC tnsnames.ora entries for TAF and CTF