Space Advisor Encounters Error ORA-13607: The Specified Task or Object SYS_AUTO_SPCADV_XX Already Exists
(Doc ID 1943133.1)
Last updated on JUNE 05, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.2 [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.
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
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |