Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Ora - 27146

Re: Ora - 27146

From: Erwin Dondorp <erwindon_at_wxs.nl>
Date: Tue, 01 Feb 2000 22:44:46 +0100
Message-ID: <389753CD.D97833CA@wxs.nl>


John Woods wrote:
> [on errno=23]
> On Solaris 2.6, this error is caused by one of the kernel parameters for
> shared memory or semaphores not being set high enough. The installation
> manual has details on what these values should be (often specific to the
> platform). You may also find that reducing the resource requirements in the
> init.ora (processes=, and others) may be another way of fixing this
> problem...

Yes, that's true, but DerCommisar wrote that he has a HP-UX 9000 box. And now that I found an HP box with Oracle today, that box (after setting
to the insane value of 'processes=2000') shows:

	ORA-07279: spcre: semget error, unable to get first semaphore set.
	HP-UX Error: 28: No space left on device
	Additional information: 1

HP boxes say "No space left on device" if you run out of semaphores or shared memory.
This was HP-UX 10.20, Oracle 7.1.6.
Still, since UNIX boxes have a tendency to show weird errno's for some system calls,
"File table overflow" might alsi be given unce some other strange condition.

Erwin Received on Tue Feb 01 2000 - 15:44:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US