PDB_PLUG_IN_VIOLATIONS view is useful view if there is any issues with PDB.
SQL> alter pluggable
database PDB1 open;
Warning: PDB altered with
errors.
SQL>
show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
----------
------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE YES
SQL>
desc PDB_PLUG_IN_VIOLATIONS
Name
Null? Type
-----------------------------------------
-------- ----------------------------
TIME NOT NULL
TIMESTAMP(6)
NAME NOT NULL VARCHAR2(30)
CAUSE
VARCHAR2(22)
TYPE
VARCHAR2(9)
ERROR_NUMBER NUMBER
LINE NOT NULL
NUMBER
MESSAGE NOT NULL
VARCHAR2(4000)
STATUS
VARCHAR2(9)
ACTION
VARCHAR2(4000)
SQL> select
NAME,ERROR_NUMBER,MESSAGE,STATUS,ACTION from PDB_PLUG_IN_VIOLATIONS;
NAME ERROR_NUMBER MESSAGE
STATUS ACTION
-----
------------ -------------------------------------------------- ---------
------------------------------------------------------------
PDB1 0 CDB parameter sga_target
mismatch: Previous 740M C RESOLVED
Please check the parameter in the current CDB
urrent 712M
PDB1 0 CDB parameter
pga_aggregate_target mismatch: Previ RESOLVED
Please check the parameter in the current CDB
ous 245M Current 236M
PDB1 0 CDB parameter
enable_pluggable_database mismatch:
RESOLVED Please check the
parameter in the current CDB
Previous FALSE Current TRUE
PDB1 0 PDB plugged in is a non-CDB,
requires noncdb_to_pd RESOLVED Run
noncdb_to_pdb.sql.
b.sql be run.
PDB1 0 Database option RAC mismatch:
PDB installed versio PENDING Fix the
database option in the PDB or CDB n 12.1.0.1.0. CDB installed
version NULL.
PDB1 0 SQL patch 19769486 mismatch:
Installed in the PDB PENDING Install the SQL patch in the PDB or the
CDB.Please refer to
but not in the CDB. the Known Issues
section of MOS note Doc ID 1585822.1 for more details.
PDB1 0 SQL patch 20299016 mismatch:
Installed in the PDB PENDING Install the SQL patch in the PDB or the
CDB.Please refer to
but not in the CDB. the
Known Issues section of MOS note Doc ID 1585822.1 for more
details.
PDB1 0 SQL patch 20831107 mismatch:
Installed in the PDB PENDING Install the SQL patch in the PDB or the
CDB.Please refer to
but not in the CDB. the Known Issues section of MOS note
Doc ID 1585822.1 for more details.
PDB1 0 SQL patch 21352619 mismatch:
Installed in the PDB PENDING Install the SQL patch in the PDB or the
CDB.Please refer to
but not in the CDB. the
Known Issues section of MOS note Doc ID 1585822.1 for more details.
PDB1 0 SQL patch 21951844 mismatch:
Installed in the PDB PENDING Install the SQL patch in the PDB or the
CDB.Please refer to
but not in the CDB. the
Known Issues section of MOS note Doc ID 1585822.1 for more details.
PDB1 0 SQL patch 22291141 mismatch:
Installed in the PDB PENDING Install the SQL patch in the PDB or the
CDB.Please refer to
but not in the CDB. the
Known Issues section of MOS note Doc ID 1585822.1 for more details.
11 rows
selected.
SQL>
No comments:
Post a Comment