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
Reboot the server.
If you like please follow and comment
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
Post a Comment
Post a Comment