EM Grid 10g or 11g, Install or Upgrade Fails due to ORA-12853: insufficient memory for PX buffers policy_indexes.sql

(Doc ID 1174093.1)

Last updated on JANUARY 13, 2018

Applies to:

Enterprise Manager Base Platform - Version to [Release 10.2]
Enterprise Manager Base Platform - Version to [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

Note: This problem will usually cause the database instance to consume all memory and CPU resources on the host, which requires a reboot of the physical server itself.


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