Re: ORA-7331 on SunOs

Anna B. Sotnichenko wrote:
>
> What should I do after receiving an error message:
>
> ORA-7331: smsnsg: Unable to allocate the variable portion of the
> SGA
> additional information: 4
>
> This trouble happened when I was trying to install Oracle 7.2 Enterprise
> Server for Sun Solaris 2.4 on SunOs 4/5. More exactly - this error
> occurred during attempt to create the initial database instance. This
> software has come with Oracle Web Evaluation CD.
> All required patches were previously installed. The description of the
> error is following:
>
> Cause: The variable portion of the SGA is too big to fit continuously
> into one segment.
>
> Action: Reconfigure the UNIX kernel to have bigger segments. See
> the "Oracle System Architecture" chapter for additional information.
> (this description is taken from on-line documentation)
>
> Is it true that:
> 1) SunOs 5/4 = Sun Solaris 2.4
> 2) SunOs Kernel cannot be reconfigured without a lot of headache?
>
> I'll be very glad to hear from you
> Anna.

Oracle 7 on Sun allow only one segment configuration (it means whole SGA should fit one memory segment). If you don't want to decrease SGA size, you need to do is:
Increase shared memory size in /etc/system file For example:
set shmsys:shminfo_shmmax=262144000
(for 250 Mb)
After that reboot a machine like
sync
sync
init 0
boot -r

Note: Configuration of kernel parameters you can find in Oracle Server Installation Manual for Solaris 2.x . In addition check out semaphor parameters.

Hope it helps,

Eugene.

-- 
********************************************************
*        Everything above is only my opinion           *
********************************************************
*						       *
* If you see a lion in a cage and sign says "elephant" * 
*                      ,                               *
*           DO not belive your eyes !                  *
*       (Kozma Prutkov. (informal translation))        *
*                                                      *
********************************************************