• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1260
  • Last Modified:

ORA-00600: internal error code, arguments: [25015], [17], [18], [18], [], [], [], []

Hi,

In my production database server (Oracle 9.2.0), the alert log is being continously appended. The database is working fine, no problem. Extract of the error is as follows...

Mon May 22 16:45:01 2006
Thread 1 advanced to log sequence 697
  Current log# 5 seq# 697 mem# 0: /usr/local/ora9/oradata/fin93jrt/redo05.log
Mon May 22 16:45:25 2006
Errors in file /usr/local/ora9/oradata/fin93jrt/bdump/fin93jrt_smon_18692.trc:
ORA-00600: internal error code, arguments: [25015], [17], [18], [18], [], [], [], []
Mon May 22 16:45:27 2006
Errors in file /usr/local/ora9/oradata/fin93jrt/bdump/fin93jrt_smon_18692.trc:
ORA-00600: internal error code, arguments: [kccocx_01], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [25015], [17], [18], [18], [], [], [], []
Mon May 22 16:45:28 2006
Errors in file /usr/local/ora9/oradata/fin93jrt/bdump/fin93jrt_smon_18692.trc:
ORA-00600: internal error code, arguments: [kccocx_01], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [25015], [17], [18], [18], [], [], [], []
Mon May 22 16:45:28 2006
ORACLE Instance fin93jrt (pid = 6) - Error 600 encountered while recovering transaction (9, 3).
Mon May 22 16:45:28 2006
Errors in file /usr/local/ora9/oradata/fin93jrt/bdump/fin93jrt_smon_18692.trc:
ORA-00600: internal error code, arguments: [25015], [17], [18], [18], [], [], [], []
Mon May 22 16:50:36 2006
Errors in file /usr/local/ora9/oradata/fin93jrt/bdump/fin93jrt_smon_18692.trc:
ORA-00600: internal error code, arguments: [25015], [17], [18], [18], [], [], [], []
Mon May 22 16:50:38 2006
Errors in file /usr/local/ora9/oradata/fin93jrt/bdump/fin93jrt_smon_18692.trc:
ORA-00600: internal error code, arguments: [kccocx_01], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [25015], [17], [18], [18], [], [], [], []
Mon May 22 16:50:39 2006
Errors in file /usr/local/ora9/oradata/fin93jrt/bdump/fin93jrt_smon_18692.trc:
ORA-00600: internal error code, arguments: [kccocx_01], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [25015], [17], [18], [18], [], [], [], []
ORACLE Instance fin93jrt (pid = 6) - Error 600 encountered while recovering transaction (9, 3).
Mon May 22 16:50:39 2006
Errors in file /usr/local/ora9/oradata/fin93jrt/bdump/fin93jrt_smon_18692.trc:
ORA-00600: internal error code, arguments: [25015], [17], [18], [18], [], [], [], []

How can I stop the alert...? What should I do to prevent any future problem ?

Kindly suggest.

Thanks and Regards,
bbasumatary
0
bbasumatary
Asked:
bbasumatary
  • 2
1 Solution
 
JacekMychaCommented:
Very bad... Datafile corruption.
Check http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=93665.1

File number needing media recovery = [17]

Buy Oracle Support if you don't have it yet.

JacekMycha
0
 
paquicubaCommented:
I don't think there is much someone here can do to help you with these errors

ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]

Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include:

timeouts

file corruption

failed data checks in memory

hardware, memory, or I/O errors

incorrectly restored files

The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle.

Action: Report this error to Oracle Customer Support after gathering the following information:

events that led up to the error

the operations that were attempted that led to the error

the conditions of the operating system and databases at the time of the error

any unusual circumstances that occurred before receiving the ORA-00600 message

contents of any trace files generated by the error

the relevant portions of the Alter files

Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.

=============================

As suggested, contact Oracle Support.

0
 
bbasumataryAuthor Commented:
JacekMycha ,

Thanks..lets hope this solves my problem. But I am not able to view the metalink documents. How to by support?

Regards,
bbasumatary
0
 
bbasumataryAuthor Commented:
JacekMycha,

The exact oracle metalink Doc ID is ....

https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=1059139.6

Thanks a lot..

Regards,
bbasumatary
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now