ID: 29779 Comment by: wustl_2008 at yahoo dot com Reported By: robertg2 at hope dot ac dot uk Status: Suspended Bug Type: OCI8 related Operating System: Solaris 8 PHP Version: 5.0.1 Assigned To: tony2001 New Comment:
I am experiencing the same problem on Apache 5.0.0 with Oracle 9.2. Any solutions besides rebooting the Apache server are greatly appreciated as I cannot afford to reboot the apache server since I am unable to know when the database has gone down for certain. I am capturing the error codes from OCIError and can determine the cause, but am unable (due to user abilities on the Linux system) to reboot Apache with a script, etc. Fix on this ASAP would be greatly appreciated. Previous Comments: ------------------------------------------------------------------------ [2005-05-24 14:28:34] rootradical at hotbox dot ru I have the same "feature" (oci_connect(): OCISessionBegin: ORA-24327: need explicit attach before authenticating a user) using PHP 5.0.4 on Win2k SP4, Apache 2.0.47, Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production. Unfortunately, I can't recompile oci8.c with ociping() enabled and it's very inconveniently to restart Apache every time database goes down. I hope you release some fix in the not too distant future. Because of this I need to use PHP 4.3... ------------------------------------------------------------------------ [2005-05-06 20:35:16] chris dot chen at sun dot com well, I just wanted to note that. I encountered this problem intermittently with: php-5.0.4/solaris-10/apache-1.3.33 php-5.0.4/solaris-9/apache-1.3.29 oracle's instantclient-10.1.0.3 Oracle9i Enterprise Edition Release 9.2.0.5.0 from both: oci_connect/oci_new_connect($1, $2, $3). ------------------------------------------------------------------------ [2005-05-03 00:39:14] mark_vandersteen at national dot com dot au We are getting this bug regularly as well. We are using the Oracle-Instant-Client / php 5.0.3 / apache2 on a linux fedora 3 box. ------------------------------------------------------------------------ [2005-04-05 15:34:53] cameron at woods-clan dot com I am experiencing the same issue using IPL 6.1, php 5.0.3 and Oracle 9.2.0.6 64-bit, we are running on Solaris 8. I need to find a better solution than restarting the server or as it has been indicated uncommenting ociping() from the oci8.c and recompiling since there are indications that this will degrade performance. ------------------------------------------------------------------------ [2005-03-07 18:12:19] rcarvalho at queirozgalvao dot com I have the same error with PHP under Windows 2003/IIS accessing Oracle 8.1.7 with 8.1.7 client. I have tried every thing that was sugested in this paper, but the error remains. ------------------------------------------------------------------------ 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/29779 -- Edit this bug report at http://bugs.php.net/?id=29779&edit=1