Windows:datapatch on Database with Patch 19215058 or 20244108 applied ,fails with Error:'ORA-20001','KUP-04017: OS message: '#!' is not recognized as an internal or external command' (Doc ID 2262820.1)

Last updated on JUNE 16, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Microsoft Windows x64 (64-bit)

Symptoms

datapatch -verbose in Windows  fails with error:

Bootstrapping registry and package to current versions...done
verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table

Queryable inventory could not determine the current opatch status.
Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual'

SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;

VERIFY_QUERYABLE_INVENTORY
--------------------------------------------------------------------------------
ORA-20001: Latest xml inventory is not loaded into table

 

qopatch_log.log shows the error:

KUP-04004: error while reading file D:\Oracle\1210\QOpatch\qopiprep.bat
KUP-04017: OS message: The operation completed successfully.
KUP-04017: OS message: '#!' is not recognized as an internal or external command,

 

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