Use Direct NFS for Data Files
With Oracle Database 11g ,instead of using the operating system kernel NFS client, you can configure Oracle Database to access NFS V3 servers directly using an Oracle internal Direct NFS client.
以下是自己简单在单机实验步骤：
1.os模拟nas
#mkdir /nfs
#chmod 777 /nfs
#vi /etc/exports
/nfs 192.168.152.0/255.255.255.0(rw,sync,insecure)
#service portmap restart
#service nfs restart
#exportfs -arv
exporting 192.168.152.0/255.255.255.0:/nfs
#mkdir /home/oracle/mynfs
#vi /etc/fstab
192.168.152.11:/nfs /home/oracle/mynfs nfs defaults 0 0
2.prod1步骤:
#su - oracle
$df
192.168.152.11:/nfs 10154048 2202272 7427648 23% /home/oracle/mynfs
$cd $ORACLE_HOME/dbs
$vi oranfstab
server:dnfs
path:192.168.21.129
export:/nfs mount:/home/oracle/mynfs
$cd $ORACLE_HOME/lib
$cp -s libodm11.so libodm11.so_stub
$rm libodm11.so
$ln -s libnfsodm11.so libodm11.so
restart oracle database
SQL> select * from v$dnfs_servers;
no rows selected
SQL> create tablespace dnfs datafile '/home/oracle/mynfs/dnfs01.dbf' size 5M reuse;
Tablespace created.
SQL>set linesize 120
SQL>col svrname format a10
SQL>col dirname format a20
SQL>select * from v$dnfs_servers;
ID SVRNAME DIRNAME MNTPORT NFSPORT WTMAX RTMAX
---------- ---------- -------------------- ---------- ---------- ---------- ----------
1 dnfs /nfs 669 2049 0 0
SQL> select * from v$dnfs_files;
FILENAME FILESIZE PNUM SVR_ID
-------------------------------------------------- ---------- ---------- ----------
/home/oracle/mynfs/dnfs01.dbf 5251072 10 1
3.补充:
dnfs寻找mount点的顺序:
$ORACLE_HOME/dbs/oranfstab
/etc/oranfstab
/etc/mtab
dnfs相关视图
V$DNFS_SERVERS: Shows a table of servers accessed using Direct NFS
V$DNFS_FILES: Shows a table of files currently open using Direct NFS
V$DNFS_CHANNELS: Shows a table of open network paths (or channels) to servers for which Direct NFS is providing files
V$DNFS_STATS:
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12554513/viewspace-713596/ ，如需转载，请注明出处，否则将追究法律责任。
