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