Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to connect Php5.3 with Oracle 11gR2 on NetBeans 7.4

Prince GuptaJan 29 2014 — edited Feb 27 2014

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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 27 2014
Added on Jan 29 2014
2 comments
3,038 views