Re: How to reconfigure shared-memory segment size in Sun Solaris 2.5.1 kernel (SPARC)
From: Anbazhagan.G <anbu1_at_mbox3.singnet.com.sg>
Date: 1997/07/05
Message-ID: <01bc893c$677e3a20$1ab915a5_at_default>#1/1
> 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.
>
Received on Sat Jul 05 1997 - 00:00:00 CEST
Date: 1997/07/05
Message-ID: <01bc893c$677e3a20$1ab915a5_at_default>#1/1
Hi ,
You have to modify Shared memory related configuration parameters (
SHMSEG, SHMMAX, SHMMIN ). Before you do this make sure you have so much
memory. ( fortunately you did not try this is sybase system 10 . You would
have had to work for a week end to get back to normal status if the
database is big )
You will have to rebuild the unix kernel after changing the parameters and
reboot . Better ask your system administrator if you are not holding root
password.
Regards
Anbu
htchen <htchen_at_ix.netcom.com> wrote in article <33B70AC5.38BA_at_ix.netcom.com>...
> 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.
>
Received on Sat Jul 05 1997 - 00:00:00 CEST