Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

ORA-27300: OS system dependent operation:semop failed with status: 34

edited Nov 7, 2022 7:48AM in Database Install/Upgrade/Opatch (MOSC) 4 commentsAnswered

Started getting the above error recently during the INSERT operation most of the time on a table have 3 CLOBS.

org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [insert into aggregation_TXCache (aggregationTXCacheId, machineNumber, aggregationPeriod, aggregationType, cacheRows) values (?, ?, ?, ?, ?)]; SQL state [99999]; error code [27152]; ORA-27152: attempt to post process failed

ORA-27300: OS system dependent operation:semop failed with status: 34

ORA-27301: OS failure message: Numerical result out of range

ORA-27302: failure occurred at: sskgpwvp2

ORA-27303: additional information: old_semid post_count 0x8af0015 2

; nested exception is java.sql.SQLException: ORA-27152: attempt to post process failed

ORA-27300: OS system dependent operation:semop failed with status: 34

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center