Re: OCI ORA-12154 error

Hi Richard, hola David, even so my php4 is running on the server where the database is installed, I tried your putenv to all of the oracle variables. It did not change any. All these variables are usually set by the root profile where oracle and apache start: K10oracle K20apache I had the OCIInternalDebug on and opened : $conn = OCILogon($PHP_AUTH_USER, $PHP_AUTH_PW, "TEST"); the return was: OCIDebug: _oci_open_server: FAILURE -> CLEANUP called OCIDebug: START _oci_close_server: detaching conn=0 dbname=INET OCIDebug: _oci_close_server: closing DEAD server OCIDebug: oci_do_connect: FAILURE -> CLEANUP called OCIDebug: START _oci_conn_list_dtor: id=0 OCIDebug: END _oci_conn_list_dtor: id=0 but still there was no entry in the lsnrtrace file. I this checked with sqlplus, tnsping and an own version of OCI from a WinNT4 program I wrote. They all enter values into the tracefile. It seems that for some reason the libclntsh.8.0.so library does not find the tnsnames.ora file and does not even attempt to connect to the listener. Since the time it worked I had to reinstall the apache and also the php4.rpm. Maybe this is the problem. Is there a chance to find out why the library does not find the tnsnames.ora or how to trace the function calls in the library ? thx Rainer