Datapatch errors at "SYS.DBMS_QOPATCH" (Doc ID 1599479.1)

Last updated on MARCH 01, 2017

Applies to:

Oracle Database - Standard Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

The following list of errors could be encountered when datapatch is run to complete post-patch SQL actions:

ORA-20000 : INVALID_OPERATION during openScriptFile
ORA-20001 : Latest xml inventory is not loaded into table.
ORA-20002 : Directory creation failed.
ORA-20003 : Configuration of a job on a node failed.
ORA-20004 : Job configuration failed as node is inactive.
ORA-20005 : Job is not configured with given node, instance name.
ORA-20006 : Number of RAC active instances and opatch jobs configured are not same.
ORA-20007 : Job configuration failed as node and instance is not active.
ORA-20008 : Timed out, Job execution time is more than 120Secs.
ORA-20009 : Job execution failed.
ORA-20010 : Node is inactive and job cann't be executed.
ORA-20011 : Job name is NULL and inventory cann't be loaded.
ORA-20012 : Job_queue_processes set to zero and Inventory can not be loaded.
ORA-20013 : DBMS_QOPATCH ran mostly in non install area

 

Changes

 datapatch is executed to perform post install steps

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