ID: 29779
Comment by: olaf dot imig at bifab dot de
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:
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.
Previous Comments:
------------------------------------------------------------------------
[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...
------------------------------------------------------------------------
[2004-08-21 21:59:10] [EMAIL PROTECTED]
Yes, these functions establish new connection. But this error can be
also concerned with internal Oracle Interface Library problems (search
this error message in google) and not with PHP.
Nevertheless, PHP doesn't ping already established connections, because
it would slow down things too much. Probably in the future we will add
an ini setting for it, but currently ociping() is just disabled for
perfomance reasons.
------------------------------------------------------------------------
[2004-08-21 21:23:56] robertg2 at hope dot ac dot uk
Thanks Tony. Can I just clarify something - are you saying that
oci_new_connect() and ocinlogon() don't actually establish new
connections? I was under the impression that these functions forced a
new connection to be made.
------------------------------------------------------------------------
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
