OraFAQ Forum: Networking and Gateways » TNSNAMES.ora Questions

Home » RDBMS Server » Networking and Gateways » TNSNAMES.ora Questions (Oracle 9 - 11 ?)

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

TNSNAMES.ora Questions [message #453392]

Wed, 28 April 2010 09:19

NewbiewScott
Messages: 1
Registered: April 2010

Junior Member

Hello All,

Would someone please explain to me what the purpose
of tnsnames file does?
Does it need to be on the client workstation and what should be it's correct location?

I am new to Oracle, hence the beginner question!

Thanks

NewbieWScott

Report message to a moderator

Re: TNSNAMES.ora Questions [message #453400 is a reply to message #453392]

Wed, 28 April 2010 09:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ALWAYS
Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

>Would someone please explain to me what the purpose of tnsnames file does?
TNSNAMES.ORA is the functional equivalent to OS "hosts" file.
Remote DBs are referenced by TNS_ALIAS (leftmost field).
This file contains all necessary details to access remote DB

>Does it need to be on the client workstation and what should be it's correct location?

ORACLE_HOME/network/admin

Report message to a moderator

Re: TNSNAMES.ora Questions [message #453408 is a reply to message #453392]

Wed, 28 April 2010 10:14

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Database Net Services Reference
Chapter 6 Local Naming Parameters (tnsnames.ora)

Regards
Michel

Report message to a moderator

Previous Topic:	ORA ERROR 12560
Next Topic:	netca problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 07 02:22:15 CDT 2026