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


Reason


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

Mount options can be verified as Oracle or root user with the commands below;

$ mount | grep /dev/shm
shmfs on /dev/shm type tmpfs (rw) .... This is the recommended setting.

Login as root to modify the mount options

-- Mount with 'rw' option
# mount -t tmpfs shmfs -o rw /dev/shm

--Verify the change

# mount | grep /dev/shm

Reboot the server.


If you like please follow and comment