Re: HELP: ORACLE 7.1 under Solaris 2.5

Markus Hasleder wrote:
>
> When Starting ORACLE 7.1 under Solaris 2.5 the Database give
> this error:
>
> >ORA-7331: smsnsg: unable to allocate the variable portion of
> >the SGA.
> >Additional information: 4
>
> Can anybody translate this errormessage or advise us, how to
> deal with this error?
>
> Has anybody access to the platform-specific ORACLE 7
> Server-manuals and will send us the error explanation?
>
> Thank you in advance. It's urgent.
>
> Markus Hasleder
>
> Please reply also by mail.
> -------------------------------------------------------------
> Forschungsgesellschaft fuer Informatik
> Vienna University of Technology tel +43/1/58801/4554
> Treitlstr. 3 fax +43/1/58801/4598
> A-1040 Wien email mhaslede_at_fgidec1.tuwien.ac.at

Your parameters in /etc/system are not set right.

You need to configure to the kernel to have a bigger segment size for shared memory segments.

Here is a sample /etc/system

set shmsys:shminfo_shmmax=786432000
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=50
set semsys:seminfo_semmns=500
set semsys:seminfo_semmni=70
set semsys:seminfo_semmsl=200

Mark Johnson
GE Capital Received on Thu Sep 05 1996 - 00:00:00 CEST