Re: HELP: ORACLE 7.1 under Solaris 2.5

Mark Johnson (mwc.mjohnson_at_capital.ge.com) extrapolated:
: 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?
: >
:
: 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
:
: The first parameter is the largest segment size, thats probably the one you
: need to change.
:
: This should fix you problem.
:
: Mark Johnson
: GE Capital

Well Mark is running one hell of a system with settings that high!

To calculate the size of the SGA:

(db_block_buffers X db_block_size)
+ sort_area_size + shared_pool_size + 1MB = SGA size

Or if you could start sqldba you could do a "show sga"...

The defaults for Solaris 2.5 and Oracle 7.1 are:

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

The maximum size of a single shared memory region is the parmeter SHMMAX. If the size of the SGA exceeds the max size of a shared memory segment, Oracle will attempt to attach more contigous segments to fulfill the requested SGA size. SHMSEG is the max number of segments that can be attached by a process.

So calculate your SGA then increase your SHMMAX to be greater than the SGA to be safe. SHMMAX should be set to its max value on systems where its size is limited.

See chapter 3 of the ICG for more info!

             \\/////		Cheers
             |     |		    
             (.) (.)
==========oOO==(_)==OOo=================================================
Tony Middleton                         E-Mail: coredump_at_dimensional.com     

  "How much deeper whould the world's oceans be if sponges didn't    live there?" - Steven Wright Received on Fri Sep 06 1996 - 00:00:00 CEST