search

fuzziebrain / docker-apex-stack

Utility scripts for creating an Oracle Application Express stack as a Docker container.
MIT License
97 stars 34 forks source link

Unable to perform PL/SQL native compilation #7

Closed fuzziebrain closed 4 years ago

fuzziebrain commented 5 years ago

When compiling PL/SQL code natively, the following error occurs:

Error starting at line : 3 File @ /path/to/aop/v19.1.4/db/aop_db_native_compile_pkg.sql
In command -
ALTER PACKAGE aop_api19_pkg COMPILE
Error report -
ORA-00600: internal error code, arguments: [pesldl03_MMap: errno 1 errmsg Operation not permitted
], [], [], [], [], [], [], [], [], [], [], []
00600. 00000 -  "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
*Cause:    This is the generic internal error number for Oracle program
           exceptions. It indicates that a process has encountered a low-level,
           unexpected condition. The first argument is the internal message
           number. This argument and the database version number are critical in
           identifying the root cause and the potential impact to your system.

Error starting at line : 4 File @ /path/to/aop/v19.1.4/db/aop_db_native_compile_pkg.sql
In command -
ALTER PACKAGE aop_plsql19_pkg COMPILE
Error report -
Closed Connection

Issue appears to be related to the one reported in MOS Doc ID 1625010.1.

The solution proposed here to use Docker run option --tmpfs to mount /dev/shm seems to work.

fuzziebrain commented 5 years ago

Adding --tmpfs /dev/shm:rw,exec,size=2G to the Docker run command allows native compilation to be performed successfully.