error ORA-12154, with PHP3 Oci8 Apache

[Anon]

Hi:

I've installed PHP4 with Oracle 8.1.5 and Apache on Linux, and when I'm trying to do OCILogon("asdfs","asdf","sid") I get the next error message:

Warning: _oci_open_server: Error while trying to retrieve text for error ORA-12154 in /usr/local/apache/htdocs/oci8.php on line 1

Does anybody know anything about it? When I do phpinfo() it shows that oci8 support is enabled. Would this error refer to tnsnames.ora file? Pleasssseee... I need help... I'm desesperate!! :)

Thanks... and sorry for my english!

[Anon]

You're not lucky, you got an error and not even the text for it ;-)
I suppose some environment variables are missing. A good place to put them is in apachectl script :

ORACLE_HOME=...; export ORACLE_HOME
PATH=$PATH:$ORACLE_HOME/bin; export path

and same with ORACLE_BASE, NLS_LANG, ORA_NLS33, LD_LIBRARY_PATH...

Should work. And your english is nice ;-)

[Anon]

OK!!

Fantastic. It's working good!! Thanks for your help!. The environment variables weren't ok, but i've put them into apachectl file, and now everything is correct.

Thanks, again. See you soon!

[Anon]

Olivier,

Your email also show me the light. It works after I put all the oracle environment setting on the apachectl script.

Thank you so much!! I appreciate your suggestion!!

Sheeta

[Anon]

Thanks for help!

[Anon]

THANX A LOT FOR posting this mail ......i had a similar problem and it was solved thanx to ur mail


regards,
kiran