| ORA - 12203 TNS Unable to Connect Destination [message #73885] |
Wed, 28 July 2004 19:52  |
vivek desai
Messages: 3
Registered: June 2004
|
Junior Member |
|
|
Dear All
i have installed windows 2000 advance server and oracle 8i (8.1.7 ) on my server(ML 150).
from the server i am able to connect to database but from the client i am not able to connect to server.it gives above error. if anyone know the solution about this
then relpy to above email address. here is is Listner.ora and tnsname.ora file.
# LISTENER.ORA Network Configuration File: C:oracle8iora81networkadminlistener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.135)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:oracleora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = hrmsank)
(ORACLE_HOME = D:oracleora81)
(SID_NAME = hrmsank)
)
)
TNSNames.Ora file
# TNSNAMES.ORA Network Configuration File: C:oracle8iora81networkadmintnsnames.ora
# Generated by Oracle configuration tools.
ANKCADILA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.135)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = hrmsank)
)
)
listener is up and running on server.
pls help me in this as soon as possible
waiting for favourable reply
|
|
|
|
| Re: ORA - 12203 TNS Unable to Connect Destination [message #73895 is a reply to message #73885] |
Sun, 01 August 2004 10:03  |
ilver
Messages: 50
Registered: January 2004
|
Member |
|
|
You have to understand the layers involved when establishing a connection.
Start testing your TCP/IP using the ping command.
When it's all right go on and test the TNS layer using the tnsping command.
If you still have troubles look carefully on the error message returned. The error message will tell you if the problem is at the client side or at the host side.
Remember that TNS is similar to TCP/IP, i.e you have to list both the instance and the domain correct.
/ilver
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
