Cannot read or open tnsnames.ora [message #102043] |
Wed, 23 January 2002 07:42 |
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 #102450 is a reply to message #102043] |
Sun, 09 June 2002 10:16 |
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.
|
|
|