OraFAQ Forum: Networking and Gateways » extract tnsnames.ora path using SQLPlus

Home » RDBMS Server » Networking and Gateways » extract tnsnames.ora path using SQLPlus (Oracle 10g, Solaris 10)

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

extract tnsnames.ora path using SQLPlus [message #503674]

Tue, 19 April 2011 00:20

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Good day!

We are preparing a script for purposes of cold backup.
We have already listed the Oracle binary files except for
the tnsnames.ora and the password file.

Can someone help me show tnsnames.ora path using SQLPlus?

Thanks in advance.

Report message to a moderator

Re: extract tnsnames.ora path using SQLPlus [message #503675 is a reply to message #503674]

Tue, 19 April 2011 00:38

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

You Can`t.
As it will reside on both client and Server side of the Database.
You can find the path @ %ORACLE_HOME%\network\admin\

You can have one chance.

execute the following ...
step 1) Using SQL*PLUS
select '&_connect_identifier' from dual;

SQL> select '&_connect_identifier' from dual;
old   1: select '&_connect_identifier' from dual
new   1: select 'SATYA' from dual

'SATY
-----
SATYA

Step 2
go to command prompt and type tnsping <result of the step 1>
ex: sql> ! tnsping satya

Just tried to help you.

Good luck

Sriram

Report message to a moderator

Re: extract tnsnames.ora path using SQLPlus [message #503676 is a reply to message #503675]

Tue, 19 April 2011 00:39

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

By looking into it one more time ...
Quote:

We are preparing a script for purposes of cold backup.

Do you really need this for cold backup ?

Sriram

Report message to a moderator

Re: extract tnsnames.ora path using SQLPlus [message #503679 is a reply to message #503676]

Tue, 19 April 2011 00:45

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Thanks for this info.

Actually, one of our outsourcers recommend inclusion of tnsnames and password file.

Again, thank you very much!

Report message to a moderator

Re: extract tnsnames.ora path using SQLPlus [message #503689 is a reply to message #503679]

Tue, 19 April 2011 01:01

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Though: if there is more than one Oracle software product installed on your computer, there's a good chance that you'll have multiple TNSNAMES.ORA files. Which one do you need? One of them? All of them? Some of them?

Moreover: \network\admin is the default location. TNSNAMES.ORA can be located anywhere (mine is, for example, in "c:\oralib" directory (MS Windows)). Its location can be defined by the TNS_ADMIN environment variable, so all my Oracle products use that TNSNAMES.ORA (and not the ones located in their \network\admin directories).

So, consider that fact as well.

Report message to a moderator

Re: extract tnsnames.ora path using SQLPlus [message #503701 is a reply to message #503689]

Tue, 19 April 2011 01:29

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Ofcourse But if you ping the TNS Entry it will give you the path no matter where it resides...

Sriram

Report message to a moderator

Re: extract tnsnames.ora path using SQLPlus [message #503702 is a reply to message #503701]

Tue, 19 April 2011 01:36

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Right; didn't read your message carefully enough, sorry. TNSPING will display it under "Used parameter files".

Report message to a moderator

Previous Topic:	Database gateways vs Transparent gateways
Next Topic:	Problem to connect from client to server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 05:34:49 CDT 2025