Beni ... I am using the same setup as you are describing ... Here is my
connect information ...
OCILogon($username,$password,$tns_alias)
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/password@tns_alias ].
[oracle @ usphdba]: oerr ora 12154
12154, 00000, "TNS:could not resolve service name"
// *Cause: The service name specified is not defined correctly in the
// TNSNAMES.ORA file.
// *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
manual
// 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
characters.
// 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
Oracle
// Network Manager.
Roy A. Jones
US Pharma Database Administration
GlaxoSmithKline Inc. US Pharma IT, Shared Services
Email: roy.a.jones@xxxxxxx
"Beni Buess" <beni.buess@xxxxxxxxxxxx>
15-Jun-2004 10:14
To
php-db@xxxxxxxxxxxxx
cc
Subject
Connecting to Oracle DB on antother server
Hi,
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:
ociplogon('user','pass');
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...
Beni
____________________________________________________________
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 (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
