| Error ORA 12560: Reply required urgently [message #67057] |
Wed, 23 July 2003 01:22  |
vivek gupta
Messages: 2
Registered: February 2003
|
Junior Member |
|
|
Hello
All
I am getting an error of ORA 12560 :TNP ADAPTOR SYSTEM
During connection
Tnsnames.ora
# D:ORACLEORA81NETWORKADMINTNSNAMES.ORA Configuration File:d:OracleOra81NETWORKADMINtnsnames.ora
# Generated by Oracle Net8 Assistant
MYDATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = anil)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MyData)
)
)
listener.ora
# D:ORACLEORA81NETWORKADMINTNSNAMES.ORA Configuration File:d:OracleOra81NETWORKADMINtnsnames.ora
# Generated by Oracle Net8 Assistant
MYDATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = anil)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MyData)
)
)
This is an urgent.Please do reponse urgently.I have to submit my project in four days
Vivek Gupta
|
|
|
|
|
|
| Re: Error ORA 12560: Reply required urgently [message #67059 is a reply to message #67057] |
Wed, 23 July 2003 22:38  |
Rajendra
Messages: 23
Registered: September 2000
|
Junior Member |
|
|
Oracle Clinet / Server is unable to resolve IP-Address of the from the host name.
So either replace your host name with IP Address in tnsnames.ora & listener.ora @ server and client m/c's
If this is not preferable enable the SQL Client Tracing , Set it to Admin Level in sqlnet.ora & just go through the log, at what point IP-Lookup is failing
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
