Several errors on Oracle database

[Andres_13]

Hi all,

Thereis several errors on the alert file regarding some semaphores issues:

Mon Mar 24 17:21:55 2008
Errors in file /u51/app/oracle/admin/SDKUSA/bdump/sdkusa_dbw0_11905.trc:
ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 36
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1
Mon Mar 24 17:21:55 2008
DBW0: terminating instance due to error 27157
Instance terminated by DBW0, pid = 11905
Mon Mar 24 17:21:55 2008
Errors in file /u51/app/oracle/admin/SDKUSA/bdump/sdkusa_dbw0_11905.trc:
ORA-27300: OS system dependent operation:semctl failed with status: 22
ORA-27301: OS failure message: Invalid argument
ORA-27302: failure occurred at: sskgpwrm1
ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 36
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1

It's extrange because other five databases share the server with this one. Any clue?

Oracle version: 9.2.0.6.0 64 bit
OS version: HPUX 11.00 64 bit, 4 cpu, 4gb RAM

If more info is needed, please advice.

Regards!

[Andres_13]

Forgot to say that this is the only one that seems to have this kind of errors and also when i did a dmesg it's full of "mlock_region failed" massages.

Also attach the output of kmtune.

Regards!

[Volker Borowski · Accepted solution]

Hello,

check out Metalink Problem Document 438205.1

It decribes exactly your problem.
It assumes accidently remove of claimed oracle resources (i.e. by improper use of ipcrm) or a defective hardware.

Hope this helps.
Volker

[Andres_13]

Thank you Volker,

As suggested in that note i've programed a cron to record the output of ipcs an ps. I will leave the thread open in order to log the proper solution of this issue (if possible as well).

Regards!

[Andres_13]

The issue was solved simply by adjusting-down the SGA parameter of that database by our dba. Currently this database is errors-free (at least THAT kind ones)