ID: 29779 Comment by: jfbustarret at tf1 dot fr 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 had the same problem and wrote a small patch : http://www.jeuxdecartes.net/static/oci8.ping_freq.patch It adds a oci8.ping_freq php.ini variable (oci8.ping_freq = 60 is a good start). Previous Comments: ------------------------------------------------------------------------ [2005-07-22 21:41:12] bradpover at gmail dot com I too would appreciate a quick fix to this feature (what does the suspended status mean?). I see the error message using PHP 5.0.4, Apache 2.0.54 on win2k talking to a remote Oracle 10g database through Instant Client. BTW the suggestion to uncomment out ociping() in ori8.c may be for oci_ping() instead? That's what's in the win php5 source anyway. I just need a compiler now (the ms visual c++ toolkit 2003 does not include msdev which is needed to build resolv.lib - what a thing to find out _after_ downloading and installing 1GB of mostly not needed packages). On the brighter side I am running windows so system crashes and reboots will make my admin job easier for once. :) ------------------------------------------------------------------------ [2005-07-13 09:30:00] ecervetti at ch-hyeres dot fr I use php 5.0.4 On mandrake linux, the bug remains; but I can't see any ociping() function in oci8.c !!!! ------------------------------------------------------------------------ [2005-07-01 19:20:17] chung dot ley at amd dot com Why does 4.3.10 not have this problem? Is it because it is doing the ociping() or similar which means that its performance is less than the 5.0? Or just that the 5.0.x has special optimization with using the Oracle internal library? What is the status of the fix? Will it be in the next release or maybe the next next release? How can I help to push the priority of the fix? I perfer not to use 4.3.10 because I will need to re-test all my applications on 4.3.10, and I also prefer not to uncomment ociping() so that I don't have to degrade the performance... In other words, I want everything :DDD Thanks.... ------------------------------------------------------------------------ [2005-06-13 19:58:39] wustl_2008 at yahoo dot com 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. ------------------------------------------------------------------------ [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... ------------------------------------------------------------------------ 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
