troubleshooting Question

ORA-27301: OS failure message: No space left on device

Avatar of junaid_baig1
junaid_baig1 asked on
Oracle Database
5 Comments2 Solutions6812 ViewsLast Modified:
Im unable to start the database. It gives the error:-

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

 

 

What exactly is this error?

I checked ORACLE_HOME and oradata path,they are 90%(approx)
Oracle Version:-  9.2.0.6.0

 

Alert log shows following error repetitively:-

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

Tue Oct  6 09:37:55 2009

Starting ORACLE instance (normal)

Tue Oct  6 09:37:57 2009

 

 

Current Values(captured from /etc/system)

set shmsys:shminfo_shmmax = 7340032000

set shmsys:shminfo_shmmin = 8

set shmsys:shminfo_shmmni = 2048

set shmsys:shminfo_shmseg = 2048

set semsys:seminfo_semmni = 2000

set semsys:seminfo_semmsl = 3025

set semsys:seminfo_semmns = 8000

set semsys:seminfo_semmap = 2000

set semsys:seminfo_semopm = 100

set semsys:seminfo_semmnu = 3025

set semsys:seminfo_semume = 500

set semsys:seminfo_semvmx = 32767

set msgsys:msginfo_msgmap = 512

set msgsys:msginfo_msgmax = 8192

set msgsys:msginfo_msgmnb = 16384

set msgsys:msginfo_msgmni = 3600

 
$ uname -r

5.8

$ uname -a

SunOS TTLMUME2E-02 5.8 Generic_117350-25 sun4u sparc SUNW,Sun-Fire-15000

 
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros