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

From: <isma.sanchez_at_gmail.com>
Date: Tue, 15 Apr 2008 05:01:45 -0700 (PDT)
Message-ID: <258889dc-c060-4733-9b13-2d4c6c66c8fb@u69g2000hse.googlegroups.com>


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 Received on Tue Apr 15 2008 - 07:01:45 CDT

Original text of this message