Upgrade Failed due to ORA-04031 ("shared pool","select host,userid,password,...") (Doc ID 2147963.1)

Last updated on JUNE 14, 2022

Applies to:

Purpose

Database upgrade failed due to below error.

Alert log:

Wed Jun 08 20:40:31 2016

Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file <$ORACLE_BASE>/diag/rdbms/<sid>/<DBNAME>/trace/<DBNAME>_reco_<PROCESS_ID>.trc (incident=<INCIDENT_ID>):
ORA-04031: unable to allocate 40 bytes of shared memory ("shared pool","select host,userid,password,...","KGLH0^ea4fb95d","kglHeapInitialize:temp")

Catupgrd.log

*** WARNING: ERRORS FOUND DURING UPGRADE ***

Due to errors found during the upgrade process, the post
upgrade actions in catuppst.sql have not been automatically run.

*** THEREFORE THE DATABASE UPGRADE IS NOT YET COMPLETE ***

1. Evaluate the errors found in the upgrade logs
and determine the proper action.
2. Execute the post upgrade script as described in Chapter 3
of the Database Upgrade Guide.

REASON:
catuppst.sql unable to run in Database: VOEZL01 Id: 0
ERRORS FOUND: during upgrade CATCTL ERROR COUNT=2
------------------------------------------------------
Identifier CATALOG 16-06-08 09:55:05 Script = c1102000.sql
ERROR = [ORA-06512: at line 57]
STATEMENT = [as above]
------------------------------------------------------
------------------------------------------------------
Identifier CATALOG 16-06-08 09:55:05 Script = c1102000.sql
ERROR = [ORA-00942: table or view does not exist ORA-06512: at line 57
]
STATEMENT = [declare
type numtab is table of number;
tobjns numtab := numtab();
tobjn number;
cnt number := 0;
before11202 boolean := FALSE;
-- whether upgrade from a verion prior to (not including) 11202
create_new_head boolean := FALSE;
create_new_synop boolean := FALSE;
create_synop varchar2(32767) :=
'create table wri$_optstat_synopsis$ <<<<<<<<<<<<<<<<<<<<<<<<
( bo# number not null,
group# number not null,
intcol# number not null,
hashvalue number not null
)

Troubleshooting Steps

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