Rolled Back Patch From Container Data Base (CDB) Remains In Pluggable Data Base (PDB) (Doc ID 2133099.1)

Last updated on MARCH 08, 2017

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.4.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.0.4.0 version, Target Database, Listener, ASM

When attempting to roll back an applied patch from a Container Data Base,
the following error occurs.

ERROR
-----------------------
c:\ORACLE\product\12.1.0\dbhome_1\OPatch>datapatch -pdbs <CDB SID> -verbose -rollback <PATCH NUMBER>
but I am getting

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.
No PDBs (subject to -pdbs parameter) are open, exiting


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. apply patch to CDB and PDB
2. roll back the patch from the CDB
3. receive the error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot rollback the patch from the PDB as it is in locked mode..

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms