I hit this error while running the catupgrd.sql script during 10gR2 32 bit to 10G 64 bit on Windows Operating System.

I was moving my 10.2.0.2 database from windows 2003-32 bit to windows2008-64 bit. As a mention, My source DB version is 10.2.0.2 and my target server database version is 10.2.0.4 which is certified with the win2008-64 bit.

The exact error is:

ERROR at line 1:
ORA-04031: unable to allocate 976 bytes of shared memory (“shared
pool”,”MGMT_JOB_ENGINESYSMAN”,”sga heap(1,1)”,”library cache”)
ORA-06508: PL/SQL: could not find program unit being called:
“SYSMAN.MGMT_JOB_ENGINE”
ORA-06512: at line 11

This issue describes in below Metalink note:

OERR: ORA 4031 “unable to allocate %s bytes of shared memory (“%s”,”%s”,”%s”)” [ID 19837.1]

The issue is related to  NOTE:2167326.8 – Bug 2167326 – ORA-4031 possible during patch set upgrade scripts. By the following note, an issue  has been solved

Advertisements