Space Advisor Encounters Error ORA-13607: The Specified Task or Object SYS_AUTO_SPCADV_XX Already Exists (Doc ID 1943133.1)

Last updated on DECEMBER 06, 2016

Applies to:

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

Symptoms

Segment Advisor fails with the following Errors :
ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_2"
ORA-13607: The specified task or object SYS_AUTO_SPCADV_07012212112013 already exists
ORA-06512: at "SYS.PRVT_ADVISOR", line 4869
ORA-06512: at "SYS.DBMS_ADVISOR", line 103
ORA-06512: at "SYS.DBMS_SPACE", line 2388
ORA-06512: at "SYS.DBMS_SPACE", line 2538

 Call Stack :
kserec1  kkxerse  pevm_icd_call_common  pfrinstr_ICAL  pfrrun_no_tool  pfrrun plsql_run  peidxr_run  peidxexe


----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0xdb4dd7a8   86  package body SYS.DBMS_SYS_ERROR
0x64465f30 5760  package body SYS.PRVT_ADVISOR
0x64465f30 1264  package body SYS.PRVT_ADVISOR
0x64465f30 4844  package body SYS.PRVT_ADVISOR
0xdb0d79c8 103  package body SYS.DBMS_ADVISOR
0xdb6e25e0 2388  package body SYS.DBMS_SPACE
0xdb6e25e0 2538  package body SYS.DBMS_SPACE

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