Home » RDBMS Server » Server Administration » Why to set shmmax value to 2GB while oracle installation
Why to set shmmax value to 2GB while oracle installation [message #137877] Sun, 18 September 2005 07:45 Go to next message
dnvs_praveen
Messages: 47
Registered: July 2005
Location: bangalore
Member
Hi

Can any one plz explain me the reason why we have to set shmmax value to 2GB while installation of Oracle. If i give lessthan or greater than 2GB instalation is getting failed. Exactly 2GB if i give then only installation is happening. What is the reason, Plz explain me.


sem value also we need to set to 400 32000 400 400, what exactly does this mean?


Thanks,
praveen

Report message to a moderator

Re: Why to set shmmax value to 2GB while oracle installation [message #137884 is a reply to message #137877] Sun, 18 September 2005 09:38 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://users.evitech.fi/~tk/rtp/multi-process.html#semaphores_whatis


SHMMAX = The maximum size(in bytes) of a single shared memory
segment.

SHMMAX

The SHMMAX parameter is used to define the maximum size (in bytes) for a shared memory segment and should be set large enough for the largest SGA size. If the SHMMAX is set incorrectly (too low), it is possible that the Oracle SGA (which is held in shared segments) may be limited in size. An inadequate SHMMAX setting would result in the following:

ORA-27123: unable to attach to shared memory segment

Report message to a moderator

Previous Topic: Perl applications not working on 9.2.0.6
Next Topic: Creating Control File
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 10:17:59 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.