Configuring File System Storage for Oracle Database

Complete these procedures to use file system storage for Oracle Database.

For optimal database organization and performance, Oracle recommends that you install data files and the Oracle Database software in different disks.

Deploying Oracle Direct NFS for Oracle Database

Oracle recommends Oracle Direct NFS (dNFS) for database file systems hosted on NFS storage because it provides performance optimizations; database software and data files should preferably reside on separate disks. Configure NFS mounts with rsize and wsize values of at least 32768, and ensure TCP receive and transmit buffers are sized appropriately for the network, with changes applied through sysctl and a network restart. Create an oranfstab file defining each NFS server, local and server network paths, exports, mount points, optional mount timeouts, NFS versions, security modes, routing behavior, management interfaces, and SNMP community strings. Supported security modes include sys, krb5, krb5i, and krb5p; NFSv3 is the default, while NFSv4.x and pNFS require explicit configuration, and pNFS supports only sys authentication.

Enabling and Disabling Direct NFS Client Control of NFS

Single-instance Oracle Database installations normally install Direct NFS Client disabled. After configuring oranfstab, enable dNFS from $ORACLE_HOME/rdbms/lib with make -f ins_rdbms.mk dnfs_on; disable it with the corresponding dnfs_off command and remove oranfstab. Restart the database after removing an NFS path currently in use. To enable Hybrid Columnar Compression through dNFS, verify that SNMP is enabled on the ZFS storage server, configure the oranfstab management and community parameters when required, and ensure the libnetsnmp.so library and snmpget utility are installed.