1. Does sys own a procedure ora$age_autotask_data
2. You should be able to recreate this task (and the
hm_create_offline_dictionary
and dba_reevaluate_open_failures tasks) by running as sys
@$ORACLE_HOME/rdbms/admin/catnomwn.sql -- to drop
@$ORACLE_HOME/rdbms/admin/catmwin.sql -- to recreate
If that doesn't work then I'd suggest an SR.
On Thu, May 10, 2018 at 3:33 AM, Diego Melo <diegopmelo@xxxxxxxxx> wrote:
Hello guys,
Anyone could help me?
DB Version 11.2.0.4.0 Enterprise Extreme Performance.
the sheduler execution "SYS"."ORA$AUTOTASK_CLEAN" has started display
this error:
ORA-12012: error on auto execute of job "SYS"."ORA$AUTOTASK_CLEAN"
ORA-06576: not a valid function or procedure name
The scheduler is enabled
select owner, job_name, enabled from dba_scheduler_jobs where
job_name='ORA$AUTOTASK_CLEAN';
OWNER |JOB_NAME |ENABL
SYS |ORA$AUTOTASK_CLEAN |TRUE
And there's no invalid object on SYS schema.
Diego
Best regards.
