-
Hi All,
I am having the error message below where I try to create a new database. I do not know what is the problem because I have over 600Megs of space on the disks I am using. Can someone please help... any suggestion will be greatly appeciated.
ORA-07279: spcre: semget error, unable to get first semaphore set.
HP-UX Error: 28: No space left on device
Additional information: 1
Thanks in advance,
Bond
-
Your kernal parameters are not setup correctly. Check the installation guide for semephore parameters...
-
This would be a normal math for the /etc/system file SEMMNS
a = 200
b = 100
c = 100
SEMMNS = [ (2*a) +b+c ] + [ No. of instances * 10]
But I would suggest that you go with
SEMMNS = [2(a+b+c)] + {#instances * 10}
Good luck.
Sam
-
Thanks for your help!!!!
Bond.