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

On 15 Apr, 14:37, "isma.sanc...@xxxxxxxxx" <isma.sanc...@xxxxxxxxx>
wrote:
On Apr 15, 2:12 pm, gazzag <gar...@xxxxxxxxx> wrote:





On 15 Apr, 13:01, "isma.sanc...@xxxxxxxxx" <isma.sanc...@xxxxxxxxx>
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?
.

Relevant Pages

  • ORA-00600: [25027], [27] in ALERT.LOG
    ... We have discovered in the alert.log some ora-00600 in our Oracle ... Database 10g on Windows 2003 Server. ... but the error is generating a big amount of dump files. ... collection job is not running properly. ...
    (comp.databases.oracle.server)
  • Re: ORA-00600: [25027], [27] in ALERT.LOG
    ... We have discovered in the alert.log some ora-00600 in our Oracle ... Database 10g on Windows 2003 Server. ... collection job is not running properly. ... couldn't find useful information. ...
    (comp.databases.oracle.server)
  • Re: ORA-00600: [25027], [27] in ALERT.LOG
    ... We have discovered in the alert.log some ora-00600 in our Oracle ... Database 10g on Windows 2003 Server. ... but the error is generating a big amount of dump files. ... collection job is not running properly. ...
    (comp.databases.oracle.server)
  • Re: using Access as a front end to Oracle Clinical
    ... I found very useful information from Access 2002 Enterprise Developer's ... structure will not be the same in the database your company is acquiring. ... Thanks for the feedback. ... What are anybody's favorite/most useful resources for that? ...
    (microsoft.public.access.externaldata)
  • Re: ORA-00600: [25027], [27] in ALERT.LOG
    ... Database 10g on Windows 2003 Server. ... but the error is generating a big amount of dump files. ... But seeing as you already have a service request open ... ... Its provided as part of the Critical Patch Update for April 2008. ...
    (comp.databases.oracle.server)