Re: Space problem when running two db at the same time (question)

On 10 Jul 1995, wei he (martletts) wrote:

> Hi
>
> I tried to run two databases at the same time but got a problem. Hope someone
> can give me a help.
>
> Basically, when I start up another instance without shut down the one running, I
> got a error message as follow:
>
> CAUTION
>
> ORA-07279: spcre: semget error, unable
> to get first semaphore set.
> SunOS Error: 28: No space left on device
> Additional information: 2
>
>
> Orcale support said this is a problem with space on the platform. In fact
> the hard disk which conatins all the files (data file, control file etc)
> for the two database still has a lot of space (more than 500 M). I don't
> understand which space that the error message was talking about.
>
>
> Thanks advance.
>
> Wei
> etlwihe_at_etlxdmx.ericsson.se
>

	The problem is not disk space so much as space reserved by
	the kernel for semaphores, which I think have something to
	do with interprocess communications.  Have your system 
	administrator reconfigure the kernal.  Refer to your 
	platform-specific documentation under 'semaphores' for
	more info.  In our book, it refers to parameters:
		SEMMNI - max semaphore sets on system
		SEMMSL - max semaphores per set
		SEMMNS - max semaphores system-wide
		SEMMNU - max undo structures.
	The last time we had this error, I think we increased
	SEMMNI and SEMMNS.

	Good Luck!

	helena

--
<:>-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<:>
<: Helena Whitaker, Database Administrator      helena_at_creighton.edu :>
<: Creighton University               (0800-1630 CT)   (402)280-2311 :>
<: Old Gym - 2500 California Plaza                fax  (402)280-2573 :>
<: Admin Computing-Fin Sys Spt          Platform: HP-UX 9.0.4 (unix) :>
<: Omaha, NE 68178-0046              HP 9000/887 (aka H50), 842, 806 :>
<:                               Oracle 7.1.3.2/Banner Finance 2.0.3 :>
<:                          Oracle 7.1.3.2/DeLair Patient Accounting :>
<:>-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<:>