Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Several errors on Oracle database

SOLVED
Go to solution
Andres_13
Respected Contributor

Several errors on Oracle database

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!
4 REPLIES
Andres_13
Respected Contributor

Re: Several errors on Oracle database

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
Honored Contributor
Solution

Re: Several errors on Oracle database

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
Respected Contributor

Re: Several errors on Oracle database

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
Respected Contributor

Re: Several errors on Oracle database

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)