#35574 [Fbk]: Error: OCILogon error::ORA-24327: need explicit attach before authenticating a

ID: 35574 Updated by: tony2001@php.net Reported By: scott dot zhao at usask dot ca Status: Feedback Bug Type: OCI8 related Operating System: SunOS PHP Version: 5.1.1 New Comment: Thank you for this bug report. To properly diagnose the problem, we need a backtrace to see what is happening behind the scenes. To find out how to generate a backtrace, please read http://bugs.php.net/bugs-generating-backtrace.php Once you have generated a backtrace, please submit it to this bug report and change the status back to "Open". Thank you for helping us make PHP better. Previous Comments: ------------------------------------------------------------------------ [2005-12-07 23:11:09] earl dot fogel at usask dot ca Thanks, the buildconf helped somewhat. Php builds properly now, and I can load the module into apache, but now our apache children are dying: [Wed Dec 7 15:15:58 2005] [notice] child pid 29531 exit signal Segmentation Fault (11) [Wed Dec 7 15:16:47 2005] [notice] child pid 29545 exit signal Segmentation Fault (11) [Wed Dec 7 15:16:47 2005] [notice] child pid 29483 exit signal Segmentation Fault (11) We are using apache 1.3.33 with php 5.1.1 on Solaris 9. ------------------------------------------------------------------------ [2005-12-07 18:19:18] tony2001@php.net Did you run ./buildconf --force after that? ------------------------------------------------------------------------ [2005-12-07 18:09:06] earl dot fogel at usask dot ca I downloaded the latest oci8 module from PECL CVS, and replaced the ext/oci8 directory that came with php 5.1.1 with the CVS version. When I run 'make', it fails with lots of "undefined symbol" errors, eg: ild: (undefined symbol) zif_oci_pconnect -- referenced in the data segment of ext/oci8/.libs/oci8.o ild: (undefined symbol) zif_oci_connect -- referenced in the data segment of ext/oci8/.libs/oci8.o ild: (undefined symbol) zif_oci_field_type -- referenced in the data segment of ext/oci8/.libs/oci8.o Here's the configure line I used: ./configure --prefix=/usr/local/encap/php-5.1.1 --with-oci8=/oracle/product/9205 --with-xmlrpc --with-ldap --with-curl=/usr/local/encap/curl-7.14.1 --without-pdo-sqlite --with-apxs=/var/apache-test/sbin/apxs --enable-memory-limit What do I do now? ------------------------------------------------------------------------ [2005-12-06 19:34:18] tony2001@php.net Please try OCI8 from PECL CVS. ------------------------------------------------------------------------ [2005-12-06 19:24:03] scott dot zhao at usask dot ca Description: ------------ It appears that the Bug #29779 was not fixed in 5.1.1, but #29779 has been closed. So I have to open a new one here for 5.1.1 The problem is: After the backend Oracle bounced the "Error: OCILogon error::ORA-24327: need explicit attach before authenticating a user" error ocuured. Enviorment: PHP: 5.1.1 OS: SunOS 5.9 Oracle version: 9.2 OCI $Revision: 1.269.2.3 $ Reproduce code: --------------- - Connect to an oracle database using PHP oci8 functions from within Apache - Knock that database offline - Attempt to connect again using PHP oci8 functions within same instance of apache - Put the database back online - Again, attempt to connect to Oracle database from within apache using OCI8 functions Actual result: -------------- ORA-24327: need explicit attach before authenticating a user ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=35574&edit=1