Hallo Andreas, hi Richard, hola David,
with your help I now found the problem.
when I checked with
echo phpinfo(INFO_ENVIRONMENT);
I saw that ORACLE_HOME was not set anymore and LD_LIBRARY_PATH was set wrong.
I first tried to set these variables with
putenv("ORACLE_HOME=/opt/oracle/product.
> even so my php4 is running on the server where the database is installed,
>
> I tried your putenv to all of the oracle variables.
putenv won't help. The Oracle client libraries are initialized during
server startup, so they won't see the environment set via putenv in a
PHP script. This applie
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 OCIInte
For what it's worth, here is the script I've been using to hook up to
Oracle (specific for my system removed, of course...):
Success" ;
} else {
echo "Failed connecting to oracle. Exiting program.";
exit;
}
?>
The key proved to be the two putenv statements at the beginning.
Hi,
I compiled php4 with oci8 support and once the communication was
working.
Now I allways get the result ORA-12154: could not resolve servicename.
I tried tnsping and sqlplus with the listener tracelevel switched to
ADMIN
With sqlplus I get messages into the tracefile and a connection.
tnsping
