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:

• Step by Step - Configure Direct NFS Client (DNFS) on Linux (Doc ID 762374.1)
• How to Setup Direct NFS client multipaths in same subnet (Doc ID 822481.1)
• How To Create ASM Diskgroups using NFS/NAS Files? (Doc ID 731775.1)
• V$views for Direct NFS client (Doc ID 822324.1)
• Linux OS Service 'nfs' (Doc ID 551678.1)
• Mount Options for Oracle files when used with NAS devices [ID 359515.1]

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.