Moving directories out of root file system.

[david smith_11]

hello all,

hp-ux 11.00 64bit
oracle 8.1.7.4
SAP R/3 4.6C

i have come to upgrade my oracle 8 to 9i only to find my /oracle dir has a mount point of /. a consultants work some years ago has come back to haunt us! my root filesystem has not got the required freespace to continue the upgrade. am i right in thinking i will have to :

a) use ignite to make a boot tape vg00 and use this to reconfigure the root filesystem size.

b) fbackup my system. remove all lv's and recreate. then frecover.

i can then adjust /oracle independantly of /.

thanks for advice to be received.

dave.

[Pete Randall]

Dave,

You've got it. Ignite is the only way to safely resize your root file systems and it's an excellent idea to get your /oracle directory re-located elsewhere.


Pete

[Fred Ruffet]

You may not be forced to use such a big work... a question :
Could you post output of bdf ?

Regards,

Fred

[Stf]

Hello,

I think the best way is to create a new lvol mounted on /oracle filesystem.
Before creating this filesystem make sur you have a backup of your actual /oracle.
After that you could expand just /oracle if you need....

Stf ;-)

[david smith_11]

fred,
please find attached a copy of my current bdf. i've already attempted unsuccesfully to copy away the /oracle contents, create a new LV and copy back in the data as i lose the LV's such as /oracle/PRD/sapdata*.
hope you can help.
thanks.

dave.

[Victor BERRIDGE]

Hi Dave,
As mentionned, you could very well create a new file system and copy /the content of /oracle in it, before removing anything, mount the copied FS on /oracle and test...
(to copy use cpio...)

What surprises me is I always thought standard oracle installation went in /opt/oracle, I sometimes create that part under vg00.., but I create a distinct filesystem for each version: /opt/oracle/product/

Like that when the DBAs want a new I create a new FS and when the DBAs have finished using a release I umount the FS and can reuse the freed space...

All the best
Victor

[Fred Ruffet · Accepted solution]

If I understand your problem, your Oracle kernel is in /oracle and you have mountpoint in it (Your consultant has never heard about OFA architecture). Your first process of creating a LV and moving everything is good. All you need is to add some steps :
. Create LV
. Mount LV to a temporary place
. Stop all Oracle processes
. Unmount all LV mounted under /oracle
. move /oracle content to your new LV
. remount it in correct place
. remount all LV
. restart oracle
. correct /etc/fstab

Regards,

Fred

[Victor BERRIDGE]

Hi Dave,
I definitely would go for a move because you cant have to soft under /oracle since / is of 147MB
And I suppose Fred ;) will agree:
move the content after unmount all the mountpoints after /oracle to a small filesystem of lets say 100MB
you could even use links (I wouldnt...)
or mount the FS to /oracle

But for your new installation go and follow OFA!!!

All the best
Victor

[david smith_11]

all, but especially fred !
thanks for all your input. the only thing i was missing was a couple of mount points under my new /oracle to make things work.
might not of seen it without your suggestions.
cheers.

dave ;-)

[david smith_11]

thanks all.