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

Advertisements

2 Responses to Direct NFS

  1. Otto says:

    Very useful information! I passed it along to our DBA who appreciated it a lot. Thank you.

  2. John Lovato says:

    or just stop all dbs and run $ORACLE_HOME/root.sh as root.

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: