Re: DBD::Oracle and ORA-600 [16365] errors

From: Jared Still (jkstill_at_cybcon.com)
Date: 09/25/04


To: Tristan Greaves <tristan.greaves@jobsite.co.uk>
Date: Fri, 24 Sep 2004 19:07:23 -0700

On Tue, 2004-09-14 at 01:47, Tristan Greaves wrote:

> Hi there Tim,
>
> We are using DBD::Oracle as part of our web site here, and are
> experiencing some Oracle crash issues. We are trying to pin down the
> cause and I was wondering if you have had any similar issues raised
> to you.
>
> Here are the details:
>
> Our architecture is the classic...
>
> Apache
> mod_perl
> DBD::Oracle $DBD::Oracle::VERSION = '1.12';
>
> The symptom is that the Oracle database crashes, producing
> ORA-600 [16365] errors.
>
> We have been discussing this issue with Oracle, and the current status
> is that they are blaming "the application":

Ah, yes, much easier to blame the app.

First off, if you need a discussion forum for this, try
joining the oracle-l list at freelists.org, as this is
way off topic for this list.

That said, an ORA-600 error is caused by Oracle, not by apps.

Apps merely uncover a bug. That's what ORA-600 errors are, bugs.

A cursory examination of the Oracle support site indicates
that you are experiencing a problem with MTS.

You have left out some rather important details in your post, such
as the platform, OS version and Oracle version. Be sure to include
them in future requests for help.

Jared



Relevant Pages

  • One node experiencing heavy load(OS) in 2 node RAC
    ... in a 2 node RAC systemexperiencing unexplained heavy loads. ... OS processes and oracle sessions continue. ... be a configuration item I missed. ...
    (comp.databases.oracle.server)
  • RE: Does any one experiencing this problem?
    ... Does any one experiencing this problem? ... orphaned processes are harvested by ... This is the problem for me because I am using PERL as CGI for web ... applications where the script is querying the data from Oracle database. ...
    (perl.dbi.users)
  • Re: Seeking understanding of my "gc cr multi block request" waits
    ... This particular wait event is not well-documented by Oracle, and I have found little information on it on the internet. ... On the other hand, if the "gc cr multi block request" event is not a place holder event, does it indicate the wait time experienced by the instance ... type of slowdown that I am experiencing. ... col "AVG RECVD TIME " format 9999999.9 ...
    (comp.databases.oracle.server)
  • RE: Oracle SQL Comparison
    ... or am I experiencing some kind of rounding condition? ... you seem to be experiencing some kind of non-rounding condition. ... The DATE datatype in Oracle includes date and time. ... When you specify just a ...
    (perl.dbi.users)
  • Re: Create a new OMF tablespace with OEM
    ... you are experiencing the same behavior as I. ... I have not used Oracle before. ... [I am in process of "jumping ship" from ... another RDBMS reality :-)] So, I was not 100% certain I was doing ...
    (comp.databases.oracle.server)