ORA-04031: "unable to allocate xxxx bytes of shared memory" During Upgrade to 10gR2, 11gR1, 11gR2 (Doc ID 376612.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database Upgrade Assistant - Version 10.2.0.1 to 11.2.0.0 [Release 10.2 to 11.2]
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 03-Aug-2015***

Symptoms

During database upgrade to 10gR2 , 11gR1 or 11gR2, the upgrade log file contains errors like the following:

create or replace package body dbms_stats_internal wrapped
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 3
ORA-04031: unable to allocate 88 bytes of shared memory ("shared pool","select
name,intcol#,segcol#,...","sql area","opn: qkexrInitOpn")

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY DBMS_STATS:

0/0 ORA-04031: unable to allocate 4128 bytes of shared memory
("shared pool","unknown object","PL/SQL MPCODE","BAMIMA: Bam
Buffer")

create or replace view v_$backup_archivelog_summary as select * from v$backup_archivelog_summary
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 3112 bytes of shared memory ("shared
pool","select a.*, case when ...","Typecheck","seg:kggfaAllocSeg")

grant select on ku$_phtable_view to public
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 56 bytes of shared memory ("shared pool","select
name,intcol#,segcol#,...","sql area","idndef*[]: qkexrPackName")

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 56 bytes of shared memory ("shared pool","select ....
.
.

 

Cause

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