Andreas_Sprosec_7439

ORA-00600: internal error code

Discussion created by Andreas_Sprosec_7439 on Feb 22, 2017
Latest reply on Feb 22, 2017 by Andreas_Sprosec_7439

You Asked

Error message U0003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-00600: internal error code, arguments: [kdlwdb:objdchk_kcbnew_3], [0], [22722], [1], [4], [8], [], [], [], [], [], []' occur.

That looks strange to me ...

and we said ...

Definition of an ORA-00600 error from the Oracle documentation:

Error: ORA 00600
Text: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s]

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

Action: Report this error to Oracle Support Services

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.

Solution:

An error handling has been fixed in Automation Engine 11.1.5, 11.2.3 and higher, where ORA-00600 (internal error code) has not been recognized by the automation engine (AE) as database error which led to a forced trace. Now ORA-00600 will be checked and transaction will be repeated after this oracle error.

Workaround:

For Automic Engine (AE) versions lower that versions above check out the section below:

To trigger an exception handling for ORA-00600 you need to modify the file UC.MSL in the Automation Engine folder:

1.       open the file with an editor like notepad++
2.       search for the number 3555
3.       go to line 1318
4.       fill '600' after the number 470
5.       do the same in line 1319 and 1320
6.       save & close the file
7.       restart all CP's / WP's
8.       monitor the system

After this change a process which ORA-00600 will be checked and transaction will be repeated after this oracle error.

 Extract of UC.MSL from our AE test system:

line 1318: 0003555DI8,376,470,600,1012,1013,1033,1034,1041,1089,1460,1461,1502,1536,1632,1654,3114,3113,3130,3135,8001,8102,12154,12571,24324,25402,25405,25408,25425,30036

line 1319: 0003555EI8,376,470,600,1012,1013,1033,1034,1041,1089,1460,1461,1502,1536,1632,1654,3114,3113,3130,3135,8001,8102,12154,12571,24324,25402,25405,25408,25425,30036

line 1320: 0003555FI8,376,470,600,1012,1013,1033,1034,1041,1089,1460,1461,1502,1536,1632,1654,3114,3113,3130,3135,8001,8102,12154,12571,24324,25402,25405,25408,25425,30036

Outcomes