Oracle 10g and kernel

[nanan]

Hi
I would like to get the kernel parameters recommanded when i install oracle 10g on 11.23.
MC.SG 11.17 RAC will be installed..

Regards
nanan

[Julio Yamawaki]

Hi,

During the first phase of Oracle installation, the installer will test and tell you all patches and mininum kernel parameters. Swap will be tested also.
In fact, final parameters will depend on your application.


Regards,

[Steven E. Protter]

Shalom,

I recommend that vx_ninodes be set to at least 30,000 and that nproc maxuprc and related parameters be increased substantially depending on how big your database is an how connections it needs.

dbc_max_pct should be fixed a few numbers away from dbc_min_pct to prevent excessive changes on the system.

SEP

[Paul Sperry]

Julio is right.

Here is my 10g config if you wish to tune before installing

ksi_alloc_max (nproc*8)
max_thread_proc 1024
maxdsiz 1073741824 (1 GB)
maxdsiz_64bit 2147483648 (2 GB)
maxssiz 134217728 (128 MB)
maxssiz_64bit 1073741824 (1 GB)
maxswapchunks (PA-RISC only) 16384
maxuprc ((nproc*9)/10)
msgmap (msgtql+2)
msgmni (nproc)
msgseg 32767
msgtql (nproc)
ncsize (PA-RISC) (ninode+vx_ncsize)
ncsize (Itanium) (ninode+1024)
nfile (15*nproc+2048)
nflocks (nproc)
ninode (8*nproc+2048)
nkthread (((nproc*7)/4)+16)
nproc 4096
semmap (PA-RISC only) (semmni+2)
semmni (nproc)
semmns (semmni*2)
semmnu (nproc-4)
semvmx 32767
shmmax The size of physical memory or 1073741824 (0X40000000), whichever is greater.
Note: To avoid performance degradation, the value should be greater than or equal to the size of the SGA.

If you are using Hyper Messaging protocol as the cluster interconnect on PA-RISC systems, the value of this parameter must be less than 4 GB.

shmmni 512
shmseg 120
vps_ceiling 64

[Patrick Wallek · Accepted solution]

You should have a read through the Oracle installation documentation. That will tell you the patches you need to have installed and what the recommended setting for kernel parameters are.

Here is a link for the Oracle 10gR1 documentation. The docs for Oracle on HP-UX are on this page:

http://www.oracle.com/technology/documentation/database10g.html

Here is the link for "Oracle Database Installation Guide for UNIX Systems":

http://download-east.oracle.com/docs/html/B10811_05/toc.htm

Here is the link for "Oracle Database Quick Installation Guide for hp HP-UX Itanium":

http://download-east.oracle.com/docs/html/B13754_01/toc.htm