My Oracle Support Banner

APEX Installation Errors ORA-20001 ORA-12801 ORA-12853 ORA-04031 (Doc ID 2384759.1)

Last updated on FEBRUARY 18, 2021

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Installed APEX and the following errors are logged in the install log:


Performing Application Express component validation - please wait...

Completing registration process. 15:04:29
Validating installation. 15:04:29
...(15:04:29) Starting validate_apex for APEX_050100
...(15:04:32) Checking missing sys privileges
...(15:04:32) Recompiling APEX_050100
ORA-20001: Error in validate_apex: ORA-12801: error signaled in parallel query
server P024, instance <>:<> (1)
ORA-12853:
insufficient memory for PX buffers: current 1022752K, max needed
11337360K
ORA-04031: unable to allocate 65560 bytes of shared memory ("large
pool","unknown object","large pool","PX msg pool")
ORA-06512: at "SYS.UTL_RECOMP", line 865
ORA-06512: at "SYS.VALIDATE_APEX", line
271

...

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.