topic Re: Loading Oracle, getting HP-UX error:28 in Operating System - HP-UX

Loading Oracle, getting HP-UX error:28

Leo Cusson — Tue, 22 Feb 2000 13:57:58 GMT

I have place the default parameters for the semaphore, there is one exception,
could not find "shmmin". Here is the error;

[oracle] cd dbs
[oracle] svrmgrl
Oracle Server Manager Release 3.0.5.0.0 - Production
(c) Copyright 1997, Oracle Corporation. All Rights Reserved.
Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.5.0.0 - Production
SVRMGR> connect internal
Connected.
SVRMGR> startup nomount pfile=initorcl.ora
ORA-07279: spcre: semget error, unable to get first semaphore set.
HP-UX Error: 28: No space left on device
Additional information: 200
Additional information: 2
SVRMGR> exit
Server Manager complete.
[oracle]
[oracle]
[oracle] oerr ora 7279
07279, 00000, "spcre: semget error, unable to get first semaphore set."
// *Cause: An error occurred when trying to get first semaphore set.
// *Action: Check errno. Verify that system is configured to have semaphores.
// Verify that enough semaphores are available. Additional
information
// indicates how many semaphores were requested.
[oracle]

Here is what I did with the semaphores;

Modified Kernel Configuration Parameters (pg 2-5)
recommended
Name was oracle Description
semmni 64 70 Number of Semaphore Identifiers
semmns 128 200 Max Number of Semaphores
shmmax 67108864 1073741824 Max Shared Mem Segment
shmmni 200 100 Number of Shared Memory Identifiers
shmseg 120 10 Shared Memory Segments per Process

Any suggestions what my problems is???

Re: Loading Oracle, getting HP-UX error:28

Jim Donovan_1 — Tue, 22 Feb 2000 18:23:32 GMT

Run the command 'ipcs -sa' and total the numbers in the NSEMS column. Add to
that number the value of the processes parameter from the init.ora files for
each database you have on that server. Set the semmns kernel parameter to this
number at a minimum.

Better yet do what I've done, using SAM, navigate to the Configurable
Parameters area under Kernel Configuration and 'Apply a Tuned Parameter Set'
appropriate for your environment. You can tweak your kernel settings from
there and be fairly confident that you won't encounter this type of error
again.

Re: Loading Oracle, getting HP-UX error:28

Chris Anoruo_1 — Thu, 09 Mar 2000 04:58:42 GMT

Hi Leo,

The way to go about resolving this issue is configuring your kernel share
memory items to larger values. You can also read these topic from the IT
resource Center: "Oracle: configuring Oracle 8.0.5 on an HP-UX 10.20 system"
and "Understanding Shared Memory on PA-RISC Systems".
You can also look at my attached kernel configuration from my K580 server.