ORA-56922: Starting a prepare window failed 2 node RAC Multitenant - CDB/PDB - Upgrading DST using scripts utltz_upg_check.sql (Doc ID 2977512.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

On : 19.10.0.0.0 version, RDBMS

@utltz_upg_check.sql

Session altered.

INFO: Starting with RDBMS DST update preparation.
INFO: NO actual RDBMS DST update will be done by this script.
INFO: If an ERROR occurs the script will EXIT sqlplus.
INFO: Doing checks for known issues ...
INFO: Database version is 19.0.0.0 .
INFO: This database is a Multitenant database.
INFO: This database is a PDB.
INFO: Current PDB is PREGBPPDB .
INFO: Database RDBMS DST version is DSTv38 .
INFO: No known issues detected.
INFO: Now detecting new RDBMS DST version.
ERROR: ORA-56922: Starting a prepare window failed.
ERROR: Most likely the shared pool is unable to allocate additional
ERROR: storage during the execution of the DBMS_DST.BEGIN_PREPARE package.
ERROR: Flush the shared pool or bounced the database to free up the SGA
ERROR: and then run utltz_upg_check.sql again.
DECLARE
*
ERROR at line 1:
ORA-20071: Stopping script - see previous message ...
ORA-06512: at line 44


INFO: Next step is checking all TSTZ data.
INFO: It might take a while before any further output is seen ...
ERROR: Something went wrong during DBMS_DST.FIND_AFFECTED_TABLES.
DECLARE
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at line 31
ORA-56924: prepare window does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DST", line 1535
ORA-06512: at line 13


DECLARE
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at line 4



Session altered.

Changes

Cause

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