My Oracle Support Banner

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

Last updated on JUNE 27, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

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 /export/oracle/diag/rdbms/voezl01/VOEZL01/trace/VOEZL01_reco_29953.trc (incident=76161):
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

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
Purpose
Troubleshooting Steps
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.