After installing Oracle on Linux and creating a database,I tried to connect to sqlplus and startup the database instance I got this error:
$ sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 5 15:53:47 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to an idle instance.
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: sskgpsemsper
Solution:
As root user, edit the /etc/sysctl.conf file and edit the kernel parameters
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
and then run this command
/sbin/sysctl -p
9 comments:
Works great - thank you!
It helped. Thank you.
Sorry but i already have that set on my system. Its a 2 node RAC on Linux.
kernel.sem = 250 32000 100 128
Any suggestions?
Work like a charm!
Thank you, Ahmed.
this saves my day. Thanks a lot.
It's really helpful
Thanks!
Thank you!
Sweet
Worked like a charm, thanks a lot!
Post a Comment