My Oracle Support Banner

12.2 : QOPatch fails with User-Defined Exception error (Doc ID 2433236.1)

Last updated on AUGUST 10, 2018

Applies to:

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


Running datapatch -verbose ,fails with error:

sqlpatch_invocation log shows:
Bootstrapping registry and package to current versions...done
verify_queryable_inventory returned User-Defined Exception

Queryable inventory could not determine the current opatch status.
Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual' and/or
check the invocation log

Ran the query from sqlplus:
SQL> select dbms_sqlpatch.verify_queryable_inventory from dual ;

User-Defined Exception




 There is a lock generated by MMON,which does not get released



To view full details, 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 a vibrant support community of peers and Oracle experts.