After 3 months of headache and intermittent seg faults on Solaris 9, we decided to give SLES 9 a try. Now we get continuous seg faults. I am running apache 2.0.54 on SLES 9 with all updates, and Oracle 10.2.0.1<http://10.2.0.1>. (everything is the 32-bit flavor) I built PHP as follows: adcinfops02:/usr/local/httpd-2.0.54/htdocs #./configure --prefix=/usr/local/php-5.0.5 --with-apxs2=/usr/local/httpd-2.0.54/bin/apxs --enable-cli --enable-debug --with-config-file-path=/usr/local/php-5.0.5/lib --enable-sigchild --with-zlib --with-bz2 --enable-ftp --with-gettext --enable-mbstring --with-ncurses --with-oci8=/u01/app/oracle/product/10.2 --enable-session --enable-sockets --enable-shared --disable-xml --disable-libxml --disable-dom --with-jpeg-dir=/usr/lib --with-png-dir=/usr/lib --with-zlib-dir=/usr/lib --with-xpm-dir=/usr/lib --disable-simplexml --without-pear Here is the simply php page that seg faults _every_ time it is called. (On solaris, it only seg faulted 25% of the time) <?php putenv("ORACLE_HOME=/u01/app/oracle/product/10.2"); putenv("ORACLE_SID=ADCDM02"); putenv("TNS_ADMIN=/var/opt/oracle"); $ora = ociplogon("dm","mypassword", "MYSID"); $stmt=OCIParse($ora, "select USERNAME from dba_users"); $res=OCIExecute($stmt); $rows = OCIFetchstatement($stmt, $results); print "DEBUG: rows=$rows<BR>\n"; $keys = array_keys($results); foreach($keys as $key) { print "$key<BR>\n"; } for($i=0; $i < $rows; $i++) { print " " . $results["USERNAME"][$i] . "<BR>\n"; } OCIFreeStatement($stmt); OCILogoff($ora); ?> I can run this script 100 times from the command line ( # php oratest.php ) and not a single seg fault. Anyone have any idea why this is happenning? Also, is there a config, any OS, any version, and combination AT ALL, where PHP is reliable when using Oracle 10g as the back end? Any configuration at all? Thx, CC --
