PHP 5.1.1 and Oracle 10

[PHPguy]

I am having serious issues with PHP5/Apache on Solaris 10 (sparc) with
Oracle 10.2.0.1.0 Enterprise.

I can't connect to it using PHP and get the following:

Warning: ociplogon() [function.ociplogon]: _oci_open_server: Error while
trying to retrieve text for error ORA-12170

Sqlplus and Tnsping work fine.

Any hints as to how to go about debugging this? How can I trace this??

Thanks

[Andy Hassall]

On Fri, 16 Dec 2005 18:34:24 -0500, PHPguy <PH*@donemailme.net> wrote:

I am having serious issues with PHP5/Apache on Solaris 10 (sparc) with
Oracle 10.2.0.1.0 Enterprise.

I can't connect to it using PHP and get the following:

Warning: ociplogon() [function.ociplogon]: _oci_open_server: Error while
trying to retrieve text for error ORA-12170

ORACLE_HOME isn't set for the webserver's environment, or if it is, it's
either wrong, or access is denied to the user running the webserver, at least
to the directories that contain the error message text.

It seems likely that PATH and/or LD_LIBRARY_PATH are correctly set since it's
got far enough to load the Oracle libraries in the first place.

ORA-12170 is "TNS:Connect timeout". If ORACLE_HOME isn't right, it's possible
it's not picking up tnsnames.ora, falling back to host naming, and then timing
out.

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool