Direct NFS

You can get info from the following views:

— View servers accessed using Direct NFS
select * from v$dnfs_servers;

— View files currently open using Direct NFS
select * from v$dnfs_files;

— View open network paths or channels to servers for which Direct NFS is providing files
select * from v$dnfs_channels;

— View performance statistics for Direct NFS
select * from v$dnfs_stats;

Also you will see in the alert log on startup:

Oracle instance running with ODM: Oracle Direct NFS ODM Library Version 2.0

Disable DNFS

Shutdown DB

On all hosts:

cd $ORACLE_HOME/lib
mv libodm11.so_bak libodm11.so
Restart Instance

For Completeness, to enable:

Enable DFNS

Shutdown DB

On all hosts:

cd $ORACLE_HOME/lib
mv libodm11.so libodm11.so_bak
ln –s libnfsodm11.so libodm11.so
Restart Instance

Useful SQL

— View servers accessed using Direct NFS
select * from v$dnfs_servers;

— View files currently open using Direct NFS
select * from v$dnfs_files;

— View open network paths or channels to servers for which Direct NFS is providing files
select * from v$dnfs_channels;

— View performance statistics for Direct NFS
select * from v$dnfs_stats;

Known Issue

Getting the following message in alert log and instance not starting:

Direct NFS: please check that oradism is setuid

To correct, the following permissions are needed on:

ls -la $ORACLE_HOME/bin/oradism
-rwsr-x— 1 root oinstall 72416 Sep 11  2008 /u01/app/oracle/product/11.1/db/bin/oradism

If NOT this, shutdown DB and change permission as follows:

sudo su
cd /u01/app/oracle/product/11.1/db/bin
chmod 750 oradism
chmod u+s oradism
Restart instance