12.1.0.1 datapatch issue : ORA-27477: "SYS"."LOAD_OPATCH_INVENTORY_1" already exists (Doc ID 1934882.1)

Last updated on MAY 17, 2017

Applies to:

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

Symptoms

 The following error is occured while applying data patch on 12.1.0.1

./datapatch -verbose
SQL Patching tool version 12.1.0.1.0 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;
BEGIN
x := dbms_qopatch.get_pending_activity;
? := x.getStringVal();
END;" with ParamValues: :p1=undef] at /u01/app/oracle/product/12.1.0.1/sqlpatch/sqlpatch.pm line 1227.

  

1.select 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 02.55.44.198194 PM -04:00
LOAD_OPATCH_INVENTORY                              DISABLED        12-MAY-14 04.25.49.802804 PM -04:00
LOAD_OPATCH_INVENTORY_1_OLD                        DISABLED        15-MAY-14 02.55.43.590385 PM -04:00
LOAD_OPATCH_INVENTORY_1                            DISABLED        12-OCT-14 05.51.22.234660 AM -04:00

SQL> select NODE_NAME, INST_ID, INST_JOB from opatch_inst_job;

NODE_NAME                                                       INST_ID INST_JOB
------------------------------------------------------------ ---------- --------------------------------------------------------------------------------------------------------------------------------
oravmp01a.putnaminv.com                                               1 Load_opatch_inventory_1
oravmp01b.putnaminv.com                                               2 Load_opatch_inventory_2

SQL> select dbms_qopatch.get_pending_activity () from dual;

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

 

  

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