Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: installation on solaris (help).
On 4 Dec 1998 01:12:35 GMT, manuk_at_gradine.cis.upenn.edu (Manu
Kambhampati) wrote:
>I am getting the following when I try to startup a database after
>installation using svrmgrl (oracle 7.3 server). If anyone can
>decipher this I would be greatful ...
>
>thanks
>Manu.
>
>Oracle Server Manager Release 2.3.2.0.0 - Production
>
>Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
>
>Oracle7 Server Release 7.3.2.3.0 - Production Release
>PL/SQL Release 2.3.2.3.0 - Production
>
>SVRMGR> connect internal
>Connected to an idle instance.
>SVRMGR> startup nomount pfile="initr2do2.ora"
>ORA-07331: smsnsg: unable to allocate the variable portion of the SGA.
>Additional information: 4
>SVRMGR>
You're getting this error because you have not properly configured the
shared memory on your server for the size of your SGA. You need to
increase the size of the UNIX system parameter SHMMAX to a value
greater than the size of the SGA.
For reference:
Calculating SGA and SHMMAX
- - - - - - - - - - - - -
The value of SHMMAX should not exceed one third of the system's
physical RAM for optimum performance, but the entire SGA should be
less than the value for SHMMAX.
The amount of shared memory (SHMMAX) Oracle needs for SGA can be estimated using init.ora parameters as follows:
(<db_block_size> x <db_block_buffers>) # Size of DB block buffers
times the number of buffers + <log_buffer> # Redo log buffers + <shared_pool_size> # Shared buffer pool+ <1MEG extra space>
Thanks!
Joel
Joel R. Kallman Oracle Government, Education, & Health
Columbus, OH http://govt.us.oracle.com jkallman@us.oracle.com http://www.oracle.com