Home » Server Options » RAC & Failsafe » RAC TNSNAMES
RAC TNSNAMES [message #261423] Wed, 22 August 2007 09:46 Go to next message
ipaul512k
Messages: 1
Registered: August 2007
Junior Member
Hi Everyone;
I have the following TNSNAMES file on the clients of an application accessing a 2 node RAC config, Oracle 10g.

ax =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ax01-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ax02-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER=ON)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ax)
(FAILOVER_MODE=(BACKUP=ax02)(TYPE=SELECT)(METHOD=BASIC)))
)
)

Does this look correct? Also, do I have to add the failover parameter to the TNSNAMES files on the nodes? I was never aware of the TNDNAMES on the nodes, I thought TNSNAMES was only used on the client side. Thanks for the help
Re: RAC TNSNAMES [message #261454 is a reply to message #261423] Wed, 22 August 2007 11:42 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
2 NODE tnsnames.ora
===================


# tnsnames.ora Network Configuration File: /oracle/product/10.2.0.1/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

UCHOOSE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = udb01vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = udb02vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = UCHOOSE)
    )
  )

LISTENERS_UCHOOSE =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = udb01vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = udb02vip)(PORT = 1521))
  )

UCHOOSE2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = udb02vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = UCHOOSE)
      (INSTANCE_NAME = UCHOOSE2)
    )
  )

UCHOOSE1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = udb01vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = UCHOOSE)
      (INSTANCE_NAME = UCHOOSE1)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
Previous Topic: RAC Installation on Solaris 5.9 with Veritas Foundation 4.1MP2
Next Topic: migrate 9i RAC to 10g (merged)
Goto Forum:
  


Current Time: Thu Mar 28 20:07:03 CDT 2024