My Oracle Support Banner

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

Last updated on DECEMBER 27, 2020

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]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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 ....
.
.

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.