datapatch fails with "Not installed in the binary registry and not installed in any PDB" & "Nothing to roll back Nothing to apply"
(Doc ID 2602728.1)
Last updated on NOVEMBER 08, 2019
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
Datapatch apply fails with below errors
SQL Patching tool version 188.8.131.52.0 Production on Tue Oct 22 14:39:10 2019
Copyright (c) 2012, 2019, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_56828_2019_10_22_14_39_10/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 DBRU:
Not installed in the binary registry and not installed in any PDB
Adding patches to installation queue and performing prereq checks...
For the following PDBs: CDB$ROOT PDB$SEED PDB1
Nothing to roll back
Nothing to apply
SQL Patching tool complete on Tue Oct 22 14:39:20 2019
Queryable Inventory Layer does not seem to work-
1 ORA-20013: DBMS_QOPATCH ran mostly in non install area
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document