Link to home
Start Free TrialLog in
Avatar of anup001
anup001

asked on

question regarding tnsnames.ora on linux

Hi,

Can I have 2 entries int he tnsnames.ora for the same service name? (In other words in the following tnsnames.ora after the horizontal line like the last entry,  can I have an additional entry as follows (what i want to add is before the horizontal line) So basically i want to have a single host name for multiple service names and the host name is engt02. How do I achieve that?

ENTG02 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = entg02)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = new_servicename)
    )
  )
_________________________________________________________________________

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

ENTG02 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = entg02)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
ASKER CERTIFIED SOLUTION
Avatar of fluglash
fluglash

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of anup001
anup001

ASKER

Is that entry(ENTG02) not required to e same as host name that is lower case enth02?
the tnsalias can not be duplicated
this entry required, but NetServiceName must be unique

new_ENTG02 = <---- change this for something else...
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = entg02)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = new_servicename)
    )
  )
Avatar of anup001

ASKER

do i need to restart anyything after modifyin tnsnames.ora in linux?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
no, you don`t need to reboot machine