PDB violations


After running datapatch, PDB plugin or cloned db returns violations shown in PDB_PLUG_IN_VIOLATION (Doc ID 1635482.1)

select time,name,cause,status,message from PDB_PLUG_IN_VIOLATIONS where type =’ERROR’ order by name;

select description from dba_registry_sqlpatch;

$ sqlplus / as sysdba
SQL> shutdown immediate;
SQL> startup upgrade;
SQL> alter pluggable database all open upgrade;
SQL> exit
$ $ORACLE_HOME/OPatch/datapatch -verbose
If datapatch reports an ORA-01435 error when applying any database patch, run the following commands to re-execute datapatch and ignore the error:

$ cd
$ ./datapatch -apply -verbose -ignorable_errors=ORA-01435,Warning

19c :datpatach fails with Error: prereq checks failed! Can’t call method “execute” on an undefined value & ‘ORA-04023’ (Doc ID 2575884.1)



About Author

Leave A Reply