ID: 29779
Comment by: cameron at woods-clan 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 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.
Previous Comments:
------------------------------------------------------------------------
[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.
------------------------------------------------------------------------
[2005-02-03 10:49:49] olaf dot imig at bifab dot de
Getting a very similar problem after PHP-Upgrading with following
system:
Solaris 8 32 bit Oracle 8.1.7.0.0 and Apache 2.0.52 PHP 5.0.3
After shutdown and startup database first I got ORA-03113 (end-of-file
on communication channel) and then ORA-24327 (need explicit attach
before authenticating a user). With the same system and PHP 4.3.10 I
have no problems, because of that I think, it is too simple to say and
not helpful, thats an Oracle-Problem.
------------------------------------------------------------------------
[2005-02-01 11:48:06] rickyblankenaufulland at leonardo dot de
Expiring the same problem on Linux (Fedora 2, Kernel 2.6.5). Restarting
Apache with option graceful is okay in an internal environment but
fixing this error would be very nice too ;-)
------------------------------------------------------------------------
[2004-11-22 15:00:06] robertg2 at hope dot ac dot uk
I ended up using the oracle extension rather than the oci8 extension.
Have had no problems since.
------------------------------------------------------------------------
[2004-11-22 14:44:29] stasamj at kscems dot ksc dot nasa dot gov
Getting a very similar problem with database on Solaris 8 64-bit Oracle
8.1.7.3.0 using Oracle 9.2.0.5 listener, PHP server 4.3.7 on RedHat
Linux (2.4)/Apache 1.3. Following weekly cold backup, PHP keeps trying
to use cached persistent connections, giving ORA-24327 and/or ORA-03113
(end-of-file on communication channel). Can trap the error, but can't
figure out how to flush the dead connections from the connection cache!
Hate to cron an Apache restart daily...
------------------------------------------------------------------------
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
