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

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


.

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
    ... Database 10g on Windows 2003 Server. ... but the error is generating a big amount of dump files. ... 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: What so special about PostgreSQL and other RDBMS?
    ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
    (comp.lang.php)
  • A cool DBA job wanted
    ... 7, Oracle 6, Sybase, SQL Server ... Proposed proactive database monitoring through ... strategies to administer remote Oracle databases ... Trained installation and support personnel in basic ...
    (comp.databases.oracle.server)