Database Tuning (MOSC)

MOSC Banner

Unable to run ADDM in gridcontrol

edited Jun 19, 2013 10:20PM in Database Tuning (MOSC) 8 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center