Enterprise Manager Generic (MOSC)

MOSC Banner

Upgrade Cloud Control 13.3 => 13.4 fails "Check if all adaptive features parameters are unset" test

I am trying to upgrade an installation of Cloud Control 13.3 to 13.4, and when it is checking the database prerequisites of my 19c database (to which I have already applied 19.11 RU) it fails as described in MOS Document 2635383.1. I followed the instructions in that note and ran the suggested SQL:


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='*';

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