Do you have a question? Post it now! No Registration Necessary. Now with pictures!
December 16, 2005, 11:34 pm
rate this thread
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??
Re: PHP 5.1.1 and Oracle 10
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 :: firstname.lastname@example.org :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool