Oracle9/Redhat9: How do I PERMANTENTLY change the values of SEMMSL, SEMMNS, SEMOPM...

Posted on 2004-04-27
Medium Priority
Last Modified: 2012-05-04

How do I PERMANTENTLY change the values of SEMMSL, SEMMNS, SEMOPM, SEMMNI, SHMMAX, SHMMNI, SHMALL?  I already know that "echo > value, value, value, value" will change the values temporarily, until next startup.  However, I read somewhere that I have to put the values into some kind of "init" file.  Anyway, any info would be appreciated.

Question by:itorbust
  • 2
LVL 23

Accepted Solution

seazodiac earned 80 total points
ID: 10932458
you have made the changes into /etc/sysctl.conf

use this format:

echo "kernel.shmmax=2147483648" >> /etc/sysctl.conf

others will be the same.
LVL 23

Expert Comment

ID: 10932467
another example for semaphores;

echo "kernel.sem=250 32000 100 128" >> /etc/sysctl.conf

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

621 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