Issue:-
=====
on "tnsping service_name" getting an error "Failed to resolve the name"
Environment:-
===========
->OS Name Microsoft Windows 7 Enterprise
Version 6.1.7601 Service Pack 1 Build 7601
->PHP 5.3 & tried with 5.4
->Oracle 11gR2
->NetBeans 7.4
->Oracle instant client 11_2 32 bit & tried with 64 bit as well
->Xampp server 1.8 & tried with lower version also.
->path location of instant client : C:\Windows\SysWOW64
->environment variable: C:\Windows\SysWOW64\instantclient_11_2
Troubleshooting:-
========
-> tried to do tnsping with service name and alias name also, getting failed to resolve name.
-> port 1521 is listening.
-> firewall is turned off.
-> tried to change the port from 1521 to 1527 but getting same error.
-> checked the registry and found correct entries for tns_admin and oracle_home.
-> tried to change the service name as well, no success.
-> changed the sid name to service name in tnsnames.ora file, no success.
-> restarted the listener service several times, no success.
-> system is rebooted various times after setting environmental vaiable for instant client.
-> localhost is resolved by 127.0.0.1 IP.
-> checked the trace file of tnsping, found nothing special.
-> checked the log file of tnssping and found following error:-
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
64-bit Windows Error: 48: Unknown error
Please help, we are struggling with this issue since last two weeks, and we are in mid of our project.
Thanks in advance.
Prince Kumar
Citrix R&D