Re: job "SYS"."ORA$AUTOTASK_CLEAN"

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 10 May 2018 09:59:26 +0100
Message-ID: <CABe10sb=j29EYWiEm_UO8amsWw9h0Y3vjE1Arha6gcsmxA_XZw_at_mail.gmail.com>



  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
       _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-l
Received on Thu May 10 2018 - 10:59:26 CEST

Original text of this message