ORA-13602: The specified parameter RECOMMEND ALL is not valid for task or object Advisor.
Cause:
Make sure you give the right parameter in the advisor procedure
SQL> BEGIN
2 dbms_advisor.set_task_parameter(
3 task_name => 'Advisor',
4 parameter => 'RECOMMEND ALL', <----- _underscore missed
5 value => 'TRUE');
6 END;
7 /
BEGIN
*
ERROR at line 1:
ORA-13602: The specified parameter RECOMMEND ALL is not valid for task or
object Advisor.
ORA-06512: at "SYS.PRVT_ADVISOR", line 5010
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.PRVT_ADVISOR", line 1248
ORA-06512: at "SYS.PRVT_ADVISOR", line 4902
ORA-06512: at "SYS.DBMS_ADVISOR", line 401
ORA-06512: at line 2
Solution:
Check if you give correct parameter in set task parameter
This parameter stores various attributes that affect workload collection, tuning decisions and reporting.
SQL> BEGIN
2 dbms_advisor.set_task_parameter(
3 task_name => 'Advisor',
4 parameter => 'RECOMMEND_ALL',
5 value => 'TRUE');
6 END;
7 /
PL/SQL procedure successfully completed.