?
Solved

Reconfiguring Solaris Kernel

Posted on 1997-06-12
6
Medium Priority
?
1,551 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 200 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
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Let's say you need to move the data of a file system from one partition to another. This generally involves dismounting the file system, backing it up to tapes, and restoring it to a new partition. You may also copy the file system from one place to…
FreeBSD on EC2 FreeBSD (https://www.freebsd.org) is a robust Unix-like operating system that has been around for many years. FreeBSD is available on Amazon EC2 through Amazon Machine Images (AMIs) provided by FreeBSD developer and security office…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.
Suggested Courses
Course of the Month12 days, 23 hours left to enroll

777 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