Queryable Patch inventory – Issue/Solutions for ORA-20012: job_queue_processes set to zero and Inventory can not be loaded (Doc ID 2283073.1)

Last updated on JULY 06, 2017

Applies to:

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

Symptoms

 
During execution of datapatch or DBMS_QOPATCH fails with error

SQL Patching tool version 12.2.0.0.0 on Sat Jul 1 01:50:07 2017
Copyright (c) 2014, 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’
for the complete error.
Prereq check failed, exiting without installing any patches.

 

SQL> select dbms_sqlpatch.verify_queryable_inventory from dual ;

VERIFY_QUERYABLE_INVENTORY
—————————————————————————-
ORA-20012: job_queue_processes set to zero and Inventory can not be loaded

 

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