Re: Red Hat ES4. 0 kernel settings

On 10/20/05, Lou Avrami <avramil_at_concentric.net> wrote:
> Hello all,
>
> I'm about to do my first Linux Oracle RDMBS installations. I'll be installing both 9.2.0.7 and 10gR2 on a Red hat ES 4.0 server with 4 gig of memory.
>

Lou,

start here:

http://www.puschitz.com/InstallingOracle10g.shtml

Paul

> As with most other Unixes, the kernel settings must be adjusted. The "defaults" would be something like
>
> SHMMAX = 2147483648
> SHMMIN = 1
> SHMMNI = 100
> SEMMNS = 1000
> SEMMSL = 250
> SEMMNI = 100
> SEMOPM = 100
>
> In Solaris, I had quite a bit of successful following the advice in the book "Configuring & Tuning Databases on the Solaris Platform". On pages 202-204 the author suggests setting the shared memory parameters high, so that it isn't necessary to go back and change them later. An example /etc/system from the book looked like this:
>
> * Semaphore parameters
> set semsys:seminfo_semmap = 1026
> set semsys:seminfo_semmsl = 300
> set semsys:seminfo_semmns = 2500
> set semsys:seminfo_semmnu = 2500
> set semsys:seminfo_semume = 2500
> set semsys:seminfo_semmni = 2500
> set semsys:seminfo_semopm = 150
>
> * Shared memory parameters
> set shmsys:shminfo_shmmax=0xFFFFFFFF
> set shmsys:shminfo_shmmni=1024
> set shmsys:shminfo_shmseg=1024
>
> I think I would like to do something similar for this Linux server, set the semaphores and shared memory parameters high enough so that they don't have to be revisited. Does this make sense for Linux? For Solaris there is no penalty for for stting these parameters "too high". Does that also hold true for Linux? For the Linux kernel parameters, what might be considered "high enough"?
>
> Thanks,
> Lou Avrami
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l