#24343 [Opn->Bgs]: 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: Bogus Bug Type: OCI8 related Operating System: Redhat Linux 8.0 PHP Version: 4.3.3-dev New Comment: Then use those. Wild guess: The SAME environment vars don't work with DIFFERENT oracle version.. Previous Comments: ------------------------------------------------------------------------ [2003-07-08 10:52:15] thomas at fivemile dot net 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. ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ 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