#24343 [Com]: Oracle 9.2.0 client libs do not work

ID: 24343 Comment by: timothy_haak at yahoo dot com Reported By: thomas at fivemile dot net Status: No Feedback Bug Type: OCI8 related Operating System: Redhat Linux 8.0 PHP Version: 4.3.3-dev New Comment: Hi sorry ment to add the script as well I have also tested connecting from sqlplus which i can do. <?php ociinternaldebug(1); if (OCILogon("<username>", "<password>", "pierceg")) { echo "Successfully connected to Oracle.\n"; } else { echo "Oracle Connect Error "; } ?> Previous Comments: ------------------------------------------------------------------------ [2004-02-14 08:38:43] timothy_haak at yahoo dot com Hi I am having a similar issue to the person below here is what the screen prints out when I ad the ociinternaldebug(1); to the top of the file. Warning: ocilogon() [function.ocilogon]: OCISessionBegin: ORA-00604: error occurred at recursive SQL level 1 ORA-00911: invalid character in /Scripts/WEB/test.php on line 3 OCIDebug: _oci_open_session: FAILURE -> CLEANUP called OCIDebug: START _oci_close_session: logging-off sess=0 OCIDebug: _oci_close_session: logging-off DEAD session OCIDebug: oci_do_connect: FAILURE -> CLEANUP called OCIDebug: START _oci_conn_list_dtor: id=0 OCIDebug: END _oci_conn_list_dtor: id=0 Oracle Connect Error OCIDebug: START php_rshutdown_oci OCIDebug: END php_rshutdown_oci I have tried compiling with both php versions PHP 5.0 Beta 4 and PHP 4.3.4 Here is what is loaded into my profile. ORACLE_BASE=/u01/oracle export ORACLE_BASE ORACLE_HOME=/u01/oracle/product/9.2 export ORACLE_HOME ORACLE_SID=PIERCEG export ORACLE_SID PATH=$PATH:$HOME/bin:/u01/oracle/product/9.2/bin export PATH USERNAME="" export USERNAME CLASSPATH=:.:/u01/oracle/product/9.2/jdbc/lib/classes111.zip export CLASSPATH LD_LIBRARY_PATH=/u01/oracle/product/9.2/lib export LD_LIBRARY_PATH ORA_NLS33=/u01/oracle/product/9.2/ocommon/nls/admin/data export ORA_NLS3 NLS_LANG="ENGLISH_UNITED KINGDOM.WE8MSWIN1252" export NLS_LANG NLS_DATE_FORMAT="RRRR-MM-DD HH24:MI:SS" export NLS_DATE_FORMAT PATH=$PATH:/usr/local/jre/bin export PATH LD_ASSUME_KERNEL=2.4.1 export LD_ASSUME_KERNEL Here is the configuration info './configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with-oci8' '--enable-track-vars' '--enable-ftp' '--enable-sigchild' '--with-gd' '--enable-gd-native-ttf' '--with-ttf' '--with-freetype-dir=/usr/local/freetype' '--with-jpeg-dir=/usr/lib/' '--with-zlib' '--with-png-dir=/usr/lib/' '--with-xpm-dir=/usr/X11R6' '--with-ldap' '--enable-exif' '--with-png' '--without-tsrm-pthreads' '--enable-inline-optimization' '--with-tiff=/usr/lib/' From phpinfo oci8 OCI8 Support enabled Revision $Revision: 1.248 $ Active Persistent Links 0 Active Links -3 Oracle Version 9.2 Compile-time ORACLE_HOME /u01/oracle/product/9.2 Libraries Used no value Temporary Lob support enabled Collections support enabled ------------------------------------------------------------------------ [2003-07-20 10:41:59] sniper@php.net No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. ------------------------------------------------------------------------ [2003-07-13 10:45:30] sniper@php.net Try adding "ociinternaldebug(1);" in the beginning of your script. That'll make the functions to print out some extra debugging information. ------------------------------------------------------------------------ [2003-07-13 05:54:10] thomas at fivemile dot net Okay, once again, slowly. - installed a fresh oracle 9.2.0 - installed a fresh apache with PHP and linked against oracle - does NOT work - copied over the entire /opt/oracle/product/9.0.1 tree from another machine where the libs work - installed a fresh apache with PHP linked against those other libs - CHANGED the environment vars so the 9.0.1 libs are used instead of the 9.2.0 libs - now it works - NO thanks to wild guesses from the bugs team. i have installed a couple of working oci/php combos so far, the 9.2.0 is the first one where i ran into these kind of problems. And you can't earnestly expect new users to fiddle with libs for 2 weeks till their oci bindings start to work... If you like, you can have an account on the box in question and have a look around yourself. However i am NOT satisfied with the answer 'okay, you made a crude hack, and by chance it worked, now use it and stop bugging us' ------------------------------------------------------------------------ [2003-07-08 11:40:16] sniper@php.net Then use those. Wild guess: The SAME environment vars don't work with DIFFERENT oracle version.. ------------------------------------------------------------------------ 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