Creating Mount points for Oracle 8.1.5

[darnnell]

Can anyone provide some detailed suggestions on creating the software and database mount points for an oracle install. I have never done this before and the install manual leaves too many steps out.

Also, is there a patch bundle that's needed for this particular install?

If anyone has a user friendly version of how to continue with this install, I would greatly appreciate it. Thanks.

[Rick Garland]

For creating the mount points, just the usual vgcreate and lvcreate commands.
Configure the Oracle to look for these mount points.

Do spread out the database mounts across different filesystems. Example, logs on a FS, the data files on another FS, etc...

[Victor BERRIDGE]

Hi,
Here is how I usually proceed:
/dev/r5vg02/lvol5 512000 125190 363153 26% /var/opt/oracle
/dev/r5vg02/lvol6 409600 266875 133868 67% /var/opt/app/budget
/dev/vg00/lvol7 614400 458703 146024 76% /usr
/dev/r5vg01/lvol8 409600 122663 269062 31% /tmp2
/dev/vg00/lvol6 102400 38236 60244 39% /tmp
/dev/vg00/lvol9 102400 59143 40604 59% /sm
/dev/vg00/lvol5 716800 484167 218169 69% /opt
/dev/r5vg02/lvol1 462848 45200 391633 10% /opt/tuxedo
/dev/r5vg01/lvol1 409600 48261 339033 12% /opt/oracle
/dev/r5vg03/lvol2 1335296 1161086 163377 88% /opt/oracle/product/8.1.5
/dev/r5vg01/lvol10 1126400 693710 405723 63% /opt/oracle/product/8.0.5
/dev/r5vg01/lvol2 1126400 710474 389985 65% /opt/oracle/product/8.0.4
/dev/r5vg02/lvol12 327680 288873 36383 89% /opt/oracle/product/7.3.3
/dev/r5vg01/lvol6 307200 164509 133778 55% /opt/natstar
/dev/r5vg02/lvol11 155648 121399 32742 79% /opt/ars
/dev/r5vg01/lvol5 409600 1205 382878 0% /opt/app/budget
/dev/vg00/lvol4 102400 46874 52267 47% /home
/dev/r5vg02/lvol2 102400 97592 4680 95% /home/patrol
/dev/r5vg02/lvol8 3584000 3089912 465761 87% /data/mnt6
/dev/r5vg01/lvol7 3584000 3202149 357988 90% /data/mnt5
/dev/r5vg02/lvol4 3584000 3072218 484534 86% /data/mnt4
/dev/r5vg01/lvol4 3584000 3439443 136471 96% /data/mnt3
/dev/r5vg02/lvol3 3584000 3160132 397436 89% /data/mnt2
/dev/r5vg01/lvol3 3584000 3276800 288123 92% /data/mnt1

That means all logs etc in /var/opt/oracle
all the datafiles in /data/mntXX
the different versions in /opt/oracle/product/

Regards
Victor

[Antoanetta Naghiu]

The mount points themself, mkdir /u01, mkdir /whatever. After you already decided how your layout of the disk looks like, create the volume groups if required, create logical volumes and make the new file system there (see vgcreate, lvcreate, newfs). Mount them to /u01 or /whatever mount point (=directory) you've previously created for this. As well, you can use sam to get here.
If you want to use raw partition for database, them, stop after create the logical volume. Do not forget to change the ownership of the /dev/vgxx/lvoln to oracle:dba.
Hope this helps.

[CHRIS_ANORUO]

Hi Darnnell,

The best way for you to start is call in an expert and understudy him/her for the basics will you take notes as you ask questions. These things are not done on the fly. Be careful about such implementations!

Best Regards

Chris

[Vince Arends]

Darnnell, I have seen previous postings in the HP forums regarding what patches people have applied to try to get Oracle to work on HP-UX 11.0. Do a search in the Forums area of HP for Oracle. Different versions of Oracle probably require different patches to be applied. Also, if you have access to Oracle's MetaLink, that might be some place you want to check. (We have Oracle 8.0.5 running on HP-UX 11.0). If this is your first Oracle install, I agree to get some help with it, but, be careful of the "experts" you get. Good luck.

[Neale Machin]

We're currently setting up 8.0.5 and have been advised by ORACLEto install patch bundle 8.0.5.21 (Note there are 32bit and 64 Bit versions of this patch )
As for setting up directory structures that is machine specific dependant on how many disks you have/ mirroring strategy . Try to keep your data indexes and redo logs all on seperate disks if you can