PDB_PLUG_IN_VIOLATIONS Pending Actions are not Cleared Even After the Actions have been completed (Doc ID 2569782.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

There are errors or pending actions in PDB_PLUG_IN_VIOLATIONS.

After fixing all pending actions, they are not removed from  PDB_PLUG_IN_VIOLATIONS and PDB still opens in restricted mode.

SQL> select time,name,cause,status,message from PDB_PLUG_IN_VIOLATIONS where status!='RESOLVED' order by name;

TIME
---------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
CAUSE STATUS
---------------------------------------------------------------- ---------
MESSAGE
--------------------------------------------------------------------------------
22-JUL-19 10.30.03.127284 AM

<pdb_name>

PDB not Unicode PENDING
Character set mismatch: PDB character set WE8ISO8859P1. CDB character set AL32UTF8.

TIME
---------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
CAUSE STATUS
---------------------------------------------------------------- ---------
MESSAGE
--------------------------------------------------------------------------------

22-JUL-19 10.30.03.677764 AM

<pdb_name>

SQL Patch PENDING
SQL patch ID/UID 29249637/22802302 (OJVM RELEASE UPDATE: 12.2.0.1.190416 (292496

TIME
---------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
CAUSE STATUS
---------------------------------------------------------------- ---------
MESSAGE
--------------------------------------------------------------------------------
37)): Installed in the PDB but not in the CDB.

22-JUL-19 10.30.03.168040 AM

<pdb_name>

OPTION PENDING

TIME
---------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
CAUSE STATUS
---------------------------------------------------------------- ---------
MESSAGE
--------------------------------------------------------------------------------
Database option APS mismatch: PDB installed version NULL. CDB installed version
12.2.0.1.0.

22-JUL-19 10.30.03.168467 AM

<pdb_name>

TIME
---------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
CAUSE STATUS
---------------------------------------------------------------- ---------
MESSAGE
--------------------------------------------------------------------------------
OPTION PENDING
Database option CONTEXT mismatch: PDB installed version NULL. CDB installed version 12.2.0.1.0.

22-JUL-19 10.30.03.127034 AM

TIME
---------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
CAUSE STATUS
---------------------------------------------------------------- ---------
MESSAGE
--------------------------------------------------------------------------------

<pdb_name>

Non-CDB to PDB PENDING
PDB plugged in is a non-CDB, requires noncdb_to_pdb.sql be run.

22-JUL-19 10.30.03.169367 AM

TIME
---------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
CAUSE STATUS
---------------------------------------------------------------- ---------
MESSAGE
-----------------------------------------------------------------------------

Even after fixing the errors, the PDB is still in restricted mode and entries in PDB_PLUG_IN_VIOLATIONS still show as pending.

Cause

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