Solved

Reconfiguring Solaris Kernel

Posted on 1997-06-12
6
1,549 Views
Last Modified: 2013-12-16
I'm installing Oracle 7 on Solaris 2.5.1.  Oracle requires several sared memory and semaphore parameters to be changed in /etc/system.  However, when I try to start Oracle, I get the following message:

Connected to an idle instance.
ORA-07331: smsnsg: unable to allocate the variable portion of the SGA.
 
07331, 00000, "smsnsg: unable to allocate the variable portion of the SGA."
// *Cause:  The variable portion of the SGA is too big to fit contiguously
//          into one segment.
// *Action: Reconfigure the UNIX kernel to have bigger segments.

What do I need to reconfigure to get this to work?
0
Comment
Question by:cybermuffin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 2

Expert Comment

by:pxh
ID: 1812408
Sorry for that naive question: but did you reboot after changing /etc/system? And what are the entries you made? Please post them here.

Peter

0
 

Author Comment

by:cybermuffin
ID: 1812409
Here are the changes required in the Oracle documentation.  And, yes I have rebooted (/usr/sbin/reboot -- -r).

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

0
 
LVL 2

Accepted Solution

by:
pxh earned 100 total points
ID: 1812410
I suggest that you increase the first number (shminfo_shmmax) to
e.g. 268435456 . This is a number the informix database installation suggested. You can play with (i.e. increase) the other numbers to. Remember they specify maximum values, the shared memory is not taken away automatically.

Good luck,

Peter

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:cybermuffin
ID: 1812411
Peter,

It didn't help.  Where can I get a list of the tunable parameters that can be used in /etc/system ?  

0
 
LVL 1

Expert Comment

by:hrumayor
ID: 1812412
pxd sugested a to large memory shminfo_shmmax he is sugesting you
a memory size 268 MB of memory, if you dont have alot of memory
dont, use such a large number, try a more decent number lets say
32 MB, any way if you configure a realy large shared memory it will end in your swap system, wat sugested cybermufing is correct
i am using oracle in solaris 2.5.1 with 192 MB of ram, i will send you my /etc/system

        set shmsys:shminfo_shmmax=32000000
        set shmsys:shminfo_shmmin=1
        set shmsys:shminfo_shmmni=100
        set shmsys:shminfo_shmseg=10
        set semsys:seminfo_semmap=250
        set semsys:seminfo_semmni=500
        set semsys:seminfo_semmns=500
        set semsys:seminfo_semmsl=500
        set semsys:seminfo_semmnu=500  
   
you have to boot the machine to get the parameters loaded
0
 

Author Comment

by:cybermuffin
ID: 1812413
All of the previous sessions didn't work.  I still get the same error.  Is there a utility to list what the kernel thinks these paramaters are set to?
0

Featured Post

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have been running these systems for a few years now and I am just very happy with them.   I just wanted to share the manual that I have created for upgrades and other things.  Oooh yes! FreeBSD makes me happy (as a server), no maintenance and I al…
Using libpcap/Jpcap to capture and send packets on Solaris version (10/11) Library used: 1.      Libpcap (http://www.tcpdump.org) Version 1.2 2.      Jpcap(http://netresearch.ics.uci.edu/kfujii/Jpcap/doc/index.html) Version 0.6 Prerequisite: 1.      GCC …
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question