My Oracle Support Banner

12.2.0.1.0 to 19c RAC DB upgrade via Autoupgrade failed (Error: UPG-3009) with PDB XYZpdb plugin violations on abcDB (Doc ID 3012600.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.22.0.0.0 and later
Information in this document applies to any platform.

Symptoms

The upgrade process from a NonCDB to a CDB for the 19c Database in RAC environment using Autoupgrade failed with the following errors:

 

From autoupgrade_xxxxxx.log

Errors in database [abcDB]

Stage [NONCDBTOPDB]

Operation [STOPPED]

Status [ERROR]

Info [

Error: UPG-3009

#There are plugin violations for pdb XYZpdb on abcDB

XYZpdb 3 ERROR PENDING Interim patch 29259068/25445795 (18.2 AUTO STATS JOB DOESNT FINISH DUE TO SLOW MERGE ON MON_MODS_ALL$): Not installed in the CDB but installed in the PDB

XYZpdb 3 ERROR PENDING Interim patch 34774667/25445264 (TT23.1ASAN GLOBAL-BUFFER-OVERFLOW IN PGA AT KWQALOCKQTWITHINFO): Not installed in the CDB but installed in the PDB

XYZpdb 3 ERROR PENDING Interim patch 29259068/25227623 (18.2 AUTO STATS JOB DOESNT FINISH DUE TO SLOW MERGE ON MON_MODS_ALL$): Installed in the CDB but not in the PDB

XYZpdb 3 ERROR PENDING Interim patch 34774667/25286547 (TT23.1ASAN GLOBAL-BUFFER-OVERFLOW IN PGA AT KWQALOCKQTWITHINFO): Installed in the CDB but not in the PDB

XYZpdb 3 ERROR PENDING '19.20.0.0.0 Release_Update 2307150228' is installed in the CDB but '19.22.0.0.0 Release_Update 2401040239' is installed in the PDB

Cause: After running noncdb_to_pdb.sql, the pdb was closed or was opened in restricted mode

For further details, see the log file located at /u02/app/oracle/product/upgrade/autoupgrade/XYZpdb3/103/autoupgrade_xxxxxxxx_user.log]

 

After reviewing the following query: 

SQL> select * from PDB_PLUG_IN_VIOLATIONS where STATUS != 'RESOLVED';

TIME NAME CAUSE TYPE ERROR_NUMBER LINE MESSAGE STATUS ACTION CON_ID

XYZpdb SQL Patch ERROR 0 1 Interim patch 29259068/25445795 (18.2 AUTO STATS JOB DOESNT FINISH DUE TO SLOW M ERGE ON MON_MODS_ALL$): Not installed in the CDB but installed in the PDB PENDING Call datapatch to install in the PDB or the CDB 3

XYZpdb SQL Patch ERROR 0 2 Interim patch 34774667/25445264 (TT23.1ASAN GLOBAL-BUFFER-OVERFLOW IN PGA AT KW QALOCKQTWITHINFO): Not installed in the CDB but installed in the PDB PENDING Call datapatch to install in the PDB or the CDB 3

XYZpdb SQL Patch ERROR 0 3 Interim patch 29259068/25227623 (18.2 AUTO STATS JOB DOESNT FINISH DUE TO SLOW M ERGE ON MON_MODS_ALL$): Installed in the CDB but not in the PDB PENDING Call datapatch to install in the PDB or the CDB 3

XYZpdb SQL Patch ERROR 0 4 Interim patch 34774667/25286547 (TT23.1ASAN GLOBAL-BUFFER-OVERFLOW IN PGA AT KW QALOCKQTWITHINFO): Installed in the CDB but not in the PDB PENDING Call datapatch to install in the PDB or the CDB 3

XYZpdb SQL Patch ERROR 0 5 '19.20.0.0.0 Release_Update 2307150228' is installed in the CDB but '19.22.0.0.0 Release_Update 2401040239' is installed in the PDB PENDING Call datapatch to install in the PDB or the CDB 3

 

When examining the status of the PDB: 

SQL>
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
2 PDB$SEED READ ONLY NO
3 XYZpdb READ WRITE YES

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


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