Hello,
I am attempting an install of oracle enterprise manager 13.4 with an Oracle Database 19c as the database repository. I created my instance using the oracle supplied template for OEM 13.4.
I followed the parameter adjustments mentioned in Doc ID 2635383.1 turning all features to off. I am still running into an error when the installer attempts the Database Connection. The error continues to read, "Check if all adaptive features parameters are unset" "All adaptive features parameters should be unset for improved SQL performance. Can anyone advise. Thank you in advance!
1) As SYSDBA execute the following statements in the repository DB:
alter system set "_optimizer_nlj_hj_adaptive_join"= FALSE scope=both sid='*';
alter system set "_optimizer_strans_adaptive_pruning" = FALSE scope=both sid='*';
alter system set "_px_adaptive_dist_method" = OFF scope=both sid='*';
alter system set "_sql_plan_directive_mgmt_control" = 0 scope=both sid='*';
alter system set "_optimizer_dsdir_usage_control" = 0 scope=both sid='*';
alter system set "_optimizer_use_feedback" = FALSE scope=both sid='*';
alter system set "_optimizer_gather_feedback" = FALSE scope=both sid='*';
alter system set "_optimizer_performance_feedback" = OFF scope=both sid='*';
2) Restart the repository database.