| 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
|
|
|
|
| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
