OraFAQ Forum: RAC & Failsafe

Home » Server Options » RAC & Failsafe » RAC TNSNAMES

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

RAC TNSNAMES [message #261423]

Wed, 22 August 2007 09:46

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

Report message to a moderator

Re: RAC TNSNAMES [message #261454 is a reply to message #261423]

Wed, 22 August 2007 11:42

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)
    )
  )

Report message to a moderator

Previous Topic:	RAC Installation on Solaris 5.9 with Veritas Foundation 4.1MP2
Next Topic:	migrate 9i RAC to 10g (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 17:00:57 CST 2024