Re: semophore errors in Oracle 6.

From: Yves Noel <noel_at_omega.univ-lille1.fr>
Date: 24 May 1994 08:14:05 GMT
Message-ID: <2rsd0d$635_at_netserver.univ-lille1.fr>


In article <CqA9Cu.8H6_at_ssigv.UUCP>, thongj_at_tus.ssi1.com (James Hong) writes:
|>Dear Netter
|>
|>Frequently, I am getting following error message in alert log file.
|>
|>Fri May 20 13:48:02 1994
|>Error signalled in file: /usr/bin/oracle/rdbms/log/13_27234.trc
|>ORA-07265: sppst: semop error, unable to increment semaphore.
|>HP-UX Error: 22: Invalid argument
|>Additional information: 5205
|>ORA-00603: fatal ORACLE error occurred: unwise to proceed
|>ORA-07265: sppst: semop error, unable to increment semaphore.
|>HP-UX Error: 22: Invalid argument
|>Additional information: 5205
|>
|>After calling Oracle tech. support, I increased SEMMNI and SEMMNS values
|>to their recommendation. However, the message still pops up in the alert
|>log file. Has anyone seen the same message before ? What might cause
|>the error message ? and How to fix it.
|>
|>The Oracle version is ORACLE RDBMS V6.0.36.7.1 and we are running HP9000/735
|>with HP-UX A.09.01
|>
|>Thanks in advance !
|>

I've had the same error with the same version of ORACLE running on a DEC RISC ULTRIX. After increasing SEMMNU (30 --> 35) and SEMUME (10 --> 15) this error has no reappear. Try and see ! Increase with a little value at a time. Hope this help.

-- 
Yves NOEL ______________________________________________ C.I.T.I. (batiment M4)
Database Administrator ________________ Universite des Sciences et Technologies
Email: Yves.Noel_at_univ-lille1.fr ________ 59655 Villeneuve d'Ascq Cedex - FRANCE
Voice: (33) 20.33.70.74 _________________________________ Fax: (33) 20.43.66.25
Received on Tue May 24 1994 - 10:14:05 CEST

Original text of this message