topic Re: Oracle fresh Install in Operating System - HP-UX

Oracle fresh Install

roadrunner_1 — Fri, 22 Nov 2002 18:07:31 GMT

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 id...it 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...

*****FULL POINTS WILL BE AWARDED TO CORRECT ANSWERS****

Re: Oracle fresh Install

Brian Crabtree — Fri, 22 Nov 2002 23:44:32 GMT

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.

Brian

Re: Oracle fresh Install

harry d brown jr — Sat, 23 Nov 2002 03:35:48 GMT

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

live free or die
harry

Re: Oracle fresh Install

Yogeeraj_1 — Sat, 23 Nov 2002 05:35:16 GMT

hi

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!
Regards
Yogeeraj

Re: Oracle fresh Install

Yogeeraj_1 — Sat, 23 Nov 2002 06:13:09 GMT

hi again,

one nice document that i hope will help...

http://h21007.www2.hp.com/dspp/files/unprotected/devresource/Docs/TechPapers/UXPerfCookBook.pdf

regards
Yogeeraj

Re: Oracle fresh Install

Robert Fedoruk — Mon, 25 Nov 2002 16:01:03 GMT

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