ORA-27301: OS failure message: No space left on device
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
$ 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
No comments:
Post a Comment