Unable to run ADDM in gridcontrol
Hi,
I'm unable to run the ADDM inside the gridcontrol 12c.
when i checked the error there was a job that run everyday
select * from DBA_ADVISOR_TASKS order by created desc
as i checked in the log
select * from DBA_ADVISOR_LOG
all of them hit with this error.
ORA-00604: error occurred at recursive SQL level.
SELECT owner, job_name FROM dba_scheduler_jobs;
OWNER JOB_NAME
------------------ --------------------
SYS PURGE_LOG
SYS ORA$AUTOTASK_CLEAN
SYS HM_CREATE_OFFLINE_DICTIONARY
SYS DRA_REEVALUATE_OPEN_FAILURES
ORACLE_OCM MGMT_CONFIG_JOB
ORACLE_OCM MGMT_STATS_CONFIG_JOB
SYS BSLN_MAINTAIN_STATS_JOB
I'm unable to run the ADDM inside the gridcontrol 12c.
when i checked the error there was a job that run everyday
select * from DBA_ADVISOR_TASKS order by created desc
as i checked in the log
select * from DBA_ADVISOR_LOG
all of them hit with this error.
ORA-00604: error occurred at recursive SQL level.
SELECT owner, job_name FROM dba_scheduler_jobs;
OWNER JOB_NAME
------------------ --------------------
SYS PURGE_LOG
SYS ORA$AUTOTASK_CLEAN
SYS HM_CREATE_OFFLINE_DICTIONARY
SYS DRA_REEVALUATE_OPEN_FAILURES
ORACLE_OCM MGMT_CONFIG_JOB
ORACLE_OCM MGMT_STATS_CONFIG_JOB
SYS BSLN_MAINTAIN_STATS_JOB
0