Unknown Parameter - _mutex_wait_scheme

[Private_Member_19084]

Hi experts,

if we try to start our oracle database, we get the following error.

I hope somebody can help me.

OS is an HP-UX B.11.31 U ia 64

SQL*Plus: Release 11.2.0.2.0 Production on Tue May 29 11:03:09 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORA-01078: failure in processing system parameters

LRM-00101: unknown parameter name '_mutex_wait_scheme'

SQL>

SQL>

SQL>

Thx for help

[Former Member · Accepted solution]

Hi Christian,

Check installed Oracle patches by "opatch lsinventory". Search for "11818335" is installed.

If it is not installed, install the latest Oracle 11g patch.

For the further information, check Note 1588876 - Oracle Enhancement to add different "Mutex" wait schemes

Best regards,

Orkun Gedik

[Private_Member_19084 · Accepted solution]

Thx for help,

how do I get the installed patches?

Which command do I have to use.

Thx in advance

[Former Member · Accepted solution]

su - ora<sid>

cd /oracle/<DBSID>/11202/OPatch

opatch lsinventory

[Private_Member_19084 · Accepted solution]

This is what I get.

Not good?

Oracle Home       : /oracle/<sid>/112_64
Central Inventory : /oracle/<sid>/oraInventory
   from           : /var/opt/oracle/oraInst.loc
OPatch version    : 11.2.0.1.3
OUI version       : 11.2.0.2.0
OUI location      : /oracle/<sid>/112_64/oui
Log file location : /oracle/<sid>/112_64/cfgtoollogs/opatch/opatch2012-05-29_17-29                           -58PM.log

Patch history file: /oracle/<sid>/112_64/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /oracle/<sid>/112_64/cfgtoollogs/opatch/lsinv/l                           sinventory2012-05-29_17-29-58PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.2.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

[Former Member · Accepted solution]

Unfortunately, not good. Please, download and apply the latest patch, in the link below;

http://service.sap.com/~form/sapnet?_SHORTKEY=01100035870000734308&_SCENARIO=01100035870000000202&

You can find the installation instructions in the readme files.

Best regards

Orkun Gedik

[Former Member · Accepted solution]

Hi Christian,

as you have no interim patches installed, you don't have the patch "11818335" installed Orkun mentioned above. Please follow his suggestion and install this using OPatch (or MOPatch).

For usage of MOPatch please have a look at SAP note #1027012, for OPatch #839182.

Regards,

Peter

[Private_Member_19084 · Accepted solution]

Hello,

thx for help.

I downloaded both zips from Orkuns link.

But therein is no directory called 11818335 (I gues dir name is equal to the patch name).

So does this mean, that this patch is not included?

Another question.

As this should be our sandbox system I need the same version of DB like our productive system.

Can I also copy the patches from our productive system?

Thx

[Former Member · Accepted solution]

Hi,

The patch is included into the latest bundle patch. You can find this information in BUGSFIXED_201205_HPUXIA64.htm

If the database releases are same on both sides, you safely apply the same patch by using "opatch"

Best regards,

Orkun Gedik

[Private_Member_19084 · Accepted solution]

Thx

so this would be Patch 13696224.

Now the problem is, that this patch is not installed on our productive system, I guess at the patches there are older.

The patch which fixes the bug 11818335 on our productive sytem is the patch 12419331.

And as our sandbox system has to be identical to our prod system, I also sould use the same patches.

Can I downloaded older patches two or install them from our prod system?

Thx

[Former Member · Accepted solution]

Hi,

It seems that patch# 11818335 included to the patch bundle 12419331. Yes, you can apply the same patch to the sandbox system.

Best regards,

Orkun Gedik

[Private_Member_19084]

Hi Orkon,

now it works - db is up

Thx for help

[Former Member]

Good to hear that it is ok

You'r welcome

[Former Member]

Good to hear that it is ok

You'r welcome

[Private_Member_19084]

Ok I think I found the problem, to my above question.

I had to use the newest version of MOPatch.

See note 1431796, therein the "Database Vault special patch" is described

and also note 1027012, therein the installation of the newest MOPatch Version is described

Thx to all for help!

[Former Member]

Ok. I am waiting for your feedback

Best regards,

Orkun Gedik

[Private_Member_19084]

Hi,

now I've installed the same patch-set as on the productive system.

But 11 patches are not installed.

Error message is: "missing prereqs: 12419331"

This is the patch I need mostly lol

The patch installation of 12419331 aborted with "Is a Database Vault special patch.".

There is also a note to note 1020937 for the installation, but this note does not help me.

So how can I install the patch 12419331, as it is an Database Vault special patch?

Thx