gistfile1.txt

[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.