Re: unable to attach sga

From: <rpereira_at_my-deja.com>
Date: Tue, 20 Jul 1999 13:58:21 GMT
Message-ID: <7n1v9k$sh9$1@nnrp1.deja.com>

In article <7n1rf9$qqn$1_at_nnrp1.deja.com>, Tony Adolph <tony.adolph_at_viaginterkom.de> wrote:
> Hello there,
>
> I could be wrong here because my Solaris is a bit rusty, but check the
> kernel settings for shared memory and semaphores i.e. shmmax, smhmin
> etc in /etc/system.
> >
> > ORA-07307: sms1sg: shmat error, unable to attach sga.
> > SVR4 Error: 22: Invalid argument
> >
>
> hope thats helpful,
>
> Regards
> Tony
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Hello,
the kernel settings for shared memory are:

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

It works if I set the shared_pool = 130000000, so I think the settings are correct.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 20 1999 - 08:58:21 CDT