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 APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Symptom 1
================
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

Symptom 2
================
Running datapatch on 12.2.0.1 on windows platform fails with below

datapatch -verbose
SQL Patching tool version 12.2.0.1.0 Production on Mon Aug 12 14:20:57 2019
Copyright (c) 2012, 2019, Oracle. All rights reserved.

Log file for this invocation: <ORACLE_BASE>\sqlpatch_5928_2019_08_12_14_20_58\sqlpatch_invocation.log

Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of SQL patches:
Bundle series PSU:
Not installed in the binary registry and not installed in the SQL registry

Adding patches to installation queue and performing prereq checks...
Installation queue:
Nothing to roll back
Nothing to apply

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

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

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)

Applies to:

Symptoms

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!