My Oracle Support Banner

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

Last updated on FEBRUARY 22, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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

 

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.