hi
i am trying to connect to an ora 8.1.6 database on NT but it is giving me this error
ORA-12560 TNS protocol adapter error
what is the way out ?
satish
Printable View
hi
i am trying to connect to an ora 8.1.6 database on NT but it is giving me this error
ORA-12560 TNS protocol adapter error
what is the way out ?
satish
Check for documentation on your tnsnames.ora/listener.ora/remote password file authentication.
Problem is in either of these three.
Hows it going
Sounds like, its a problem with your tns names file,
1. Make sure you can ping the server,
2. And ensure, that the tnsnames file is configured correctly.
XR01.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Xr01)
(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xr01)
)
)
Hope this syntax helps.....
sorry forgot this
3. Try putting the IP address in the host name. and try to see if that works.