Re: SVRMGR Errors

From: Thomas George <ygguh_at_aol.com>
Date: 2000/04/05
Message-ID: <q1imes8gn4l0offe834gtukp5r5vdd0ktl@4ax.com>#1/1

I have a similar problem, I receive the following error:

SVRMGR> connect internal
Connected.
SVRMGR> startup
ORA-07279: spcre: semget error, unable to get first semaphore set. SVR4 Error: 28: No space left on device
Additional information: 25
Additional information: 2

My /etc/system file contains:

set shmsys:shminfo_shmmax=1073741824
set shmsys:shminfo_shmmin=10
set shmsys:shminfo_shmmni=128
set shmsys:shminfo_shmseg=256
set shmsys:seminfo_semmni=128
set shmsys:seminfo_semmsl=100
set shmsys:shminfo_semmns=1000

* End Oracle environment info

But I receive the following errors in my /var/adm/messages file:

Apr 4 18:05:37 typhoon unix: sorry, variable 'seminfo_semmni' is not defined in
 the 'shmsys'

Apr  4 18:05:37 typhoon unix: module
Apr  4 18:05:37 typhoon unix:
Apr  4 18:05:37 typhoon unix: sorry, variable 'seminfo_semmsl' is not

defined in
 the 'shmsys'

Apr  4 18:05:37 typhoon unix: module
Apr  4 18:05:37 typhoon unix:
Apr  4 18:05:37 typhoon unix: sorry, variable 'seminfo_semmns' is not

defined in
 the 'shmsys'
Apr 4 18:05:37 typhoon unix: module

Is the actual entry in the /etc/system file: set semmni 70 or
semmni 70 or
set semmni=0 or
what?

My system is a Ultra1, w/ 512 megs ram, 9 gig hd, 1.2 gig swap/tmp and Oracle 8.0.0.0.5 (My DBA gave me the Oracle version number)

Any help would be appreciated.

On Wed, 29 Mar 2000 19:41:35 -0700, "Rob Calfee" <trace_at_primenet.com> wrote:

>Alan,
>
>My guess is that you are running oracle on a UNIX platform of some kind.
>Did you check the semaphore settings of the server to make sure that oracle
>has enough shared memory, undo structures, etc? On Sun (2.51, 2.6) the
>settings are at /etc/system. The default settings should be close to or
>above the following(for Sun):
>
>semmni 70
>semmns 200
>semmnu 64
>semume 64
>shmmax 12582912
>shmmin 1
>shmmni 100
>shmseg 10
>
>Try these settings, reboot the server, and try bringing your instance up
>again. Let me know.
>
>Rob Calfee
>Systems Consultant
>Quest Software
>602-741-9419
>520-421-2734/7124
>rcalfee_at_quest.com
>www.quest.com
>
>
>Alan C. Byrd <alan.byrd_at_media.net> wrote in message
>news:38E27B84.270D5B94_at_media.net...
>> When at the prompt of svrmgr> I type startup open <orasid>, but I am
>> returned the error of Unable to attach to shared memory; permission
>> denied.
>>
>> Any clues on how to get permission so that I can start the database? I
>> have 5 manuals here on installation and administration. I have followed
>> them to the letter, but still no luck.
>>
>> Please Help!!
>
Received on Wed Apr 05 2000 - 00:00:00 CDT