ORA-27054 : Failed to create dump of Oracle database over NFS


 

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


Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s