Home » Other » General » Cannot read or open tnsnames.ora
Cannot read or open tnsnames.ora [message #102043] Wed, 23 January 2002 07:42 Go to next message
Alex
Messages: 190
Registered: August 1999
Senior Member
Hi everyone,

Could someone tell why I cannot open the tnsnames.ora file on my windows 98 machine? Beacause I have no clue. The file is there and in the right folder, but when I click on it, it's not giving me option to open.

Thank you,

Alex.
Re: Cannot read or open tnsnames.ora [message #102045 is a reply to message #102043] Wed, 23 January 2002 08:59 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
Right click on the file and select "Properties" and make sure the file is not set "read-only".
Re: Cannot read or open tnsnames.ora [message #102047 is a reply to message #102043] Wed, 23 January 2002 10:43 Go to previous messageGo to next message
Alex
Messages: 190
Registered: August 1999
Senior Member
Thanks Grant, but that wasn't the issue.
From the registry I removed file ".ora"
and averything is working fine.

Alex.
Re: Cannot read or open tnsnames.ora [message #102173 is a reply to message #102043] Sat, 16 March 2002 13:19 Go to previous messageGo to next message
Raj
Messages: 411
Registered: November 1998
Senior Member
Hi everyone,
Could someone tell me what TNSNAMES is...and what it does...? when we use..???
thanks
raj
Re: Cannot read or open tnsnames.ora [message #102450 is a reply to message #102043] Sun, 09 June 2002 10:16 Go to previous message
Praveen Jindal
Messages: 1
Registered: June 2002
Junior Member
TNSNAMES.ORA is a file where the tnsnames entries are entered. Basically in the Client/Server Architecture
When the Client and Server are on 2 different machines..in that case entries in tnsnames.ora are used to connect to the server...

e.g SQLPLUS scott/tiger@xxx where xxx should be
an entry in the tnsnames.ora directing to the server
where the connection is needed to be made..

In case where Client and Server are on same Machine,
SQLPLUS scott/tiger will by default connect to the
Local Server..In that case tnsnames.ora and listener.ora doesn't come into picture but in the first case, these 2 files come into picture.
Previous Topic: Re: oracle dba tasks
Next Topic: Problems in manual creation of DB in 9i
Goto Forum:
  


Current Time: Fri Mar 29 03:07:20 CDT 2024