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.


Solution:


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"




# cat /etc/fstab
...
tmpfs /dev/shm tmpfs defaults 0 0
...



Old setting in /etc/fstab 


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


New setting which fixed the issue 





tmpfs /dev/shm tmpfs defaults 0 0



No comments:

Post a Comment