ORA-600 [pmuocon2#1: Invalid Magic Num] Seen After Upgrade To 12C (Doc ID 2077136.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

The following symptoms have been attributed to this issue:

a) The RDBMS is >=12.1

b) The following error is seen in the alert log:

ORA-00600: internal error code, arguments: [pmuocon2#1: invalid magic num]


c)  The incident context dump will be similar to:

----- Incident Context Dump -----
Address: 0x000000002B1B3548
Incident ID: 181526
Problem Key: ORA 600 [pmuocon2#1: invalid magic num]
Error: ORA-600 [pmuocon2#1: invalid magic num] [] [] [] [] [] [] [] [] [] [] []
[00]: dbgexProcessError [diag_dde]
[01]: dbgeExecuteForError [diag_dde]
[02]: dbgePostErrorKGE [diag_dde]
[03]: dbkePostKGE_kgsf [rdbms_dde]
[04]: kgeadse []
[05]: kgerinv_internal []
[06]: kgerinv []
[07]: kgeasnmierr []
[08]: pmuocon2_con_recur []<-- Signaling
[09]: pmuocon []
[10]: kkxmsagif [PROGINT_PLSQL]
[11]: evapls []
[12]: evaopn2 []
[13]: qximeop_fbk []
[14]: qximeop []
[15]: qxuag_initself []
[16]: qxuageag []
[17]: qergsFetch [SQL_Execution]
[18]: rwsfcd []
[19]: qerltFetch [SQL_Execution]
[20]: insdlexe [DML]
[21]: insExecStmtExecIniEngine [DML]
[22]: insexe [DML]
[23]: opiexe [Time_Limit]
[24]: kpoal8 [PROGINT_MISC]
[25]: opiodr [OPI]
[26]: ttcpip []
[27]: opitsk [OPI]
[28]: opiino [OPI]
[29]: opiodr [OPI]
[30]: opidrv [OPI]
[31]: sou2o []
[32]: opimai_real [OPI]
[33]: opimai [OPI]
[34]: OracleThreadStart []

 
d) The failing SQL has been seen to vary and tends to be a complex SQL statement that uses 'User Defined Aggregate Functions' (UDAG).  The problem is intermittent and seems to be non-reproducible in a controlled manner

 

Changes

The issue is noticed after upgrade from earlier RDBMS release to a 12C release.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms