PHP 5.1.1 and Oracle 10

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I am having serious issues with PHP5/Apache on Solaris 10 (sparc) with
Oracle 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??


Re: PHP 5.1.1 and Oracle 10

Quoted text here. Click to load it

 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

Andy Hassall :: :: :: disk and FTP usage analysis tool

Site Timeline