my listener is running on server,tnsping is ok at client node, but sql*plus is not connecting giving the error-
ORA-12545 TNS:name lookup failure
This message occurs when the listener on the remote node cannot be contacted. The ADDRESS in the TNSNAMES.ORA file or the LISTENER.ORA file may be incorrect. This message may also appear if the listener on the remote node has not been started. Check its status with the STATUS command of the Listener Control Utility, and start it with the START command if necessary.
this is the tnsnames.ora-
# E:\ORACLE\ORAHOME81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:E:\oracle\orahome81\network\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant
ORACLE1 is in the right order.
It's correct about SERVICE_NAME and SID_NAME, those methods are not compatible.
If you want to use SERVICE_NAME, you have to put it in the listener too.
The easy way is changing everything to SID_NAME
11-09-2000, 06:00 AM
I tried with the same as U told but still the same problem persists.I changed the service name to SID in tnsnames.ora.still ora-12545 comes up .
11-09-2000, 07:48 AM
As pst suggest,give the IPADDRESS in the host place in tnsnames.ora and give a try.
One more way u can give a try is just rename the existing tnsnames.ora and listener.ora.
Try giving the IPaddress when u use net8 assistant as well.
Create a new tnsnames.ora using net8 assistant.Stope the listener and start the listener again