topic Re: Oracle9i DB Kernel Recommendations? in Operating System - HP-UX

Oracle9i DB Kernel Recommendations?

KPS — Thu, 17 Jul 2003 19:37:26 GMT

All,

Looking to see if there is some sort of doc that
gives the kernel recommendations for an Oracle9i
Database. We have just built a system that will have a DB of Oracle 9i on it and we just don't have what the kernel paramaters should be for it.

On a separate note, we were able to get from Oracle the OS Patches that we needed for the 9i Database.

Tks,
-Ken

Re: Oracle9i DB Kernel Recommendations?

Paul Sperry — Thu, 17 Jul 2003 19:46:44 GMT

In the insallation guide found here are recommended kern params.

http://otn.oracle.com/documentation/oracle9i_arch_901.html

near the end of the page

Oracle9i Database Release 9.0.1 Documentation for HP 9000 Series HP-UX

Re: Oracle9i DB Kernel Recommendations?

Steven E. Protter — Thu, 17 Jul 2003 20:17:29 GMT

Two things:

1) Here is a working 11i kernel(attached).
2) A document on performance tuning, which you will need to do with this product.
http://www2.itrc.hp.com/service/cki/search.do?category=c0&docType=Security&docType=Patch&docType=EngineerNotes&docType=BugReports&docType=Hardware&docType=ReferenceMaterials&docType=ThirdParty&searchString=UPERFKBAN00000726&search.y=8&search.x=28&mode=id&admit=-1335382922+1058476554301+28353475&searchCrit=allwords

SEP

Re: Oracle9i DB Kernel Recommendations?

Yogeeraj_1 — Fri, 18 Jul 2003 03:34:50 GMT

hi,

see also the "HP-UX Quick Start Guide - 9.2.0 RDBMS Installation" note from metalink (attached).

hope this helps!

regards
Yogeeraj

Re: Oracle9i DB Kernel Recommendations?

twang — Fri, 18 Jul 2003 04:18:19 GMT

You should pay special attention on the init.ora parameter changes.

Init.ora Parameter Unix Kernel Parameter
----------------------------------------------
db_block_buffers shmmax
db_files (maxdatafiles) nfile, maxfiles
large_pool_size shmmax
log_buffer shmmax
processes nproc, semmsl, semmns
shared_pool_size shmmax