php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #21897 ORA-03113: end-of-file on communication channel
Submitted: 2003-01-27 04:24 UTC Modified: 2003-01-28 11:48 UTC
From: mbretter@php.net Assigned:
Status: Not a bug Package: OCI8 related
PHP Version: 4.2.3 OS: Solaris
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2003-01-27 04:24 UTC] mbretter@php.net 
This error occurs very often but not allways:
FEHLER: Database error: ALTER SESSION SET NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
Oracle8 Error: O (ORA-03113: end-of-file on communication channel )

Session halted.
Warning: failed to rollback outstanding transactions!: ORA-03114: not
connected to ORACLE in Unknown on line 0

it seems that the Oracle connection died, but the oci8 extension doesen't know this. The sql-statement above is the first after OCIPlogon(), changing to OCINLogon() doesen't solved this problem.
We run the same application on other platforms with Oracle without any problems, this problem seems to be Solaris related.

The Oracle Version is 8.1.7.4. Apache 1.3.26.

The problem also occurs with PHP4.1.1

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-01-27 12:37 UTC] michael dot mauch at gmx dot de 
Make sure you set the environment variables mentioned on 
<http://de3.php.net/manual/de/ref.oci8.php> before you start your httpd. _Don't_ set them in PHP with putenv() or in httpd.conf with SetEnv.

If this doesn't help, maybe you can find the cause of the problem by reading <http://www.oracle-error.com/ora-03113.htm>.
 [2003-01-27 14:36 UTC] maxim@php.net 
Sorry, but your problem does not imply a bug in PHP itself.  For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system is not the
appropriate forum for asking support questions. 

Thank you for your interest in PHP.



Actually, I think Michael's is the most probable answer.

Check out these places:

http://dbforums.com/t584473.html
http://dbforums.com/showthread.php?threadid=496655
http://home.clara.net/dwotton/dba/ora3113.htm
http://www.google.com/search?q=Ora-03113+solaris&hl=en&lr=&ie=UTF-8&oe=utf-8&start=20&sa=N

As you can see, this randomly hapens for various *nix installations and the most tipical case is the misconfiguration of the Oracle enviroment. As was also mentioned "Oracle's way to say you misconfigured him". Thus, I doubt this is really php's oci8 extension that causes it.

Try also using SQL*Plus and see whether you get it. I'd be worried if this only happens connecting to Oracle thought PHP. If so, then please post us the full PHP code and/or anything you might have discovered.

Maxim Maletsky
 [2003-01-27 14:49 UTC] maxim@php.net 
One more thing, the bug #1539 looks like a similar problem:

http://bugs.php.net/bug.php?id=15390

If you consider it relevant, please comment under that bug instead of duplicating it at this point.

Maxim Maletsky
 [2003-01-28 05:00 UTC] mbretter@php.net 
Also this error occurs sometimes:
Warning:  OCISessionBegin: ORA-24327: need explicit attach before authenticating a user
 in /htdocs/e-academy.eui.at/www/oci8test.php on line 4
Error: 24327
Error: ORA-24327: need explicit attach before authenticating a user

currently I'm sitting here at the customer and try to track down the problem. Any quick tips would be great.

There are other webs running on this system using java without problems. Maybe there are problems running php + tomcat on the same apache at the same time?!
 [2003-01-28 05:07 UTC] mbretter@php.net 
ok. http://bugs.php.net/bug.php?id=13053&edit=1 seems to be the same problem.

I close this bug and put my comments there.
 [2003-01-28 05:34 UTC] sniper@php.net 
Thanks.
 [2003-01-28 11:48 UTC] maxim@php.net 
This moves to bug #13053
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sun May 19 15:01:31 2024 UTC