#24343 [Opn->Fbk]: Oracle 9.2.0 client libs do not work

ID: 24343 Updated by: sniper@php.net Reported By: thomas at fivemile dot net -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Redhat Linux 8.0 -PHP Version: 4.3.2 +PHP Version: 4.3.3-dev New Comment: Try a script which has ONLY that one line. And you're sure your username/password doesn't contain any illegal chars? And your db name is tns.domain ?? Previous Comments: ------------------------------------------------------------------------ [2003-06-26 18:36:52] thomas at fivemile dot net Warning: ociplogon(): OCISessionBegin: ORA-00604: error occurred at recursive SQL level 1 ORA-00911: invalid character in /home/httpd/index.php3 on line 3 or Warning: ocilogon(): OCISessionBegin: ORA-00604: error occurred at recursive SQL level 1 ORA-00922: missing or invalid option in /home/httpd/index.php3 on line 3 'Line 3' is simply the OCILogon or OCIPLogon as follows: $ohnd = OCILogon("dvd","hidden","tns.domain"); ------------------------------------------------------------------------ [2003-06-26 18:30:36] sniper@php.net With what script and what errors do you get..? ------------------------------------------------------------------------ [2003-06-26 18:23:19] thomas at fivemile dot net environment of the defunct server (from phpinfo()) NLS_LANG german_germany.WE8DEC LD_LIBRARY_PATH /opt/oracle/product/9.2.0/lib:/lib:/usr/lib:/opt/apache2/lib::/usr/local/lib ORACLE_SID tsid ORACLE_BASE /opt/oracle PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin:/opt/oracle/product/9.2.0/bin PWD / LANG en_US.UTF-8 ORACLE_TERM xterm SHLVL 1 ORA_NLS33 /opt/oracle/product/9.2.0/ocommon/nls/admin/data ORACLE_HOME /opt/oracle/product/9.2.0 _ /sbin/initlog and the environment of the working server: PWD /home ORACLE_SID TSID LD_LIBRARY_PATH /opt/oracle/product/9.0.1/lib:/lib:/usr/lib:/usr/local/lib CLASSPATH /opt/oracle/product/9.0.1/JRE:/opt/oracle/product/9.0.1/jlib:/opt/oracle/product/9.0.1/rdbms/jlib:/opt/oracle/product/9.0.1/network/jlib LANG en_US ORACLE_BASE /opt/oracle ORACLE_HOME /opt/oracle/product/9.0.1 ORACLE_TERM 386 SHLVL 3 ORA_NLS33 /opt/oracle/product/9.0.1/ocommon/nls/admin/data PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin NLS_LANG german_germany.WE8DEC _ /sbin/initlog if i log into the webserver user on the non-functioning host i can access the oracle db with sql*plus just fine. ------------------------------------------------------------------------ [2003-06-26 17:54:50] sniper@php.net Have you set all the necessary environment variables correctly when you start apache? ------------------------------------------------------------------------ [2003-06-26 16:03:28] thomas at fivemile dot net The snapshot seems to have cleared the segfaults, nevertheless the weird oracle error messages remain. Is there a way to debug the OCI(P)Logon and compare it with the data the working server is sending? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/24343 -- Edit this bug report at http://bugs.php.net/?id=24343&edit=1