Home » RDBMS Server » Networking and Gateways » TNSNAMES.ora Questions (Oracle 9 - 11 ?)
icon5.gif  TNSNAMES.ora Questions [message #453392] Wed, 28 April 2010 09:19 Go to next message
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
Re: TNSNAMES.ora Questions [message #453400 is a reply to message #453392] Wed, 28 April 2010 09:39 Go to previous messageGo to next message
BlackSwan
Messages: 22789
Registered: January 2009
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
Re: TNSNAMES.ora Questions [message #453408 is a reply to message #453392] Wed, 28 April 2010 10:14 Go to previous message
Michel Cadot
Messages: 59136
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Net Services Reference
Chapter 6 Local Naming Parameters (tnsnames.ora)

Regards
Michel
Previous Topic: ORA ERROR 12560
Next Topic: netca problem
Goto Forum:
  


Current Time: Thu Sep 18 17:05:07 CDT 2014

Total time taken to generate the page: 0.09658 seconds