11G OCM Create and Manage a tablespace that uses NFS mounted file system file

My Oracle Support Documents

Some documents from My Oracle Support that may be of relevance to this configuration:

Points to Remember

Location of Parameter File

The parameter file can be located in one of the three (3) following (in search order):

  1. $ORACLE_HOME/dbs/oranfstab which is used to separate NFS mounts by database home.
  2. /etc/oranfstab which is for all databases (including ASM).
  3. /etc/mtab which was not investigated by me.

Format of Parameter File

A sample format of the parameter file is:

server:  freenas              <= Name for reference in V$DNFS_* views
path:    192.168.2.1          <= NIC on NFS server
local:   192.168.2.2          <= NIC on database server
export:  /mnt/PENRITH/ASMDATA <= mount point on NFS server
mount:   /u07                 <= mount point on database server

Install the Driver

The following command installs the DirectNFS driver:

ln -s libnfsodm11.so libodm11.so

Start Up Parameter

The following parameter should be put into either the pfile or spfile:

filesystemio_options = directio

Bringing into Effect

To make the DirectNFS driver effective, all of the above has to be done before restarting the ASM and Database instances.

Verification

There are two (2) places:

  1. The alert log will display the ODM driver version soon after the parameters. The message should be:
  2. Oracle instance running with ODM: Oracle Direct NFS ODM Library Version 2.0
    
  3. The V$DNFS_SERVERS view should match the contents of the oranfstab file.

Demonstration

See 14 Set Up DirectNFS for Example Database for a successful implementation of DirectNFS.