Problem Exporting Data on an external USB drive
On a Linux Red hat 9, I want to export a few schemas (create .dmp files) onto an external 300GB usb drive. everything seems to work but when i submit the job. i get the following error:
Export Submit Failed
There is a problem writing to the export files: ORA-31641: unable to create dump file "/mount/usb/flash_10g/EXPD
P.S. I am using enterprise manager, db is 10g R1.
Export Submit Failed
There is a problem writing to the export files: ORA-31641: unable to create dump file "/mount/usb/flash_10g/EXPD
P.S. I am using enterprise manager, db is 10g R1.
Mark Geerlings
From the Linux command line, as the Linux user that owns the Oracle software, can you copy a small file to that device? If you get that to work first, then an Oracle export should also be able to use that device.
your script should probably mount the directory before using it, depending on how many files are on the disk, I have seen situations where the mount just plain took too long.
I ended up taking the mount portion out of the script, and making a second script just to test and mount if needed, and cron jobed that about 10 minutes before the backup script ran.
In general though, it should be fine, as long as the drive is mounted and the perms are right.
I ended up taking the mount portion out of the script, and making a second script just to test and mount if needed, and cron jobed that about 10 minutes before the backup script ran.
In general though, it should be fine, as long as the drive is mounted and the perms are right.
I don't think this is an Oracle problem, I think it is a Linux issue. If you can get the Linux user that runs the Oracle software to be able to copy a file to that USB device, you should be all set. If you cannot get that to work at the command prompt though, then an Oracle export won't be able to write there either.
ASKER
well i can easily copy files onto the external USB drive (the drive is not ext3 its FAT) and i think thats the issue. what do u folks suggest, if i convert it to ext3 will it resolve my issues? (best ways for converting it to ext3 apart from fdisk?)
my fstab for the usb drive is something like:
/dev/sda1 /mount/usb vfat user,noauto,umask=0 0 0
commands like cp abc.txt /mount/usb work!
but amazingly the following command won't work:
cp -r /home/oracle /mount/usb/images
and throws the error message:
cp: cannot create symbolic link `/mount/usb/images/oracle/
xyz.com': Operation not permitted
my fstab for the usb drive is something like:
/dev/sda1 /mount/usb vfat user,noauto,umask=0 0 0
commands like cp abc.txt /mount/usb work!
but amazingly the following command won't work:
cp -r /home/oracle /mount/usb/images
and throws the error message:
cp: cannot create symbolic link `/mount/usb/images/oracle/
xyz.com': Operation not permitted
ASKER
sorry folks tell me how the fstab entry shud be for:
mount -o /dev/sda1,uid=0,gid=500,um
'cause thats how i have mounted it for now.
mount -o /dev/sda1,uid=0,gid=500,um
'cause thats how i have mounted it for now.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
I may be an Oracle expert, but in the Linux world I'm still a novice. Based on my limited understanding of Linux, I think that mount syntax that you have is fine for a one-time manual mount of a USB drive, but I don't think you want the fstab entry to look like that. I would think the fstab entry for this should look more like the default fstab entry for the floppy drive, which includes "noauto" and "removable_t", but hopefully someone else with more Linux experience will clarify this.