After Upgrade from 10g to 11g, Gather Statistics Job Failing with "ORA-12012: error on auto execute of job "SYS"."GATHER_STATS_JOB""
(Doc ID 2023467.1)
Last updated on MARCH 03, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
- Gather statistics job is failing due to the following error:
- The name 'GATHER_STATS_JOB' is not the name of the default auto task in version 11.2.
Changes
Recently upgraded from 10g to 11g
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 |