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: unable to attach sga

Re: unable to attach sga

From: Gocha Mchedlishvili <gocham_at_cwix.com>
Date: Wed, 21 Jul 1999 02:15:37 GMT
Message-ID: <d3al3.140$z6.5599@news.cwix.com>


Hi,
I might be wrong because I haven't played with Solaris kernel settings for a long while, but I think that SGA must fit in 1 continious segment, try to reduce shminfo_shmseg setting.

Gocha

rpereira_at_my-deja.com wrote in message <7n1v9k$sh9$1_at_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 - 21:15:37 CDT

Original text of this message

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