ORA-04031: "unable to allocate xxxx bytes of shared memory" During Upgrade to 10gR2, 11gR1, 11gR2
(Doc ID 376612.1)
Last updated on JUNE 30, 2023
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.
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 |