My Oracle Support Banner

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

Last updated on FEBRUARY 14, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


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




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.