ID: 13053
Comment by: gid at gifpaste dot net
Reported By: jsun at basefarm dot no
Status: Bogus
Bug Type: OCI8 related
Operating System: sun solaris 64 bits
PHP Version: 4.0.6
New Comment:

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.


Previous Comments:
------------------------------------------------------------------------

[2003-07-03 04:13:51] mmi at uhb-consulting dot de

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.

------------------------------------------------------------------------

[2003-01-29 02:13:04] [email]mbretterphp.net[/email]

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.

------------------------------------------------------------------------

[2003-01-28 11:48:17] [email]maximphp.net[/email]

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

------------------------------------------------------------------------

[2002-12-02 09:48:10] ccourtoi at istar dot fr

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)

------------------------------------------------------------------------

[2002-11-26 10:37:00] [email]maximphp.net[/email]

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

------------------------------------------------------------------------

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
[url]http://bugs.php.net/13053[/url]

--
Edit this bug report at [url]http://bugs.php.net/?id=13053&edit=1[/url]