topic Re: Installing Oracle in Operating System - HP-UX

Installing Oracle

khilari — Tue, 30 Oct 2007 09:29:12 GMT

Hi guys, i have to install oracle and i wanted to know the following?
1). What kernel parameters should i be concerned about while installing oracle.?
2)when i am installing oracle which filesysytem sizes should i have atleast in vg00?
3) any other concerns i might have before i start installing it?
Thanks

Re: Installing Oracle

Patrick Wallek — Tue, 30 Oct 2007 09:34:43 GMT

Read the Oracle installation documentation. You should find answers to most of your questions there.

Re: Installing Oracle

P_F — Tue, 30 Oct 2007 09:40:42 GMT

There are many, but you ought to be aware of these two: nfile, nflocks.

(15*nproc+2048)Í¾ for Oracle installs with a high number of data files maybe not enough, use (number of Oracle processes)*(number of Oracle data files) + 2048

and

nproc At least 4096.

---------------

Those are well accepted guidelines I've used, derived from http://www.oracle.com/technology/documentation/index.html

Re: Installing Oracle

David Bellamy — Tue, 30 Oct 2007 09:47:20 GMT

Before installing make sure you have all of the patches that oracle requires.

Re: Installing Oracle

Court Campbell — Tue, 30 Oct 2007 12:52:31 GMT

I am with Patrick on this. You can get this info at the Oracle site. I will mention that the documentation is lacking. They really have not updated it for 11.23 and later. It still mentions kernel parameters that do not exist and mentions patches for older HP-UX versions (< 11.23). I mainly always notice 11.00 patches listed. And more than likely even though you have done all the setup according to the docs, you will more than likely still see exceptions.

Re: Installing Oracle

TwoProc — Tue, 30 Oct 2007 13:12:36 GMT

Unfortunately, a big part of being an Oracle DBA is the tenacity to go and dig and find all of the documents related to whatever project(s) you're working on. It's a mess, really - but you're options are... none.