| TNS cannot resolve name [message #67086] |
Thu, 18 September 2003 10:08  |
Eddie Tai
Messages: 2
Registered: September 2003
|
Junior Member |
|
|
Hi,
It has been very interesting solving this problem. Installing Oracle 8i Enterprise Edition on a standalone W2K desktop without connecting to network. After installation of it, I was able to connect the local Oracle instance (testdb) using sqlplus without problem.
But when reboot the w2k desktop and connect the cable to the network, I was not able to connect the local Oracle instance (testdb) using sqlplus. It said TNS name cannot be resolve.
Without making any change, I unpluge the network cable and reboot my w2k, I was again able to use sqlplus to connect the local Oracle instance (testdb).
Could anyone help on this? Any idea what is going on?
Thanks in advance
Eddie Tai
|
|
|
|
|
|
| Re: TNS cannot resolve name [message #67090 is a reply to message #67089] |
Thu, 18 September 2003 10:28  |
Eddie Tai
Messages: 2
Registered: September 2003
|
Junior Member |
|
|
The w2k desktop is using DHCP for assign IP address, the hostname of the w2k desktop is unique. I check the SID and port, no other is using the same.
Thanks
|
|
|
|
| Re: TNS cannot resolve name [message #67091 is a reply to message #67090] |
Thu, 18 September 2003 11:44 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
if you have local database (database in same machine as cleint) u NO NEED any tns entries.
if u intent to use,
set your host to LOCALHOST
in listener and tnsnames.ora files.
and note that, every cleint ( sqlplus,forms,reports) etc....installed in the same machine will have its own tnsnames.ora.
so, edit all tnsnames.ora files.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
