topic Error ORACLE-Export utility on LTO (failed open .. for write) in Operating System - HP-UX

Error ORACLE-Export utility on LTO (failed open .. for write)

Salvador Reyna — Wed, 21 Dec 2005 07:16:45 GMT

Hello all,

Exporting a table un Oracle 8i I have the following error:
EXP-00028: failed to open /dev/rmt/3mn/file.dmp for write

If I make a:
mt -f /dev/rmt/3mn rew
Works correctly

Thanks in advance.

Re: Error ORACLE-Export utility on LTO (failed open .. for write)

Peter Godron — Wed, 21 Dec 2005 07:38:10 GMT

Salvador,
have you had a look at:
http://www.orafaq.com/forum/t/36963/0/

Re: Error ORACLE-Export utility on LTO (failed open .. for write)

Eric Antunes — Wed, 21 Dec 2005 08:06:42 GMT

Hi Salvador,

Why do you use /dev/rmt/3mn? Why not /dev/rmt/3m? /dev/rmt/3mn is saying to tape to not rewind (the "n" after the "m" means "No rewind") and this is why it works after "mt -f /dev/rmt/3mn rew"...

Check your tape options with:

#ioscan -fnCtape

And use a tape device option with Rewind for the export (/dev/rmt/3m for example).

Best Regards,

Eric Antunes