Database failed to start ORA-27154, 27300,27301, 27302

Source: Internet
Author: User


Database Version

SQL> select * from V $ version





Oracle Database 11g Enterprise Edition release11. Production

PL/SQL release

Core Production

TNS for Linux: Version

Nlsrtl version



Startup Error

Connected to an idle instance.

SQL> startup

ORA-27154: Post/Wait create failed.

ORA-27300: OS system dependent operation: semget failedwith status: 28

ORA-27301: OS failure message: no space left on Device

ORA-27302: failure occurred at: sskgpsemsper




[Oracle @ shadow ~] $ Vim/proc/sys/kernel/SEM

[Oracle @ shadow ~] $ Su-Root


[Root @ shadow ~] # Echo "110 10000 100 128">/proc/sys/kernel/SEM

[Root @ shadow ~] # Exit




Is the problem solved?

SQL> select status from V $ instance;








[Oracle @ shadow ~] $ CAT/proc/sys/kernel/SEM

110 10000 100 128


The preceding four data types correspond

Semmsl semmns semopm semmni


Semms L 100 defines the minimum recommended value,

For initial installation only


Semmns 256 defines the maximum semaphores on thesystem.

This setting is a minimum recommended value,

For initial installation only. The semmns Parameter

Shocould be set to the sum of the processes Parameter

For each Oracle database, adding the largest onetwice,

And then adding an additional 10 for each database.


Semopm 100 defines the maximum number of operationsfor each semop call


Semmni 100 defines the maximum number ofsemaphore sets in the entire system

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.