Re: Error ORA-00020, ORA-00600

From the message, it appears that your system does not have enough semaphores configured. Oracle requires a semaphore for each dedicated server process that connects to the database.

Off the top of my head, I can't remember the exact kernel parameter that you'll need to modify. Consult your O/S documentation. You'll need to regen the kernel and then reboot.

Michael Schwantge <mschwantge_at_piag.com> writes:

> I am using a SUN Ultra Enterprise 1 with 128 MB memory and Oracle 8. My
> programm and its children are using several connections to the database
> and the error ora-00020 occurs. The number of processes in the
> initDB.ora is set to 25, after setting processes to 30 my programm works
> better, but the error occurs again. Any number above 30, the database
> could not start; the message is:
> ORA-00600: internal error code, arguments: [SKGMBUSY], [1], [0], [0],
> [0], [], [], []
> ORA-07279: spcre: semget error, unable to get first semaphore set.
> SVR4 Error: 28: No space left on device
> Additional information: 100
> Additional information: 2
> Additional information: -268445772
>
> Thanks a lot for your help, Michael.
>

--

                                Rick
                                Rick Wessman
                                Server Security Group
                                Oracle Corporation
                                rwessman_at_us.oracle.com

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.