- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- moving oracle directory out of / directory
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-27-2009 10:49 AM
тАО01-27-2009 10:49 AM
moving oracle directory out of / directory
mkdir oracle_new
Stop all oracle process
umount all lv mounted under oracle
cd /oracle
find . | cpio -pdumv /oracle_new
Then I am not sure how I get this oracle_new directory to be mounted as /oracle and have everything respond correctly when the database is remounted.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-27-2009 11:00 AM
тАО01-27-2009 11:00 AM
Re: moving oracle directory out of / directory
you neede to create anlogical volume in vg00 or another vg then
lvcreate -L 16000 -n lvoracle vg00
newfs -o largefiles /dev/vg00/rlvoracle
mount /dev/vg00/lvoracle /new_oracle
dump operation
umount /new_oracle
mount /dev/vg00/lvoracle /oracle
other mounts.
Hasan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-27-2009 11:03 AM
тАО01-27-2009 11:03 AM
Re: moving oracle directory out of / directory
1) If the directory contains binaries and executables from the Oracle install - This may required that you backup Oracle, and delete it and re-install. Because Oracle already knows where the program links and paths reside.
2) If the directory contains Oracle datafiles - Then stop your Oracle processes, back it up, create your new mount point or etc. Move that directory. Follow the Oracle procedures for "Backup & Recovery" to tell Oracle where the relocated datafiles reside.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-27-2009 11:19 AM
тАО01-27-2009 11:19 AM
Re: moving oracle directory out of / directory
Not good enough! on several levels!
1) Why only 'believe'.
Why not measure?! You know... du -sk /*
2) There really should only be mount points and 'system' stuff dierctly under /
Anything more is 'scary'
3) Did it 'fit' at some point? What changed?
Possible DUMP or TRACE files in the Oracle bdump, or udump directories?
>> move the /oracle directory to a separate mount point
Yes...
Use a temporary mountpoint name for the move, then rename to the the directory name that oracle has remembered 'everywhere'.
Or seeing where you are now, maybe just move SOME oracle stuff. Notably DB files,
Also easy to move are REDO logs, ARCH files, and the TEMP tablespace.
Good Luck!
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2009 05:38 AM
тАО01-29-2009 05:38 AM
Re: moving oracle directory out of / directory
I agree with has already been posted, first you need to know what amount of info corresponds to Oracle Software, and what to Oracle Data.
To do this issue a du -sk, standing in /oracle.
Also, you might want to check where all your Oracle datafiles are located, for that matter connect into Oracle as SYSDBA and issue the following query:
select name, bytes
from v$datafile;
This will tell you which datafiles reside on / filesystem.
If the major space is occupied by Oracle datafiles, then I you can relocate them very easily.
RGs,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2009 05:38 AM
тАО01-29-2009 05:38 AM
Re: moving oracle directory out of / directory
I agree with has already been posted, first you need to know what amount of info corresponds to Oracle Software, and what to Oracle Data.
To do this issue a du -sk, standing in /oracle.
Also, you might want to check where all your Oracle datafiles are located, for that matter connect into Oracle as SYSDBA and issue the following query:
select name, bytes
from v$datafile;
This will tell you which datafiles reside on / filesystem.
If the major space is occupied by Oracle datafiles, then you can relocate them very easily.
RGs,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2009 09:07 AM
тАО01-29-2009 09:07 AM
Re: moving oracle directory out of / directory
140801904 /oracle.
I have separate mount points for all of the datafiles. When I do an ll /oracle I see under that directory the database directory and a client and stage directory. I believe we had a consultant at some time who successfully was able to move the /oracle to a mount point of its own out of the root directory. I wanted to be able to do this without the database administrator having to reload oracle or me having to restore from tape.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2009 09:35 AM
тАО01-29-2009 09:35 AM
Re: moving oracle directory out of / directory
1. bdf
2. cd oracle
du -sk * (* will give you details for the subdirectories)
3. Also please execute the SQL query I gave you before, just to be sure how much space are database files consuming.
BRs,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2009 11:07 AM
тАО01-29-2009 11:07 AM
Re: moving oracle directory out of / directory
You attachement (why not plain .TXT instead of .DOC?) shows a very typical SAP / Oracle system layout.
You do NOT want to move /oracle.
That's just an anchor with many mount points under it. Those take no space on /.
[ allthough they may HIDE space: stick file in/under a directory, and next use that same directory as mount point will 'hide' the undelying allocations. An all to easily made operational error. ]
we'll have to dive below /*, and go for "du -sk /oracle/*
For clarify sake, you also try the -x option for 'du'.
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-04-2009 01:22 PM
тАО02-04-2009 01:22 PM