Beni ... I am using the same setup as you are describing ... Here is my 
connect information ...


The error that you are getting ORA-12154 has the following text on a 
lookup ... This leads me to believe that php is unable to find your 
tnsnames.ora file or the tns entry is invalid.  I would try to connect to 
your DB from sqlplus from your php server [ sqlplus 
username/[EMAIL PROTECTED] ].

[oracle @ usphdba]: oerr ora 12154
12154, 00000, "TNS:could not resolve service name"
// *Cause:  The service name specified is not defined correctly in the
// *Action:  Make the following checks and correct the error:
//           - Verify that a TNSNAMES.ORA file exists and is in the proper
//             place and accessible. See the operating system specific 
//             for details on the required name and location.
//           - Check to see that the service name exists in one of the
//             TNSNAMES.ORA files and add it if necessary.
//           - Make sure there are no syntax errors anywhere in the file.
//             Particularly look for unmatched parentheses or stray 
//             Any error in a TNSNAMES.ORA file makes it unusable. See
//             Chapter 4 in the SQL*Net V2 Administrator's Guide. If
//             possible, regenerate the configuration files using the 
//             Network Manager.

Roy A. Jones 
US Pharma Database Administration 
GlaxoSmithKline Inc. US Pharma IT, Shared Services 

"Beni Buess" <[EMAIL PROTECTED]> 
15-Jun-2004 10:14

[PHP-DB] Connecting to Oracle DB on antother server


I'm trying to connect to an oracle database which is itself on antother
server than php is running. on the php machine is an oracle client
succesfully installed.
i've tried the different functions to connect to oracle:


as well as ocinlogon, both with and without the optional third
parameter, where i gave the name of the entry in tnsnames.ora as well as
the value of ORACLE_SID.

i always got a following error message:
Warning: ociplogon() [function.ociplogon]: _oci_open_server: Error while
trying to retrieve text for error ORA-12154

could anybody point me to the right direction, or is there somebody who
has already done such a connection and could give me an example.

thanks a lot...


This message may contain legally privileged or confidential 
information and is therefore addressed to the named persons only. 
The recipient should inform the sender and delete this message, 
if he/she is not named as addressee. 
The sender disclaims any and all liability for the integrity 
and punctuality of this message. 
The sender has activated an automatic virus scanning by 
Messagelabs, but does not guarantee the virus free 
transmission of this message.

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to