Re: trouble starting db instance

I get this problem frequently. There are two ways to get rid of this:

1. Find out the IPC resources that your system consumes. Delete the semaphores and Shared memory locks that other users place on the system. The command to do this (on HP-UX) is ipcrm -s (for semaphore sets).
   > ipcs -bc will give you a detailed listing of all the IPC's that your
   system is currently using. You may find the corresponding command for your operating system and fix the problem immediately.
2. Reconfigure the kernel the increase the number of semaphore sets to a larger number.

Oracle usually requires a minimum number of flags for its processes. I believe its around 21 semaphore sets when starting up a fresh instance.

-Sudarshan

Phong Lam wrote:

> Hi,
>
> When I tried to start a 7.3.4 instance, I get the following message:
>
> ORA-07279: spcre: semget error, unable to get first semaphore set.
> SVR4 error: 28: No space left on device
> Additional information: 1
>
> What does this mean? Is my semaphores set too low? Do I actually
> running out of disk space? I check on the system with "df -k " command,
> and it shows that I have the following:
>
> / 67% 57MB free
> /usr 70% 187MB
> /export 30% 2GB (this is where I installed Oracle 7.3.4)
>
> I'm using the default semaphore setting recommended with oracle
> installation guide. My database have no data tables, other than
> standard oracle tables.
Received on Tue Aug 03 1999 - 15:50:58 CDT