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.ociplo gon]: _oci_open_serve r: 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]

Re: PHP 5.1.1 and Oracle 10

On Fri, 16 Dec 2005 18:34:24 -0500, PHPguy <PHP@donemailme .net> wrote:
[color=blue]
>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.ociplo gon]: _oci_open_serve r: Error while
>trying to retrieve text for error ORA-12170[/color]

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:Connec t 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 :: andy@andyh.co.u k :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool