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

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 Developer Edit

Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.

php.net Username: php.net Password:

Quick Fix:	(description)
	Block user comment
Status:		Assign to:
Package:
Bug Type:
Summary:
From:	mbretter@php.net
New email:
PHP Version:		OS:

New/Additional Comment:

[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

Pull Requests

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.net \| support \| documentation \| report a bug \| advanced search \| search howto \| statistics \| random bug \| login
go to bug id or search bugs for


Copyright © 2001-2025 The PHP Group All rights reserved.	Last updated: Fri May 09 14:01:27 2025 UTC