ORA-00600: internal error code, arguments: [pesldl03_MMap: errno 1 errmsg Operation not permitted

Issue:

ORA-39014: One or more workers have prematurely exited.

ORA-39029: worker 1 with process name "DW00" prematurely terminated

ORA-31671: Worker process DW00 had an unhandled exception.

ORA-00600: internal error code, arguments: [pesldl03_MMap: errno 1 errmsg Operation not permitted

], [], [], [], [], [], [], [], [], [], [], []

ORA-39014: One or more workers have prematurely exited.

ORA-39029: worker 2 with process name "DW00" prematurely terminated

ORA-31671: Worker process DW00 had an unhandled exception.

ORA-00600: internal error code, arguments: [pesldl03_MMap: errno 1 errmsg Operation not permitted

Cause:-

The issue occurs since 11g as we are now using /dev/shm when using native PLSQL compilation.

This requires that /dev/shm is of type tmpfs and is mounted with the following options:

• With rw and exec permissions set on it
• Without noexec or nosuid set on it

If /dev/shm is mounted with "noexec" such an error occurs.

This was addressed in
Bug 18076018 - ORA-600 [PESLDL03_MMAP: ERRNO 1 ERRMSG OPERATION NOT PERMITTED]
closed as "Not a Bug" with reference to the documentation which clearly states that /dev/shm may not be mounted with "noexec" option.

Solution:- 

Make sure that DB should have enough SGA value

Ensure that the /dev/shm mount area is of type tmpfs and is mounted with the following options:

• With rw and exec permissions set on it
• Without noexec or nosuid set on it

 Old setting in OS for Server1/ server2

tmpfs   /dev/shm   tmpfs   defaults,nodev,nosuid,noexec   0 0

 New setting in OS for Server1/ server2

tmpfs     /dev/shm    tmpfs   defaults  0 0