Solved

question regarding tnsnames.ora on linux

Posted on 2008-09-30
9
720 Views
Last Modified: 2012-05-05
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)
    )
  )
0
Comment
Question by:anup001
9 Comments
 
LVL 7

Accepted Solution

by:
fluglash earned 250 total points
ID: 22611806
ENTG02 = <---- change this for something else...
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = entg02)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = new_servicename)
    )
  )
0
 

Author Comment

by:anup001
ID: 22611870
Is that entry(ENTG02) not required to e same as host name that is lower case enth02?
0
 
LVL 15

Expert Comment

by:Shaju Kumbalath
ID: 22612050
the tnsalias can not be duplicated
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 7

Expert Comment

by:fluglash
ID: 22612077
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)
    )
  )
0
 

Author Comment

by:anup001
ID: 22612262
do i need to restart anyything after modifyin tnsnames.ora in linux?
0
 
LVL 4

Assisted Solution

by:KICUSek
KICUSek earned 250 total points
ID: 22612816
If You are starting new connectin, no restart needed.
0
 
LVL 7

Expert Comment

by:fluglash
ID: 22612909
no, you don`t need to reboot machine
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now