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

From: gazzag <gareth_at_jamms.org>
Date: Tue, 15 Apr 2008 07:02:54 -0700 (PDT)
Message-ID: <3487d45a-936a-4b57-a45e-89cb5a8a9953@k1g2000prb.googlegroups.com>


On 15 Apr, 14:37, "isma.sanc..._at_gmail.com" <isma.sanc..._at_gmail.com> wrote:
> On Apr 15, 2:12 pm, gazzag <gar..._at_jamms.org> wrote:
>
>
>
>
>
> > On 15 Apr, 13:01, "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
>
> > ORA-600 errors = Open a SR with Oracle.
>
> > HTH
>
> > -g
>
> yes, I know. The SR was opened 5 days ago and we have no answer (Work
> In Progress ...) so any help would be appreciated.
>
> Ismael- Hide quoted text -
>
> - Show quoted text -

Escalate? Is it a production system? Received on Tue Apr 15 2008 - 09:02:54 CDT

Original text of this message