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

source

Posting Komentar