Re: Q: How to reconfigure shared-memory segment size in Sun Solaris 2.5.1 kernel (SPARC)

htchen <htchen_at_ix.netcom.com> writes:

>Hi! I am running Oracle 7.3.2 on a Sun SPARC 10. While setting up for
>the first Designer/2000 repository, I modified the following init.ora
>parameters for a particular database server instance to the values
>shown:
 

> shared_pool_size = 18000000
> db_block_buffers = 1000
> global_names = FALSE
> open_cursors = 200
> processes = 50.
 

>However, when I tried to re-start the database server instance, the
>following message was returned to me:
 

> ORA-07331,smsnsg: unable to allocate the variable portion of the
>SGA.
 
>I assume I have to modify some parameters regarding shared-memory
>segments in the Solaris UNIX kernel. Can someone share any information
>on how to resolve this problem?
 

>Thanks in advance.

Hi,
you must change your /etc/system file! See Task1: Configure Kernel Parameters for Shared Memory (Oracle7 Installation Guide for Sun SPARC Solaris 2.x; 3-2). An example is:

set semsys:seminfo_semmni=450
set semsys:seminfo_semmns=1200
set semsys:seminfo_semmnu=1200
set semsys:seminfo_semume=400
set semsys:seminfo_semmsl=1200
set shmsys:shminfo_shmseg=240
set shmsys:shminfo_shmmax=268435456
set shmsys:shminfo_shmmni=1200
set shmsys:shminfo_shmmin=1

Best regards
Manfred Schulz

--
Manfred Schulz, Alcatel SEL AG Berlin, Department ACB/EO
Colditzstrasse 34-36, D 12099 Berlin, Germany           
Phone: +49-30-7002-3334  Fax: +49-30-7002-xxxx
Email: manfred.schulz_at_bln.sel.alcatel.de