- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Max Oracle Export Size
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
тАО04-22-2003 08:33 AM
тАО04-22-2003 08:33 AM
Max Oracle Export Size
Thanks in advance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2003 08:40 AM
тАО04-22-2003 08:40 AM
Re: Max Oracle Export Size
# fsadm /filesystem_name
If it is not largefiles enabled, you will need to do that.
If you have online JFS you can do:
# fsadm -o largefiles /filesystem_name
You will also need to check /etc/fstab and make sure that that filesystem has the largefiles mount option there so it gets mounted correctly next time you reboot.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2003 08:40 AM
тАО04-22-2003 08:40 AM
Re: Max Oracle Export Size
You need to enable the filesystem for largefiles.
If you have onlineJFS you can upgrade the filesystem via the fsadm command.
If like me, you don't have these powers yet, you need to back up the fs and then use newfs to recreate the fs.
umount /fs
newfs -F vxfs -o largefiles /dev/vg01/rfs
mount /fs
Now its up and clean and ready for largefiles mount.
For 11i you don't need the largefiles parameter in the /etc/fstab file.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2003 08:55 AM
тАО04-22-2003 08:55 AM
Re: Max Oracle Export Size
/dev/vg107/lvol107 /u107 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
So i believe taht Largefiles are enabled.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2003 09:18 AM
тАО04-22-2003 09:18 AM
Re: Max Oracle Export Size
# fsadm /u107
What does it return?
What happes if you try to create a 3GB file in that directory?
# prealloc testfile 3000000000
That will create a file called testfile of 3,000,000,000 size or approx. 3 GB.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2003 09:20 AM
тАО04-22-2003 09:20 AM
Re: Max Oracle Export Size
Also, you can unmount a filesystem, fsck it, and set the largefiles bit using the standard version of fsadm (see fsadm_vxfs man page).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2003 10:17 AM
тАО04-22-2003 10:17 AM
Re: Max Oracle Export Size
fsadm: /etc/default/fs is used for determining the file system type
nomultifsets
largefiles
by running prealloc testfile 3000000000 i create a 3gig file in /u107 with no error.
and by running ulimit -a for oracle it shows
file(blocks) ulimited
It looks to me like it is capable of making files that are bigger.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2003 10:44 AM
тАО04-22-2003 10:44 AM
Re: Max Oracle Export Size
It appears that it's time to dig into Oracle.
Unfortunately I'm not an Oracle person.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2003 11:50 AM
тАО04-22-2003 11:50 AM
Re: Max Oracle Export Size
There is a cron patch that you will have to install if your export is being initiated by cron.
The ulimit for all ksh processes maxes at 2 GB/file.
if you echo your ulimit through the shells and it still fails it's most probable cause is the cron ulimit.
You can get it at the itrc search for the latest cron cumulative. you'll be all right.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2003 12:15 PM
тАО04-22-2003 12:15 PM
Re: Max Oracle Export Size
mknod exp_pipe p
compress < exp_pipe > expdat.dmp.Z &
exp userid=
This will export the database to a compressed file called "expdat.dmp.Z". To import it, you can uncompress it and import normally, or do the following:
mknod imp_pipe p
uncompress < expdat.dmp.Z > imp_pipe
imp userid=
Hope this helps,
Thanks,
Brian