EM Grid 10g or 11g, Install or Upgrade Fails due to ORA-12853: insufficient memory for PX buffers policy_indexes.sql
Last updated on JANUARY 13, 2018
Applies to:Enterprise Manager Base Platform - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Enterprise Manager Base Platform - Version 18.104.22.168 to 22.214.171.124 [Release 11.1]
Oracle CADView-3D - Version 12.0.1 to 12.0.1 [Release 12]
Information in this document applies to any platform.
This problem can affect EM Grid Control installations on either 10GR2 or 11G platforms
The installation or upgrade of Enterprise Manager fails during Repository Creation.
Repository Creation is where the schema is defined on the back-end database.
The error is printed into two installation logs:
These are located in the directory:
The error text will appear to look something like this:
2010-07-27 14:13:41,908 [Thread-177] ERROR emschema.15y8b1pxt30zg - ERROR:ORA-12801: error signaled in parallel query server P138
ORA-12853: insufficient memory for PX buffers: current 682976K, max needed 2834304K
ORA-04031: unable to allocate 65560 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")
ORA-06512: at line 10
The action which triggers this issue is an install or upgrade of Enterprise Manager.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms