Differences

This shows you the differences between two versions of the page.

--- oracle_12c_enable_nfs_direct [2019/03/27 18:12] – andonovj
+++ oracle_12c_enable_nfs_direct [2019/10/18 20:04] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-===Overview===
+====Overview====
 It is public knowledge that NFS is SLOW solution for Oracle in any way. Even though it is a supported option for Oracle RAC, it is VERY BAD idea, because of the over caching and the fact that Oracle will have to use the default system driver to send it commands and requests.
@@ Line 5: / Line 5: @@
-===Implementation===
+====Implementation====
 Direct NFS is fairly easy to implement. Since it searched for the default location for NFS information:
 /etc/mtab
 /etc/fstab
 /etc/oranfstab
@@ Line 14: / Line 17: @@
 P.S. Bear in mind that the oranfstab has different configuration syntax than the usual /etc/fstab:
 <sxh bash>
-server: MyNFSserver1
+server: TAURUS
-path: 192.168.1.1
+local:  IP_NFS_SERVER
-path: 192.168.1.2
+path:  IP_DEST_SERVER
-export: /vol/oradata1 mount: /mnt/oradata1
+export: /be_ora_logs mount: /backup
 </sxh>
@@ Line 40: / Line 43: @@
-===Possible troubles===
+====Possible troubles====
 By default, Windows "blocks" writes by NFS direct....not so smart, so check that from windows as follows:
 <sxh bash>
@@ Line 88: / Line 91: @@
     NumClients    REG_DWORD    0x5
     Clients    REG_SZ    N,server1,server2
+</sxh>
+After that, restart the NFS service and all should be running normally :)
+====Verify====
+You can verify if the NFS driver has been configured as follows:
+<sxh bash>
+SQL> select * from v$dnfs_servers;
+        ID SVRNAME              DIRNAME            MNTPORT    NFSPORT NFSVERSION            WTMAX      RTMAX     CON_ID RDMAENABLE   RDMAPORT SECURITY
+---------- -------------------- --------------- ---------- ---------- ---------------- ---------- ---------- ---------- ---------- ---------- ----------
+10.200.15.30         /be_ora_logs          2049       2049 NFSv3.0               32768      32768          0 No                  0 sys
+SQL>
+</sxh>
+That shows us that the NFS is configured on server: 10.200.15.30 on this partition: /be_ora_logs
+You can also verify if the NFS is ACTUALLY used during a backup. You should be able to observe the following output:
+<sxh bash>
+SQL> select CH_ID, SVR_ID, SENDS, RECVS, PINGS from v$dnfs_channels;
+     CH_ID     SVR_ID      SENDS      RECVS      PINGS
+---------- ---------- ---------- ---------- ----------
+          2        366        608          0
 </sxh>