-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|