Create and Manage a tablespace that uses NFS mounted file system file

Direct NFS Client by default mounts the entries find in /etc/mtab. You can use the new file oranfstab which is placed in
$ORACLE_HOME/dbs directory, where you can add additional specific options for DNFS.

NFS server: ed01pc
NFS client: ed02pc

Direct NFS requires mount point to be already mounted.
/etc/fstab record

ed01pc:/u02/nfs_storage /u02/nfs_ocm nfs rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp, 
actimeo=0,vers=3,timeo=600 0 0

As root user execute mount command.

[root@ed02pc ~]# mount /u02/nfs_ocm

Next, enable the Direct NFS Clien (it is not enabled by default). Navigate to $ORACLE_HOME/rdbms/lib
Execute following command:

make -f ins_rdbms.mk dnfs_on

If you want to disable DNFS execute following command:

make -f ins_rdbms.mk dnfs_off

Now, let test the DNFS.

SQL> create tablespace nfs_tbs datafile '/u02/nfs_ocm/nfs_tbs_01.dbf' size 50M;

Tablespace created.

List information about DNFS servers.

SQL> column svrname format a20
SQL> column dirname format a20
SQL> select svrname,dirname,mntport,nfsport from v$dnfs_servers;

SVRNAME              DIRNAME                 MNTPORT    NFSPORT
-------------------- -------------------- ---------- ----------
ed01pc               /u02/nfs_storage           1008       2049

Leave a Reply