EBS 12.2.0 Rapid Install of Database Fails During RMAN Restore Of VIS With ORA-04031 Error. (Doc ID 2002890.1)

Last updated on AUGUST 24, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Applications Manager - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

During Rapid Install installing EBS 12.2.0 the RMAN restore phase of VIS database fails with following errors

RMAN> #
2> # $Header: restore-rac1.rman 120.3 2013/03/15 16:39:14 rledezma noship $
3> #
4> # This SQL script was used in EBS 12.1 Rapid Clone to restore a backup
5> # control file.  As RI evolved to use RMAN to restore a backup database
6> # in the staging area, we are using it in RI with a few modifications.
7> #
8> startup nomount pfile=/u301/app/oracle/VIS/11.2.0/dbs/RMANinit.ora
9> restore controlfile from '/u301/oracle/R12.2_SOLARIS/EBSInstallMedia/AppDB/VISION/backup_controlfile.ctl';
10> alter database mount;
11> exit
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 04/10/2015 14:35:32
RMAN-04014: startup failed: ORA-04031: unable to allocate 262208 bytes of shared memory ("shared pool","unknown object","sga heap(2,0)","Checkpoint queue")

 

The ORA-4031 stack trace may show similar to the following:

----- Call Stack Trace -----
ksedst1 <- ksedst <- dbkedDefDump <- dbgexPhaseII <- dbgexProcessError <- dbgePostErrorKGE <- dbkePostKGE_kgsf <- kgeade <- kgesev <- kgesec5 <- kghnospc <- kghalp <- ksmnsi <- kcbw_setup <- kcbnfy <- kscnfy <- ksmcsg <- opistr_real <- opistr <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main <- start

 

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