ORA-02065: illegal option for ALTER SYSTEM with "_mutex_wait_scheme"

[Former Member]

Hello,

I have the Oracle version 11.2.0.2.0 in Windows. I'm trying to set starting parameter "_mutex_wait_scheme".

I am trying with the following command:

ALTER SYSTEM SET "_mutex_wait_scheme" = 1 SCOPE = SPFILE;

But I have the following error:

ERROR at line 1:

ORA-02065: illegal option for ALTER SYSTEM

Could tell me what is the command that I use to change that parameter?

Best regards!

[ACE-SAP · Accepted solution]

Hello,

The syntax you used is correct,

alter system set "_MUTEX_WAIT_SCHEME" = 1 scope = spfile sid='*';

but it seems that there is a problem with this parameter in version 12.2.0.2

Check if you have installed patch 12431716

%ORACLE_HOME%\Opatch\opatch lsinventory -all | find "12431716"

If it is not installed you can install the latest bundle patch (Windows Patch Bundle 27 - 11/2013) that should contain that fix.

Regards

1588876 - Oracle Enhancement to add different "Mutex" wait schemes

This fix is included in 11.2.0.2.2 PSU but there is a problem with the parameters in that release. If using 11.2.0.2.2 PSU then it is advisable to get the patch for bug 12431716 to allow this fix to be controlled by the _mutex_* parameters as documented above.

[former_member182657]

Hi Jose,

Please follow SAP Note   1588876 - Oracle Enhancement to add different "Mutex" wait scheme

Regards,

Gaurav