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!

PHP 5.2.17 and Oracle 8i

958588Aug 28 2012 — edited Aug 29 2012
Hi there,

I encountered a problem that I have spent hours fixing that. Here is the problem:

I am trying to connect to a remote Oracle 8i server using Oracle 11g client: here is my connection string in PHP:

$conn = oci_connect('db_user', 'db_pass', "db_ip");

db_host is the ip of the server, such as "12.34.56.78".

The error shown is "*ORA-12514: TNS:listener does not currently know of service requested in connect descriptor*"

I could use the same client to connect to another oracle 10g server. The php code is same, only change the db_user or db_pass or db_ip.

I dont use tnsnames.ora for either oracle 10g server or oracle 8i server. I just use the simple IP of server. Does this matter?

Server using: Windows Server 2008 R2
PHP: php 5.2.17
Oracle Instant Client: 11_2

Any ideas will be appreciated.

Best,
Sam
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2012
Added on Aug 28 2012
3 comments
2,279 views