Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

Oracle fresh Install

Go to solution
Regular Advisor

Oracle fresh Install

He experts,

This will be my first oracle installation. I have some questions;
1. File sytems - what kind of device, raw device or block device??
2. Important kernel parameters to look for before and afterinstallation.
3. User id and Group ID - any specific yes, why??
4. Installation steps

Any other tips which you guys think its important to look for??? Important link to documentation regarding Oracle on HP-UX will be appreciated...

Brian Crabtree
Honored Contributor

Re: Oracle fresh Install

1. Block devices are easier to use, and work well for most databases. Raw devices have to be used for OPS and RAC installations. I would recommend using block devices until you get used to normal administation.

2. shmmax (at least 1g)
maxdsize (at least 1g)
maxdsize_64bit (at least 1g)
maxssize (at least 120m)
maxssize_64bit (at least 120m)
maxtsize (at least 1g)
maxtsize_64bit (at least 1g)
dbc_min_pct 5
dbc_max_pct 8-10
maxfiles (at least 200)
maxusers (at least 100)
semmni (at least 64)
semmns (at least 200)

3. Normal user is "oracle" and the default group should be "dba". This can be set to whatever you want though.

4. Install Oracle software. Patch Oracle software to highest release. Create Oracle database using dbca or homemade scripts (many people have posted scripts you can use on here).

I would suggest getting a technet and metalink account with Oracle. Technet holds the documentation for oracle versions, and metalink is a knowlege base for issues that can occur. Both are good sources for information.

harry d brown jr
Honored Contributor

Re: Oracle fresh Install

Follow your "pfs" mount commands as directed in the oracle documentation!

live free or die
Live Free or Die
Honored Contributor

Re: Oracle fresh Install


One common problem encountered by most during the installation is the mounting and unmounting of cds.

try my script for both mounting and unmount the CDROM (in case it is already mounted)

Hope this helps!
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Honored Contributor

Re: Oracle fresh Install

hi again,

one nice document that i hope will help...

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Robert Fedoruk
Occasional Visitor

Re: Oracle fresh Install

a tip for accessing the CD's is to create 2 directories ie disk1 and disk2 and copy the contents of the each Oracle install cd. You can run the install from disk1 and when asked point to disk2. Another tip is allow the wizard to create the scripts for creating a db, then edit the scripts located at %oracle_home%\assistants\dbca