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

Report message to a moderator

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: 20095
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

Report message to a moderator

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: 54164
Registered: March 2007
Location: Nanterre, France, http://...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 21 10:48:55 CDT 2013

Total time taken to generate the page: 0.37813 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.