ORA-20009: Job Load_opatch_inventory is reported during Execution of Datapatch (Doc ID 2245063.1)

Last updated on APRIL 10, 2017

Applies to:

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

Symptoms

Datapatch -verbose fails with Error ORA-20009

SQL Patching tool version 12.1.0.2.0 on Thu Feb 16 14:45:07 2017
Copyright (c) 2016, Oracle. All rights reserved.

Connecting to database…OK

Queryable inventory could not determine the current opatch status.
Execute ‘select dbms_sqlpatch.verify_queryable_inventory from dual’
and/or check the invocation log
/opt/oracle/cfgtoollogs/sqlpatch/sqlpatch_2212_2017_02_16_14_45_07/sqlpatch_invocation.log
for the complete error.

SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;

VERIFY_QUERYABLE_INVENTORY
——————————————————————————–
ORA-20009: Job Load_opatch_inventory_2execution failed

 

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