[oracle@rhec2lab1:/u01/app/oracle/product/12.1.0.2/db1/OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 on Tue Oct 20 16:00:27 2015
Copyright (c) 2015, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_13061_2015_10_20_16_00_27/sqlpatch_invocation.log
Connecting to database...OK
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Bundle series PSU:
ID 4 in the binary registry and ID 4 in PDB CDB$ROOT, ID 4 in PDB PDB$SEED
Adding patches to installation queue and performing prereq checks...
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED
Nothing to roll back
Nothing to apply
For the following PDBs: PDB
Nothing to roll back
The following patches will be applied:
20831110 (Database Patch Set Update : 12.1.0.2.4 (20831110))
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...
Patch 20831110 apply (pdb PDB): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/20831110/18977826/20831110_apply_ATLAS_PDB_2015Oct20_16_00_45.log (no errors)
SQL Patching tool complete on Tue Oct 20 16:00:46 2015
Pluggable database altered.
[oracle@rhec2lab1:/home/oracle]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Oct 20 16:01:54 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SYS@ATLAS> col cause for a10
SYS@ATLAS> col name for a10
SYS@ATLAS> col message for a35 word_wrapped
SYS@ATLAS> select name, cause, type, message, status
2 from PDB_PLUG_IN_VIOLATIONS
3 where name = 'PDB' and type = 'ERROR';
NAME CAUSE TYPE MESSAGE STATUS
---------- ---------- --------- ----------------------------------- ---------
PDB SQL Patch ERROR PSU bundle patch 4 (Database Patch PENDING
Set Update : 12.1.0.2.4
(20831110)): Installed in the CDB
but not in the PDB.
SYS@ATLAS> alter pluggable database pdb close;
Pluggable database altered.
SYS@ATLAS> alter pluggable database pdb open;
Pluggable database altered.
SYS@ATLAS> col cause for a10
SYS@ATLAS> col name for a10
SYS@ATLAS> col message for a35 word_wrapped
SYS@ATLAS> select name, cause, type, message, status
2 from PDB_PLUG_IN_VIOLATIONS
3 where name = 'PDB' and type = 'ERROR';
NAME CAUSE TYPE MESSAGE STATUS
---------- ---------- --------- ----------------------------------- ---------
PDB SQL Patch ERROR PSU bundle patch 4 (Database Patch RESOLVED
Set Update : 12.1.0.2.4
(20831110)): Installed in the CDB
but not in the PDB.