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 25, 2017

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
***Checked for relevance on 23-may-2012***
Checked for relevance on 28-Oct-2013


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