Configuring File System Storage for Oracle AI Database
About File System Storage for Oracle AI Database
This page outlines procedures for using file system storage with Oracle AI Database and recommends placing database data files and Oracle software on separate disks for organization and performance. It also notes that Oracle Persistent Memory Database and Oracle Memory Speed File System are deprecated in release 26ai because Intel is discontinuing Optane Persistent Memory hardware.
Read More: About File System Storage for Oracle AI Database
Deploying Oracle Direct NFS for Oracle AI Database
This page describes deploying Oracle Direct NFS for databases using NFS storage, including recommended separation of database files and software, NFS buffer settings of at least 32768, TCP buffer tuning for network performance, and creation of an oranfstab configuration file. It explains server, network path, export, mount, timeout, protocol version, routing, management, community, and security attributes, including Kerberos options, and provides configuration examples for multiple paths, exports, and authentication modes.
Read More: Deploying Oracle Direct NFS for Oracle AI Database
Enabling and Disabling Direct NFS Client Control of NFS
This page explains how to enable or disable Direct NFS Client control of NFS using the dnfs_on and dnfs_off make targets after configuring oranfstab. Disabling requires removing the configuration file, and databases using removed NFS paths must be restarted. It also describes enabling Hybrid Columnar Compression by verifying SNMP on the ZFS storage server, configuring management and community settings when needed, and ensuring the Net-SNMP library is installed.
Read More: Enabling and Disabling Direct NFS Client Control of NFS
Deploying a DAX-Enabled File System for Persistent Memory Database
This page explains how to deploy an XFS file system mounted with DAX for Persistent Memory Database, while noting that OMS File System is deprecated in Oracle AI Database 26ai because Intel is discontinuing Optane PMEM. The process requires an Intel PMEM device in fsdax mode, a DAX-capable XFS file system, an instance started in NOMOUNT mode, creation of a PMEM filestore, and database or tablespace creation. Recommended configuration includes 2 MB alignment, separate metadata and data partitions, 2 MB XFS extents, and mounting with appropriate DAX and real-time device options.
Read More: Deploying a DAX-Enabled File System for Persistent Memory Database
Creating a Database on PMEM Storage Using Oracle DBCA
This page describes using Oracle DBCA in interactive or silent mode to create a single-instance Oracle AI Database with PMEM storage. The workflow covers launching DBCA, selecting advanced configuration and a single-instance deployment, defining the global database name, SID, CDB and PDB options, and selecting PMEM File System as the database storage type. Users must specify the PMEM location and size, may enable Oracle Managed Files, and then complete the remaining configuration prompts.
Read More: Creating a Database on PMEM Storage Using Oracle DBCA