830576

[Former Member]

Accordance with note 830576 we cann't set parameter optimizer_features_enable via sqlplus command:

ALTER SYSTEM SET OPTIMIZER_FEATURES_ENABLE = '' scope = spfile

*

ERROR at line 1:

ORA-00096: invalid value for parameter optimizer_features_enable, must be from

among 10.2.0.2.1, 10.2.0.2, 10.2.0.1, 10.1.0.5, 10.1.0.4, 10.1.0.3, 10.1.0,

9.2.0, 9.0.1, 9.0.0, 8.1.7, 8.1.6, 8.1.5, 8.1.4, 8.1.3, 8.1.0, 8.0.7, 8.0.6,

8.0.5, 8.0.4, 8.0.3, 8.0.0

Must we set one of the above variants given by Oracle? Or how to delete this parameter?

Please help.

[Former Member · Accepted solution]

You cannot set the parameter to an empty string.

You have to reset the parameter.

And this is not the same.

So try this:

ALTER SYSTEM RESET OPTIMIZER_FEATURES_ENABLE scope = spfile sid = '*';

It's all described in SAP note 601157, btw.