Re: starting multiple instances under Solaris

From: Mike Mountjoy <michael_at_london.virgin.net>
Date: Tue, 20 Apr 1999 12:06:17 +0100
Message-ID: <7fhn3e$jt9$1@nclient3-gui.server.virgin.net>

It could well that the size you have set for shmsys:shminfo_shmmax in /etc/system (UNIX) may to be big to allow to instances to run together.

        set shmsys:shminfo_shmmax=16000000
        set shmsys:shminfo_shmmin=1
        set shmsys:shminfo_shmmni=100
        set shmsys:shminfo_shmseg=10
        set semsys:seminfo_semmns=400
        set semsys:seminfo_semmni=100
        set semsys:seminfo_semmsl=200

try reducing the shmmax to say 4000000 and try again (need to re-boot) the machine.

Regrds,
Mike

Thomas Lohman <thomasl_at_mtl.mit.edu> wrote in message news:7fg78j$fit_at_senator-bedfellow.MIT.EDU...
> Hi, I've managed to create a second database but am having trouble
> starting the second instance. I have the original database instance
running
> and here is the error I get when attempting to start the second:
>
> 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
> SVRMGR> quit
>
> What am I missing and/or doing wrong? It seems that Oracle may be trying
> to allocate shared memory segments and semaphores but they're already
taken
> when the original instance started up?
>
> If anyone can offer some help, I'd be thankful.
>
> thanks very much,
>
>
> --tom
> thomasl_at_mtl.mit.edu
Received on Tue Apr 20 1999 - 06:06:17 CDT