Re: job "SYS"."ORA$AUTOTASK_CLEAN"
Date: Thu, 10 May 2018 09:59:26 +0100
Message-ID: <CABe10sb=j29EYWiEm_UO8amsWw9h0Y3vjE1Arha6gcsmxA_XZw_at_mail.gmail.com>
- Does sys own a procedure ora$age_autotask_data
- You should be able to recreate this task (and the hm_create_offline_dictionary and dba_reevaluate_open_failures tasks) by running as sys
_at_$ORACLE_HOME/rdbms/admin/catnomwn.sql -- to drop _at_$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_at_gmail.com> 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.
>
>
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Thu May 10 2018 - 10:59:26 CEST