ORA-12560 TNS protocol adapter error

[satishpc]

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

[sreddy]

Check for documentation on your tnsnames.ora/listener.ora/remote password file authentication.
Problem is in either of these three.

[Barabas]

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.....

[Barabas]

sorry forgot this

3. Try putting the IP address in the host name. and try to see if that works.