Home » Infrastructure » Unix » unix
unix [message #367072] Wed, 25 October 2000 01:56 Go to next message
shekhar Babu
Messages: 1
Registered: October 2000
Junior Member
what are the parameters ( like shmmax etc) to be set on sun solaris before installing Oracle 8i
Re: unix [message #367073 is a reply to message #367072] Thu, 26 October 2000 06:38 Go to previous message
LG Jacobsson
Messages: 2
Registered: October 2000
Junior Member
Set to the sum of the PROCESSES parameter for each Oracle database, adding the largest one
twice, then add an additional 10 for each database. For example, consider a system that has three
Oracle instances with the PROCESSES parameter in their initsid.ora files set to the following values:

ORACLE_SID=DIA1, PROCESSES=100
ORACLE_SID=DIA2, PROCESSES=100
ORACLE_SID=DIA3, PROCESSES=200

The value of SEMMNS is calculated as follows:

SEMMNS = [[(A=100) + (B=100)]] + [[(C=200) * 2]] + [[(# of instances=3) * 10]] = 630

Setting parameters too high for the operating system can prevent the machine from booting up. Refer
to Sun Microsystems Sun SPARC Solaris system administration documentation for parameter limits.

*
* Kernel Parameters on our SUN Enterprise with 640MB for Oracle 8.1.6
*
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmns=2500
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767

/L-G
Previous Topic: Oracle 8.1.5 Solaris install
Next Topic: Re: Oracle/SCO UNIX Installation On DELL 6100
Goto Forum:
  


Current Time: Sun Sep 27 02:53:40 CDT 2020