ORA-00600 error

[roukie_dba]

Dear esteemed members:

We have occassionally obtained this internal error:
$ type rpttable.bad 04-JUN-2001 14:58 ORA-00600: internal error code, arguments: [15851], [8], [8], [1], [2], [], [], [] Error with sale order number xxxxxxx
ORA-00600: internal error code, arguments: [15851], [8], [8], [1], [2], [], [], [] Error with sale order number xxxxxx

ANY IDEAS ON HOW TO RESOLVE THIS would be great!
Many thanks,

[sambavan]

Check the trace file that would have got generated under $ORACLE_BASE/admin/SID/bdump or udump for more information on the sqltext causing that error.

Sam

[wburke]

Hi, - I found the below information (below) in the Oracle Documentation for your error. Thanks, Wally

Oracle's extensive self-checking helps detect internal errors. Oracle uses the following catchall message for Oracle internal exceptions:

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


An actual message might appear as follows:

ORA-00600: internal error code, arguments: [1042], [3],[upilam], [], [],[]


Notice that the message text is followed by up to six arguments, which indicate the origin and attributes of the error. The first argument is the internal error number. Other arguments are various numbers, names, and character strings. Empty brackets may be ignored.

In addition to being returned to the user, internal errors are also written to the Alert file along with additional information about the event causing the message. The Alert file also lists any trace files that may have been generated because of an internal error. See the following sections for descriptions of the trace and alert files.

If you receive an ORA-00600 message, report it to Oracle Customer Support.

[roukie_dba]

Thanks to both members who kindly responded to my previous message, big help.