Oracle Direct NFS – Database 12c

On this post i will show you how to enable the database to use Direct NFS 
over Infiniband.
References:
https://docs.oracle.com/cd/E51475_01/html/E52872/integration__ssc__configure_appliance__configuring_oracle_direct_nfs_dnfs.html
Oracle ZFS Storage Appliance: How to Enable Oracle Intelligent Storage Protocol (OISP) (Doc ID 1943618.1)
Direct NFS monitoring and v$views (Doc ID 1495739.1)

**** BEFORE START:
----> SHUTDOWN THE INSTANCE(S)/LISTENERS UNDER THE ORACLE_HOME <-----


root@sun-prod02:~# ping -a pathA-ib ---> (This is the HOSTNAME or IP Address for the InfiniBand PATH)
pathA-ib (192.168.255.10) is alive

 
1.) Re-Link the binary to use DNFS
make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk dnfs_on
 
2.) Configure the file: oranfstab
Note: The export parameters should reflect the mount points similar to the entries 
created in /etc/vfstab. The entries should look similar to the following

cd $ORACLE_HOME/dbs
 
-bash-4.1$ cat oranfstab

server:pathA-ib
local:192.168.255.27
path:192.168.255.10
nfs_version:nfsv4
export:/export/sun-prod02/oracle mount:/oracle
export:/export/sun-prod02/export mount:/export
export:/export/sun-prod02/fast_recovery_area mount:/fast_recovery_area
export:/export/sun-prod02/oradata mount:/oradata
export:/export/sun-prod02/oralog mount:/oralog
management:192.168.255.10
community:comm0

3.) Restart the database
srvctl start database -d <DB Name>

4.) Check the Alert Log:

grep -i '"Sun ZFS"|Direct' alert_*.log
grep -i "Direct NFS:" alert_sun2.log

Thu Jan 12 14:15:44 2017
Oracle instance running with ODM: Oracle Direct NFS ODM Library Version 3.0

Direct NFS: channel id [0] path [192.168.255.10] to filer [pathA-ib] via local 
[192.168.255.27] is UP
Thu Jan 12 14:16:45 2017
Direct NFS: channel id [0] path [192.168.255.10] to filer [pathA-ib] via local 
[192.168.255.27] is UP
Thu Jan 12 14:16:45 2017
Direct NFS: channel id [0] path [192.168.255.10] to filer [pathA-ib] via local 
[192.168.255.27] is UP

5.) You can check inside of DB also using the views below:

Monitoring:

v$dnfs_servers - Displays information about the NFS servers accessed by Direct NFS.
v$dnfs_files - Displays information about the Oracle files opened using Direct NFS.
v$dnfs_channels - Displays information about the network connections (channels) 
open to the NFS servers.
v$dnfs_stats - Displays statistics of the different NFS operations issued by 
Direct NFS (dNFS does not expose statistics per mount point, but rather per 
process).
Advertisements

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