Operating System - HP-UX
1748177 Members
4338 Online
108758 Solutions
New Discussion юеВ

Re: Oracle9i DB Kernel Recommendations?

 
SOLVED
Go to solution
KPS
Super Advisor

Oracle9i DB Kernel Recommendations?

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
11 REPLIES 11
Paul Sperry
Honored Contributor

Re: Oracle9i DB Kernel Recommendations?

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


Steven E. Protter
Exalted Contributor
Solution

Re: Oracle9i DB Kernel Recommendations?

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Yogeeraj_1
Honored Contributor

Re: Oracle9i DB Kernel Recommendations?

hi,

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

hope this helps!

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
twang
Honored Contributor

Re: Oracle9i DB Kernel Recommendations?

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
Ravi_8
Honored Contributor

Re: Oracle9i DB Kernel Recommendations?

Ravi_8
Honored Contributor

Re: Oracle9i DB Kernel Recommendations?

Ravi_8
Honored Contributor

Re: Oracle9i DB Kernel Recommendations?

Ravi_8
Honored Contributor

Re: Oracle9i DB Kernel Recommendations?

Ravi_8
Honored Contributor

Re: Oracle9i DB Kernel Recommendations?