ORA-04031 unable to allocate 4080 bytes of shared memory

1739 Views

Hi Everyone,

The error ORA-04031 has been consistently occuring in our production landscape.

We have Applied Oracle patches in BI7.0 (2004s - Oracle 10.2.0.2) system as per SAP's suggestions. (A set of 35 patches as per note 871096)

(Patches List - 5369855,5253307,6340979,5618049,7133360,5895190,6826661,4704890,6005996,5188321,6447320,3748430,5442919,4952782,5458753,5941030,5345999,6153847,5530958,4883635,5636728,4668719,5635254,5063279,7237154,5103126,4638550,4770693,4864648,6046043,7608184,6729801,5363584,6771608,6435823)

Applying oracle patches has not resolved this issue. The error is reoccuring. Now as per notes 1171650 and 830576 we have tuned in certain parameters.

We also checked the Notes 869006 and 1120481 but nothing much is helpful.

A Go-Live is scheduled this week. Could you please suggest what further actions need to be taken to identify the issue and resolve it.

Thanks in advance.

Best Regards

Bhupesh