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


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. ^_^

Advertisements

9 Responses

  1. thank you for you information

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

  3. 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

  4. thank you very much

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

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

    Thanks again

  7. Rebuilded the table and the index and it worked.

    Thanks a lot.

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

  9. 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…….. 🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: