Oracle Database on Linux Fails to Start - ORA-27154 ORA-27300 OR
需积分: 5 150 浏览量
2023-05-25
22:01:27
上传
评论
收藏 188KB PDF 举报
Copyright (c) 2023, Oracle. All rights reserved. Oracle Confidential.
Oracle Database on Linux Fails to Start - ORA-27154 ORA-27300 ORA-27301 ORA-27302:
failure occurred at: sskgpbitsper (Doc ID 2789636.1)
In this Document
Symptoms
Changes
Cause
Solution
References
APPLIES TO:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Linux x86-64
Linux x86
SYMPTOMS
Oracle Database is installed on Oracle Linux.
Multiple database instances are successfully running.
Requisite kernel parameter kernel.sem defines more than sufficient total semaphores for the required number of instances.
Attempting to start another instance fails with the following system semaphore related errors:
$ sysctl kernel.sem
kernel.sem = 1024 60000 1024 256
SQL> startup
ORA-27154: post/wait create failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpbitsper
CHANGES
Attempted startup of a newly created database instance.
CAUSE
The error occurs due to the exhaustion of total number of semaphore sets/arrays.
SOLUTION
Overview
Semaphores are an interprocess communication (IPC) locking/synchronisation mechanism allowing processes/threads to
interoperate and coordinate their activity.
Various processes on a system require and utilise semaphores, therefore sufficient semaphores must be configured for the
intended use case.
One kernel parameter, kernel.sem, is used to configure multiple system semaphore settings i.e.
kernel.sem = <semmsl> <semmns> <semopm> <semmni>
For example:
资源评论
