Help with enabling large file on an ls 9000 hpux 11.0

[Andrew Porter]

How in this done?

We are running oracle 8.17 and thye database size will exceed 500 gig... personally I don't want to create 250 files to store this data in...

[harry d brown jr]

500GB? This is when you just give the DBA's a list of RAW devices to use.

or go into sam create your filesystem and turn on largefiles.

live free or die
harry

[Andrew Porter]

Sorry, I am a HPUX newbie...

Not quite understanding the lingo. Basicall we already have or drives setup, we need to change them from the 2 gig max. Do we need to format the dirve and change the file system? or is there just a switch that we can flip to allow use to create larger files?

[Victor BERRIDGE · Accepted solution]

Hi,
lets say youve created a logical volume of 100 GB (just for the the pleasure as would do clay if he had 2 drives to use in the SAME volume group):
lvcreate -i 2 -I 64 -L 100000 -n lvolXX /dev/r5vg01 ( I prefix r5 so I know Im on RAID 5...)

To create the files system for large files:
newfs -F vxfs -o largefiles /dev/r5vg01/rlvolXX

Good luck

Victor

[MANOJ SRIVASTAVA]

Andrew

and if you ahve already created it and want to change it to the large files options then


mkfs -m < mount point > to know what it is curretn

and

fsadm -o largefiles to cahnge it on the fly if you ahve online JFS installed.

Manoj Srivastava

[Mike Hassell]

Andrew,

Here's the lowdown on what Harry is referring to. There are different methods of giving Oracle the access to the devices it needs to store data.

1. Mounted filesystems, which I'm assuming that you're currently trying to use. For example, a VxFS filesystem.

2. Raw devices, which are lvol pointers to raw devices that do NOT contain a filesystem. Oracle will maintain it's own filesystem with this method.

To change the large files options on the mounted VxFS mount points you currently have you'll need an additional product called "OnlineJFS", otherwise you'll have to recreate those mount points. To check if you have this product installed, check for the following binary:

/usr/sbin/fsadm

If it's there, you can use it with the following syntax:

fsadm -F vxfs -o largefiles

if you don't have OnlineJFS, you'll need to recreate these filesystems, for example:

newfs -F vxfs -o largefiles

Take a look at the following text file on your system for more info:

/usr/share/doc/lg_files.txt

and for supported file sizes and such:

http://docs.hp.com/hpux/onlinedocs/5971-2383/5971-2383.html

Since you are going to exceed 500GB, you may want to look at going the raw route as your performance may be better in the long run. Be sure to read "Oracle Server
Tuning" manual, Sever Installation Guide for HP (contains the chapter
describing raw devices) and http://technet.oracle.com for more info on what would be the best configuration for you.

Hope that helps.

-Mike