CODEWITHSUNDEEP
oracle-databaseoracle-enterprise-manageroracle21c
mohammad sadegh sheikh zahedi
mohammad sadegh sheikh zahedi

Reputation: 11

OEM 13 Error: Check if all adaptive features parameters are unset

I have error when try to install OEM 13.5 on Oracle 21c

error image

Prerequisite Name = Check if all adaptive features parameters are unset

Prerequisite Detailed Name = Check if all adaptive features parameters are unset

Prerequisite Status = fail

Prerequisite Recommendation = All adaptive features parameters should be unset for improved SQL performance

Prerequisite Detailed Recommendation = If you have set below parameters on 18.x, 19.x etc database, you need to reset them by running below commands as sysdba:

alter system reset "_optimizer_nlj_hj_adaptive_join" scope=both sid='*';

alter system reset "_optimizer_strans_adaptive_pruning" scope=both sid='*';

alter system reset "_px_adaptive_dist_method" scope=both sid='*';

alter system reset "_sql_plan_directive_mgmt_control" scope=both sid='*';

alter system reset "_optimizer_dsdir_usage_control" scope=both sid='*';

alter system reset "_optimizer_use_feedback" scope=both sid='*';

alter system reset "_optimizer_gather_feedback" scope=both sid='*';

alter system reset "_optimizer_performance_feedback" scope=both sid='*';

In sqlplus run all alter with sys as sydba but not fix.

Upvotes: 0

Views: 1895

Answers (2)

Abolfazl Aghili
Abolfazl Aghili

Reputation: 111

I run the code as below and it worked for me. Database: oracle 21c & Cloud control 13.5

alter system reset "_optimizer_nlj_hj_adaptive_join" scope=both ;
alter system reset "_optimizer_strans_adaptive_pruning" scope=both ;
alter system reset "_px_adaptive_dist_method" scope=both ;
alter system reset "_sql_plan_directive_mgmt_control" scope=both ;
alter system reset "_optimizer_dsdir_usage_control" scope=both ;
alter system reset "_optimizer_use_feedback" scope=both ;
alter system reset "_optimizer_gather_feedback" scope=both ;
alter system reset "_optimizer_performance_feedback" scope=both ;

Upvotes: 0

Alireza Balavand
Alireza Balavand

Reputation: 59

you should use these codes:

    alter system reset "_optimizer_nlj_hj_adaptive_join" scope=both 
    sid='*';

    alter system reset "_optimizer_strans_adaptive_pruning" scope=both 
    sid='*';

    alter system reset "_px_adaptive_dist_method" scope=both sid='*';

    alter system reset "_sql_plan_directive_mgmt_control" scope=both 
    sid='*';


    alter system reset "_optimizer_dsdir_usage_control" scope=both sid='*';

    alter system reset "_optimizer_use_feedback" scope=both sid='*';

    alter system reset "_optimizer_gather_feedback" scope=both sid='*';

    alter system reset "_optimizer_performance_feedback" scope=both 
    sid='*';

Upvotes: 0

Related Questions