ORA-02097: parameter cannot be modified because specified value is invalid when modifying the parameter _fix_control

 Problem:

When modifying _fix_control parameter to enable optimizer related bug fixes on a 19.12 DB, I was getting this error:

Analysis:

I was trying to enable optimizer related bug fixes by adding the bug numbers to _fix_control, I came to know that some of these bug fixes I'm trying to enable are not exist in the DB.

The following query will show the bug fixes that are available on the DB out of the list in the failing command:

SQL> SELECT bugno,value,description FROM v$system_fix_control WHERE bugno IN ('18960760','29302565','30998035', '5705630','30786641' ,'28414968' ,'29867728' ,'29385774','27261477','31069997','31077481','30347410','28776431','29304314','29930457','30232638','29687220','28498976','29132869','28776811','28965084','25167306','22149010','28345522');

That clearly shows the available bug fixes, which I've to include only in my command, and discard the rest of bugs that are not found.

Solution:

Using only the available bug fixes in my command make it execute successfully:

SQL> alter system set "_fix_control"= '5705630:1','22149010:1','25167306:1','28345522:1','29687220:1','30232638:1','28498976:1','28965084:1','28776811:1','29132869:1','28776431:1','29304314:1','29930457:1','30347410:1','31069997:1','31077481:1','27261477:1','30998035:1','29302565:1','30786641:1','28414968:1','29867728:1','29385774:1' SCOPE=BOTH;

Verify the change:

SQL> SELECT bugno,value FROM v$system_fix_control WHERE bugno IN ('5705630','22149010','25167306','28345522','29687220','30232638','28498976','28965084','28776811','29132869','28776431','29304314','29930457','30347410','31069997','31077481','27261477','30998035','29302565','30786641','28414968','29867728','29385774');