Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Oracle Database Archived Forums
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Aug 28, 2012 8:17 PM by
ORA-12514 error: Instant Client 11 connect to remote Oracle 8i
Aug 28, 2012 6:20 PM
I encountered a problem that I have spent hours fixing that. Here is the problem:
I am trying to connect to a remote
i server using
instant client: here is my connection string in
*$conn = oci_connect('db_user', 'db_pass', "db_ip/db_service");*
db_ip is the ip of the server, such as "18.104.22.168". db_service is the service of server, such as "test".
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. db_service is not provided.
I dont use tnsnames.ora for either oracle *10g s*erver 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.
This content has been marked as final.
Show 1 reply
Re: ORA-12514 error: Instant Client 11 connect to remote Oracle 8i
Aug 28, 2012 8:17 PM
in response to
Pl do not post duplicates -
PHP 5.2.17 and Oracle 8i