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

Posted on December 28, 2007 by pandazen

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. This indicates that a process has encountered an exceptional condition.
Action: Report as a bug – the first argument is the internal error number

—————————————————————————

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 Support Services 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.
—————————————————————————

If you have receive this error, you could try to :

– analyze table,

analyze table mhs_suppliers delete statistics;

– rebuild table
If anybody have other solution, please leave a comment. ^_^

Filed under: Oracle | Tagged: |

« »

9 Responses

  1. Niramit Soonthawong, on April 9, 2008 at 4:48 am said:

    thank you for you information

    Reply
  2. Niramit Soonthawong, on April 9, 2008 at 4:50 am said:

    could you posibly please tell me how to do the analyze table, delete statistics and rebuild table
    things.

    Reply
  3. pandazen, on April 21, 2008 at 1:24 am said:

    to analyze table,
    analyze table delete statistics;

    to rebuild table
    1. alter table to ;

    2. –recreate table using create table script, as an
    –example
    create table
    (
    column1 varchar2(3byte) not null,
    column2 number,
    column3 date,
    )
    tablespace ;

    3. insert /*+ append */ into
    select * from ;

    4. commit;

    5. –you can recreate indexex, constraints, grants

    Reply
  4. Niramit Soonthawong, on May 6, 2008 at 3:52 am said:

    thank you very much

    Reply
  5. amit pal, on June 26, 2008 at 2:27 pm said:

    Its realy very good information for me and may be for all dba guy

    Reply
  6. Vijay, on September 18, 2008 at 3:49 am said:

    Excellent ideas. The idea of analyzing the table and rebuilding indexes worked for us.

    Thanks again

    Reply
  7. Shaheen, on March 17, 2009 at 11:34 am said:

    Rebuilded the table and the index and it worked.

    Thanks a lot.

    Reply
  8. Lakis, on October 30, 2012 at 1:13 pm said:

    Thanks man. The analyze table made the trick!!!!

    Reply
  9. Sugeng Rahayu Widodo, on July 16, 2013 at 9:20 am said:

    if I have error like this :

    it:8889/reports/rwservlet/showjobid148?server=rep_jne

    and if the Job Status is Cross

    klik the link >> it’s will show

    Terminated with error: REP-300: internal error code, arguments: [19004], [], [], [], [], [], [], [] ==> CMS_CNOTE,

    so the solution is only :

    analyze table cms_cnote delete statistics;

    Thank you Pandazen…….. 🙂

    Reply

Leave a comment