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:
本文详细介绍了如何在OracleDatabase11g中配置内部DirectNFS客户端,使其能直接访问NFSV3服务器,并通过一系列实验步骤进行验证。包括NAS模拟、配置NFS服务、验证访问权限、数据库参数调整以及创建基于NFS的数据文件。同时阐述了DirectNFS在数据库与NFS服务器交互过程中的应用顺序和相关视图的使用。
164

被折叠的 条评论
为什么被折叠?



