My previous post was regarding how to setup NFS server on HP-UX. It is used as target to dump database from an Oracle 10g.

The first thing that I have to do is, of course to make sure that the NFS share is automatically mounted on startup by adding a line on my /etc/fstab. The client  is on HP-UX 11.23 also

# vi /etc/fstab

This is the line that I add to the end of /etc/fstab file:

hqcmsdb2:/backup/dump /backup/dump nfs proto=tcp,rw,intr,bg,rsize=32768,wsize=32768 0 2 

Please note that the lines above is intended to be written on a single line. The NFS share is mounted on /backup/dump. I was also able to write to the folder using oracle user account. Mount the share…

# mount /backup/dump

… and start the dump process. But the process logged an error, saying this:

“ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

A short trip to google land told me that Oracle 10GR2 checks for certain parameter to be present on an NFS share before it start the dump process. Namely forcedirectio, vers=3, and hard. After trying several suggestion, this is my current entry on /etc/fstab:


hqcmsdb2:/backup/dump /backup/dump nfs proto=tcp,forcedirectio,vers=3,rw,hard,intr,bg,rsize=32768,wsize=32768 0 2


After remounting the /backup/dump folder, I was able dump the database normally like it should be.

Please note that this is done on HP-UX system. Please consult the manual for fstab of your *Nix flavor for the similar parameters

By ikhsan

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.