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:
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 .