Re: Debug ORA-03113 on Oracle XE
From: CarlosAL <miotromailcarlos_at_netscape.net>
Date: Tue, 16 Jun 2009 07:41:51 -0700 (PDT)
Message-ID: <45e0e337-c32b-42d9-a416-fa9bd9c6da1b_at_d38g2000prn.googlegroups.com>
On 16 jun, 15:00, Maxim Demenko <mdeme..._at_gmail.com> wrote:
> Álvaro G. Vicario schrieb:
>
>
>
> > 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?
>
> Sorry, have overlooked you are on XE.
> In that case you can not get any support from Oracle ( you'll have to
> upgrade your Oracle version - in that case your error may be not
> reproducible at all). You can though try to ask on the OTN Oracle XE
> forum, maybe somebody already experienced similar error and has a
> workaround.
>
> Best regards
>
> Maxim
>
> --
> Why make things difficult, when it is possible to make them cryptic
> and totally illogical, with just a little bit more effort?
>
> Aksel Peter Jørgensen
Date: Tue, 16 Jun 2009 07:41:51 -0700 (PDT)
Message-ID: <45e0e337-c32b-42d9-a416-fa9bd9c6da1b_at_d38g2000prn.googlegroups.com>
On 16 jun, 15:00, Maxim Demenko <mdeme..._at_gmail.com> wrote:
> Álvaro G. Vicario schrieb:
>
>
>
> > 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?
>
> Sorry, have overlooked you are on XE.
> In that case you can not get any support from Oracle ( you'll have to
> upgrade your Oracle version - in that case your error may be not
> reproducible at all). You can though try to ask on the OTN Oracle XE
> forum, maybe somebody already experienced similar error and has a
> workaround.
>
> Best regards
>
> Maxim
>
> --
> Why make things difficult, when it is possible to make them cryptic
> and totally illogical, with just a little bit more effort?
>
> Aksel Peter Jørgensen
Álvaro:
Revisa tu 'shared pool'.
¿Tienes cursor_sharing=force?
HTH. Saludos.
Carlos. Received on Tue Jun 16 2009 - 09:41:51 CDT