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

ID: 24343 User updated by: thomas at fivemile dot net Reported By: thomas at fivemile dot net -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: Redhat Linux 8.0 PHP Version: 4.3.3-dev New Comment: the SAME script on the SAME machine works with the 9.0.1 client libs I copied over from the other machine. Only the 9.2.0 client libs (using the SAME script, the SAME php, the SAME apache and the SAME configure line) do not work. Previous Comments: ------------------------------------------------------------------------ [2003-07-07 19:29:08] sniper@php.net 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 ?? ------------------------------------------------------------------------ [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? ------------------------------------------------------------------------ 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