|
|
Posted by Andy Hassall on 12/17/05 12:49
On Fri, 16 Dec 2005 18:34:24 -0500, PHPguy <PHP@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 :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Navigation:
[Reply to this message]
|