Operating System - HP-UX
1748255 Members
3678 Online
108760 Solutions
New Discussion юеВ

Re: Max Oracle Export Size

 
Derek Baxter
Occasional Advisor

Max Oracle Export Size

I know there was a couple other postings regarding this but it was not exactly my problem. I am using oracle 8.0.4 on a hp-ux 11. One of our databases export files have reached 2gig and cancels itself at that point. Does anyone have any suggestions that may help.
Thanks in advance
14 REPLIES 14
Patrick Wallek
Honored Contributor

Re: Max Oracle Export Size

Is the filesystem you are exporting to enabled for largefiles?

# 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.
Steven E. Protter
Exalted Contributor

Re: Max Oracle Export Size

The problem is not oracle. Its the filesystem.

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Derek Baxter
Occasional Advisor

Re: Max Oracle Export Size

I spoke with our Unix Administrator. We checked the system with fstab and it showed the following for this directory
/dev/vg107/lvol107 /u107 vxfs rw,suid,largefiles,delaylog,datainlog 0 2

So i believe taht Largefiles are enabled.
Patrick Wallek
Honored Contributor

Re: Max Oracle Export Size

Ask your unix admin to do:

# 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.
Bill Douglass
Esteemed Contributor

Re: Max Oracle Export Size

Check the ulimit (ulimit -a) for user oracle.

Also, you can unmount a filesystem, fsck it, and set the largefiles bit using the standard version of fsadm (see fsadm_vxfs man page).
Derek Baxter
Occasional Advisor

Re: Max Oracle Export Size

by running fsadm /u107 i get the following:
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.
Patrick Wallek
Honored Contributor

Re: Max Oracle Export Size

OK, your filesystem can support largefiles.

It appears that it's time to dig into Oracle.

Unfortunately I'm not an Oracle person.
Tim Sanko
Trusted Contributor

Re: Max Oracle Export Size

I should be able to help.

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.
Brian Crabtree
Honored Contributor

Re: Max Oracle Export Size

The way that we do it is to export to a pipe, and we normally compress the pipe as well. The following is a quick represenation.

mknod exp_pipe p
compress < exp_pipe > expdat.dmp.Z &
exp userid= file=exp_pipe full=y

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= file=imp_pipe full=y

Hope this helps,

Thanks,

Brian