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


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to