The version of PHP that this bug was reported in is too old. Please
try to reproduce this bug in the latest version of PHP (available
from http://www.php.net/downloads.php

If you are still able to reproduce the bug with one of the latest
versions of PHP, please change the PHP version on this bug report
to the version you tested and change the status back to "Open".

I have exactly the same problem with PHP 4.1.1
Do I need to change the php version to solve this bug ?

Yes. Try the lastest CVS from snaps.php.net and, if this still happens, give us some more details.

Hi, 

The last news about our ORA-24327 error....
We changed the version of php into 4.2.3 and it seems that the connection failed problem has disappeared.
Thanx for your advice,

Caroline :o)

Note:

Bug?#21897
ORA-03113: end-of-file on communication channel

is relevant, but close because duplicated.

This one seems to be "bogus", though i hpe to see whether the bug can still be encountered and have some more details to trace it down.

Maxim Maletsky

latest infos:
Our customer said, that this problem still exists with php4.2.3, but we could not reproduce it yesterday (we made stress-tests, killed the Oracle connections via Oracle).

We upgradet to php4.3.0 and the customer will also upgrade their Oracle client from 8.1.7.0 to 8.1.7.4 (at the moment only the Oracle server is running 8.1.7.4).

Now I'm waiting for feedback from the customer.

We have the same problem with 
php4.3.2/Apache/1.3.26 on Linux SUSE 7.2 with Kernel 2.4.4-4GB, Oracle 8.1.7.0 doing a lot of Selects,
we tried to update from 4.2.2 to 4.2.3 to 4.3.2 to solve the problem but it didn't.
 

Errors are mixed between 
Warning: OCISessionBegin: ORA-24327: need explicit attach before authenticating a user 
and
Warning:  Unknown(): _oci_close_session: OCISessionEnd: Error while trying to retrieve text for error ORA-03113

The Problem is not really reproduceable, but apears only after a long runtime of apache, after restarting apache the problem doesnt't appear for a time, then suddenly it appears again.

We're also periodically getting this, running php 4.3.4, oracle 9i enterprise edition release 9.2.0.4.0.

We have a daemon that runs 24/7 written in php, we get the error when the oracle server goes down for backup, and then the php detects the connection is lost, and tries to reconnect, blammo, we get this error.  Any ideas?

The connection code seems to work alright, since if I manually reset the $connection handle to a null string, it reconnects just fine.

Even a work-around would be appreciated, since ocilogoff doesn't seem to actually do anything I CAN'T actually close the oracle connection to attempt a real reconnection.

After looking a bit longer, I may want to be using OCINLogon()  to force a NEW connection to oracle, hopefully this should solve my problem.

I use PHP5 + Apache 1.3.31 + Oracle8.1.17, but this bug not solved still.
restart apache is a good idea!