• About Me

    Maxwell Miranda
    Oracle DBA Consultant.
  • Category

  • Archives

  • My Blog Calendar

    January 2010
    M T W T F S S
    « Nov   Feb »
  • RSS Oracle Feeds

    • correct my script shell to backup with rman
      Hi EVERYBODY, hope you are doing well, i am not an expert on linux i try to create script shell to backup with rman i did some configuiration regarding some parameter below my script Code: --------- #!/bin/sh export ORACLE_SID=bss export ORACLE_HOME=/home/oracle/10.2.0/db/ cd /home/oracle/10.2.0/db/bin ./rman exit connect target sys/bss { run backup incremen […]
    • Ora 12547 tns lost contact
      Hi My technical envitement mintLinux_18.1_64 bits serena Oracle Data Base 11 Enterprise edition i run the command dbca. the consequence of the database configuration went well until i had arrived to a step where i faced a problem ORA 12547 TNS LOST CONTACT and ih the termnal l found root_mint@mintlinux-oraccle ~/app/root_mint/product/11.2.0/dbhome_1/bin $ db […]
    • Dynamic SQL in a stored procedure
      I am trying to rewrite a Procedure to use dynamic SQL I have attached my procedure. When I try to compile it I get this error: •Project: C:\Users\murray.OLF\AppData\Roaming\SQL Developer\system4.\o.sqldeveloper.\projects\IdeConnections#Oracle12c+-+D19.jpr •Oracle12c - D19 •Error(405,5): PL/SQL: Statement ignored •Error(406,13 […]
    • Logic in store procedure
      Hi group, I have a requirement for a customer as follow. I have a table with 9 columns and one more with the combination id where we can have 3 columns with double values (1X, 12, X1, X2, 21, 2X) and two triples (two columns of a row with triple value) are allowed by row (1X2). Si I have 72 records with different values (72 rows is an example here) just to e […]
    • Listener trouble
      I am having an issue across all databases on 3 separate environments. Database, listener, application on same local machine Basic simple listener.ora, tnsnames.ora with one SID/ service name used DBCA to create database years ago and netca to configure listener etc. This has been running seemingly without tons of issues till recently there has been many conn […]

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

NFS Mount Options

You must mount NFS volumes used for storing database files with special mount options on the host where the database server is running. When mounting an NFS file system, Oracle recommends that you use the same mount point options that your NAS vendor used when certifying the device. Refer to your device documentation or contact your vendor for information about recommended mount-point options.

In general, most vendors recommend that you use the NFS mount options listed in the following table.

Option Requirement Description
hard Mandatory Generate a hard mount of the NFS file system. If the connection to the server fails or is temporarily lost, connection attempts are made until the NAS device responds.
bg Optional Try to connect in the background if connection fails.
tcp Optional Use the TCP protocol rather than UDP. TCP is more reliable than UDP.
nfsvers=3 Optional Use NFS version 3. Oracle recommends that you use NFS version 3 where available, unless the performance of version 2 is higher.
suid Optional Allow clients to run executables with SUID enabled. This option is required for Oracle software mount points.
rsize Mandatory The number of bytes used when reading from the NAS device. This value should be set to the maximum database block size supported by this platform. A value of 8192 is often recommended for NFS version 2 and 32768 is often recommended for NFS version 3.
wsize Mandatory The number of bytes used when writing to the NAS device. This value should be set to the maximum database block size supported by this platform. A value of 8192 is often recommended for NFS version 2 and 32768 is often recommended for NFS version 3.
nointr (or intr) Optional Do not allow (or allow) keyboard interrupts to kill a process that is hung while waiting for a response on a hard-mounted file system.

Note: Different vendors have different recommendations about this option. Contact your vendor for advice.

actime=0 or noac Mandatory Disable attribute caching.

Note: You must specify this option for NFS file systems where you want to install the software. If you do not use this option, Oracle Universal Installer will not install the software in the directory that you specify.

The mandatory mount options comprise the minimum set of mount options that you must use while mounting the NFS volumes. These mount options are essential to protect the integrity of the data and to prevent any database corruption. Failure to use these mount options may result in the generation of file access errors. Refer to your operating system or NAS device documentation for more information about the specific options supported on your platform.

For AIX:

For HP-UX:


One Response

  1. Good article. I thank you posting that. I ask you accept my apology for my weak English writing, I am from France and English is sort of new to me.

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

%d bloggers like this: