Re: Debug ORA-03113 on Oracle XE

From: Álvaro G. Vicario <>
Date: Tue, 16 Jun 2009 14:30:30 +0200
Message-ID: <h18399$ccl$>

Maxim Demenko escribió:
> Álvaro G. Vicario schrieb:

>> I have a web application written in PHP that's failing on one computer
>> (and only that computer): a laptop that runs the Oracle 10g Express
>> Edition. It fails when it executes a specific SELECT query: I get a
>> "ORA-03113 end-of-file on communication channel" error and the
>> connection drops.
>> My main concern is that I can't figure out what to do next. It seems
>> that ORA-03113 is a very generic error that can happen for lots of
>> reasons.
>> The query returns no rows with the current data set but it's pretty
>> complex (lots of joins and subqueries). However, I only get the
>> ORA-03113 error when I run it through PHP and Apache. When I run it
>> from SQL Developer I get no error and the results come almost
>> instantly. The PHP backtrace doesn't provide additional info. The PHP
>> and Apache versions do not seem to matter. There're neither antivirus
>> nor firewall in the laptop. If Oracle XE generates further info I
>> don't know where I can find it.
> The first place where i would look up - alert.log, 3113 should be 
> recorded there as well as the preceding error ( which is very often an 
> ORA-00600 or ORA-07445, an additional trace file should be generated as 
> well ),

I found "alert_xe.log". It doesn't mention 3113 but there're several lines like:

Errors in file c:\oraclexe\app\oracle\admin\xe\udump\xe_ora_3928.trc: ORA-07445: se ha encontrado una excepción: volcado de memoria [ACCESS_VIOLATION] [_lxptmutf8+30] [PC:0x60AD606E] [ADDR:0xA98FD33] [UNABLE_TO_READ] [] ... and there's a 6 MB dump at "xe_ora_3928.trc". At least now I have something to look at, thank you.

> when you figured out, from which error is the origin of 3113, > next step should be Metalink.

I presume Metalink is only for pay customers, isn't it?

-- - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web:
-- Mi web de humor satinado:
Received on Tue Jun 16 2009 - 07:30:30 CDT

Original text of this message