We are having problems bringing up databases on our development box. When we try to bring up a couple, the following error comes up.

ORA-07279: spcre: semget error, unable to get first semaphore set.
SVR4 Error: 28: No space left on device
Additional information: 1

We have 7 databases. The total #processes are 1924. Shared memory parameters are:

set semsys:seminfo_semmni=256
set semsys:seminfo_semmns=4096
set semsys:seminfo_semmsl=256
set shmsys:shminfo_shmmax=2147483648
set shmsys:shminfo_shmmni=200
set shmsys:shminfo_shmseg=20
set shmsys:shminfo_shmmin=1

This problem appeared suddenly. I wonder if there is/are some processes hogging shared memory. How do I find out what those are?

I am thinking of doing one of these.

1. Do ipcs -b. Then shut down all the databases. ipcs -b again and see anything is still there. If yes, kill it with ipcsrm -m .

2. Reboot the machine.

Any ideas are appreciated. Thanks.