Hi. Stefan
the returned error is TNS-12162 TNS:service name is incorrectly specified
Cause: The connect descriptor corresponding to the service name in
TNSNAMES.ORA is incorrectly specified.
Action: Make sure there are no syntax errors in the connect descriptor.
Particularly look for unmatched p
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
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
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.
hi Carlos,
looks like ORACLE_HOME and/or LD_LIBRARY_PATH are not set correct during
execution.
1. afer setting the variables with putenv check if they are really set with
phpinfo(INFO_ENVIRONMENT);
2. if they are still not set correct (what might be the problem, export them in
your apache startsc