Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Advisor Job failed...

sgalaxyNov 20 2006 — edited Nov 21 2006

Hi ,
I have installed the Oracle RDBMS 10g and Enterprise Manager as well.....
I try to run the SQL Access Advisor as user SYS but it constantly fails...

The error messages are as follows.....
ORA-13605: Task or Object SQLACCESS8165579 does not exist...
Details ORA-06512: in "SYS.PRVT_ADVISOR", line 2676 , ORA-06512: in "SYS.DBMS_ADVISOR line 247 , ORA-06512: line23 does not exist for the current user....

So , do i have to run the SQL Access Advisor with another user or should I first grant some specific-in this situation which are- privileges to user SYS...????

Regards,
Simon

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 19 2006

Added on Nov 20 2006

5 comments

981 views