My Oracle Support Banner datapatch issue : ORA-27477: "SYS"."LOAD_OPATCH_INVENTORY_1" already exists (Doc ID 1934882.1)

Last updated on SEPTEMBER 20, 2018

Applies to:

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


 The following error is occured while applying data patch on

./datapatch -verbose
SQL Patching tool version on Sun Oct 12 06:15:41 2014
Copyright (c) 2014, Oracle. All rights reserved.

Connecting to database...OK
Determining current state...
Currently installed SQL Patches: 18031528
DBD::Oracle::st execute failed: ORA-27477: "SYS"."LOAD_OPATCH_INVENTORY_1" already exists
ORA-06512: at "SYS.DBMS_QOPATCH", line 1011
ORA-06512: at line 4 (DBD ERROR: OCIStmtExecute) [for Statement "DECLARE
x XMLType;
x := dbms_qopatch.get_pending_activity;
? := x.getStringVal();
END;" with ParamValues: :p1=undef] at /u01/app/oracle/product/ line 1227. job_name,state, start_date from dba_scheduler_jobs where job_name like 'LOAD_OPATCH%';

JOB_NAME                                           STATE           START_DATE
-------------------------------------------------- --------------- ---------------------------------------------------------------------------
LOAD_OPATCH_INVENTORY_2                            SUCCEEDED       15-MAY-14 PM -04:00
LOAD_OPATCH_INVENTORY                              DISABLED        12-MAY-14 PM -04:00
LOAD_OPATCH_INVENTORY_1_OLD                        DISABLED        15-MAY-14 PM -04:00
LOAD_OPATCH_INVENTORY_1                            DISABLED        12-OCT-14 AM -04:00

SQL> select NODE_NAME, INST_ID, INST_JOB from opatch_inst_job;

NODE_NAME                                                       INST_ID INST_JOB
------------------------------------------------------------ ---------- --------------------------------------------------------------------------------------------------------------------------------                                               1 Load_opatch_inventory_1                                               2 Load_opatch_inventory_2

SQL> select dbms_qopatch.get_pending_activity () from dual;

ORA-27477: "SYS"."LOAD_OPATCH_INVENTORY_1" already exists
ORA-06512: at "SYS.DBMS_QOPATCH", line 1011




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.