Hi all,
So this week I started receiving this error in a client environment. This was happening due Bug 26803191 – Getting ORA-00600 [ipc_recreate_que_2] instead of ORA-27515 – superseded (Doc ID 26803191.8)
In summary, failures due to low memlock limit are leading ORA-00600 [ipc_recreate_que_2] instead of ORA-27515, patching ensure that ORA-27515 is raised on failures due to low memlock limit instead of this ORA-600.
As workaround, the memlock limited can be changed, as also described in MOS ORA-00600: Internal Error Code, Arguments: [ipc_recreate_que_2] When Running Exachk (Doc ID 2480088.1).
Before:
[boesing@exa1dbadm01 trace]$ grep memlock /etc/security/limits.conf |grep oracle # - memlock - max locked-in-memory address space (KB) oracle soft memlock 237809520 oracle hard memlock 237809520
After:
[boesing@exa1dbadm01 ~]$ grep memlock /etc/security/limits.conf # - memlock - max locked-in-memory address space (KB) oracle soft memlock unlimited oracle hard memlock unlimited * soft memlock 32768 * hard memlock 32768
Hope it helps,
Cheers!