My Oracle Support Banner

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 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Datapatch apply fails with below errors

$ ./datapatch -verbose
SQL Patching tool version 12.2.0.1.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...
Installation queue:
 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-

select dbms_sqlpatch.verify_queryable_inventory from dual;

  VERIFY_QUERYABLE_INVENTORY
1 ORA-20013: DBMS_QOPATCH ran mostly in non install area



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.