Use Direct NFS for Data Files

最新推荐文章于 2024-03-19 17:08:06 发布

cuhhjuh46130

最新推荐文章于 2024-03-19 17:08:06 发布

阅读量105

点赞数

文章标签：数据库

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: