Re: ORA-00600: [25027], [27] in ALERT.LOG

From: <isma.sanchez_at_gmail.com>
Date: Wed, 16 Apr 2008 02:32:31 -0700 (PDT)
Message-ID: <2ceaa200-0006-47f0-9b76-29f013eb3b22@t54g2000hsg.googlegroups.com>


On Apr 15, 4:21 pm, bdbafh <bdb..._at_gmail.com> wrote:
> On Apr 15, 8:01 am, "isma.sanc..._at_gmail.com" <isma.sanc..._at_gmail.com>
> wrote:
>
>
>
> > Hi,
> > We have discovered in the alert.log some ora-00600 in our Oracle
> > Database 10g (10.2.0.3.0) on Windows 2003 Server. The database is
> > running, but the error is generating a big amount of dump files.
> > In the dump files, we found the following information:
>
> > *** SERVICE NAME:(SYS$USERS) 2008-04-10 13:31:19.527
> > *** SESSION ID:(294.450) 2008-04-10 13:31:19.527
> > *** 2008-04-10 13:31:19.527
> > ksedmp: internal or fatal error
> > ORA-00600: internal error code, arguments: [25027], [27], [0], [], [],
> > [], [], []
> > Current SQL statement for this session:
> > SELECT STRING_VALUE FROM MGMT_CURRENT_METRICS WHERE TARGET_GUID = :B3
> > AND METRIC_GUID = :B2 AND KEY_VALUE = :B1
>
> > We have also found that Oracle defined automatic optimizer statistics
> > collection job (GATHER_STATS_JOB) is not running properly.
> > In the operation details, the job appears as STOPPED
> > REASON="Job slave process was terminated"
>
> > I don't know if there's any relation with the ORA-600 Error. But I
> > don't know how to solve it.
>
> > I've looked for information about this error in metalink but I
> > couldn't find useful information.
>
> > do you know how to solve it?
> > Thank you for your help in advance.
> > Ismael
>
> There should have been a trace file generated (in bdump) by the
> dbms_stats scheduled job failure.
> There are several errors with the package dbms_stats in 10.2.0.3 on MS
> Win 32, 2 of which I have seen directly.
>
> If you manually gather statistics on this table as a foreground
> process using dbms_stats.gather_table_stats, what errors occur?
>
> Are you ready to deploy the 10.2.0.4 patchset?
> There are fixes for dbms_stats in there (check the release notes) that
> might or might not apply to your issue.
>
> good luck.
>
> -bdbafh

When I manually gather statistics:

   dbms_stats.gather_table_stats(ownname => 'SYSMAN', tabname => 'MGMT_CURRENT_METRICS');
I get :
ORA-03113: end-of-file on communication channel and a new ora-00600 in the alert.log. :-( Received on Wed Apr 16 2008 - 04:32:31 CDT

Original text of this message