OraFAQ Forum: Server Administration » identify Tnsnames.ora file

Home » RDBMS Server » Server Administration » identify Tnsnames.ora file (Oracle 10.2.0.2.0, Unix)

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

identify Tnsnames.ora file [message #511268]

Fri, 10 June 2011 11:44

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi,

How to find out the database TNSNAMES.ora file if there are multiple
.ora files with different names in Oracle_home/network/admin directory ?

Thanks

Report message to a moderator

Re: identify Tnsnames.ora file [message #511269 is a reply to message #511268]

Fri, 10 June 2011 11:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How to find out the database TNSNAMES.ora file if there are multiple
>.ora files with different names in Oracle_home/network/admin directory ?

and the answer is

it is the file with the filename of "tnsnames.ora"!

Report message to a moderator

Re: identify Tnsnames.ora file [message #511270 is a reply to message #511269]

Fri, 10 June 2011 12:01

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

I mean the file name was like this.
tnsnames.ora2001
tnsnames.ora_Ak_1
tnsnames.ora_Ak_2

So what got confused.

Thanks

Report message to a moderator

Re: identify Tnsnames.ora file [message #511271 is a reply to message #511270]

Fri, 10 June 2011 12:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>So what got confused.
Ask your question to the person who made these files; not us.
Oracle RDBMS only use "tnsnames.ora" file; period & end of statement.
anyone can make file with any name & Oracle will ignore any & all other file other than "tnsnames.ora".

Report message to a moderator