OraFAQ Forum: Unix

Home » Infrastructure » Unix » unix

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

unix [message #367072]

Wed, 25 October 2000 01:56

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

Report message to a moderator

Re: unix [message #367073 is a reply to message #367072]

Thu, 26 October 2000 06:38

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

Report message to a moderator

Previous Topic:	Oracle 8.1.5 Solaris install
Next Topic:	Re: Oracle/SCO UNIX Installation On DELL 6100

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 03 04:18:49 CDT 2025