ORA-12853: insufficient memory for PX buffers

[former_member285951]

SQL> STARTUP NOMOUNT

ORA-12853: insufficient memory for PX buffers: current 0K, max needed 2640K

ORA-04031: unable to allocate 21544 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")

Database would not go to any state.

Please assist.

Thankyou.

[Former Member]

I got the issue when I try to startup the Oracle.

The solution:

1. SQL>startup pfile='XX\init<SID>.ora';

2. SQL>create spfile from pfile

3. SQL> shutdown immediate

4. SQL> startup

OK.

[Former Member]

Above is correct. After you make changes to initXXX.ora file you need to follow steps for specifying profile file and create default profile.

[former_member285951]

this was a issue which happened after a oracle upgrade. i restarted it and now its working fine

regards

vinodh

[former_member204746]

increase shared_pool_size to at least 400M as per SAP note 830576.

[rsil_team]

Hi,

Kindly Check sga_max_size &shared_pool_size.

Increase sga_max_size atleast 256.

Thnx

SurendraJain

[sunny_pahuja2]

Hi,

Please see below link:

http://ora-12853.ora-code.com/

Also from SAP Note 869006 - Composite SAP note: ORA-04031

Thanks

Sunny

[markus_doehr2]

> SQL> STARTUP NOMOUNT

> ORA-12853: insufficient memory for PX buffers: current 0K, max needed 2640K

> ORA-04031: unable to allocate 21544 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")

Check your OS configuration (ulimit/limit)

Markus