Use DBMS_CLOUD_ADMIN.ATTACH_FILE_SYSTEM to attach a file system to a directory in your Autonomous Database.

1. Create a directory or use an existing directory to attach a Network File System in your Autonomous Database. You must have WRITE privilege on the directory object on your Autonomous Database instance to attach a file system to a directory location in the database.

   For example, the following command creates the database directory named FSS_DIR and creates the file system directory fss:

   CREATE DIRECTORY FSS_DIR AS 'fss';

   See Create Directory in Autonomous Database for more information.

2. Run DBMS_CLOUD_ADMIN.ATTACH_FILE_SYSTEM to attach a file system to a directory in your Autonomous Database. To run this procedure, you must be logged in as the ADMIN user or have EXECUTE privilege on DBMS_CLOUD_ADMIN.

   • By default DBMS_CLOUD_ADMIN.ATTACH_FILE_SYSTEM uses NFSv3:

     BEGIN
        DBMS_CLOUD_ADMIN.ATTACH_FILE_SYSTEM(
         file_system_name      => 'FSS',
         file_system_location  => 'myhost.sub000445.myvcn.oraclevcn.com:/results',
         directory_name        => 'FSS_DIR',  
         description           => 'Source NFS for sales data'
     );
     END;
     /

     Optionally you can use the params parameter and specify the nfs_version with value 3 to specify NFSv3.

   • To use NFSv4, include the params parameter with DBMS_CLOUD_ADMIN.ATTACH_FILE_SYSTEM and specify the nfs_version with value 4 to specify NFSv4:

     BEGIN
        DBMS_CLOUD_ADMIN.ATTACH_FILE_SYSTEM(
         file_system_name      => 'FSS',
         file_system_location  => 'myhost.sub000445.myvcn.oraclevcn.com:/results',
         directory_name        => 'FSS_DIR',  
         description           => 'Source NFS for sales data',
         params                => JSON_OBJECT('nfs_version' value 4)
     );
     END;
     /

   These examples attach the network file system specified in the file_system_name parameter to the Autonomous Database.

   The file_system_location parameter specifies the location of the file system. The value you supply with file_system_location consists of a Fully Qualified Domain Name (FQDN) and a file path in the form: FQDN:file_path.

   For example:

   • FQDN: myhost.sub000445.myvcn.oraclevcn.com

     For Oracle Cloud Infrastructure File Storage set the FQDN in Show Advanced Options when you create a file system. See Creating File Systems for more information.

   • File Path: /results

   The directory_name parameter specifies the directory name in the Autonomous Database where you want to attach the file system. This is the directory you created in Step 1, or another directory you previously created.

   The description parameter specifies the description for the task.

   The params parameter is a JSON value that specifies an additional attribute nfs_version, whose value can be either 3 or 4 (NFSv3 or NFSv4).

SELECT file_system_name, file_system_location, directory_path                      
   FROM dba_cloud_file_systems
   WHERE file_system_name = 'FSS';

DECLARE
  l_file         UTL_FILE.FILE_TYPE;
  l_location     VARCHAR2(100) := 'FSS_DIR';
  l_filename     VARCHAR2(100) := 'test.csv';
BEGIN
  -- Open the file.
  l_file := UTL_FILE.FOPEN(l_location, l_filename, 'w');
   
  UTL_FILE.PUT(l_file, 'Scott, male, 1000');
 
  -- Close the file.
  UTL_FILE.FCLOSE(l_file);
END;
/

DECLARE
  l_file         UTL_FILE.FILE_TYPE;
  l_location     VARCHAR2(100) := 'FSS_DIR';
  l_filename     VARCHAR2(100) := 'test.csv';
  l_text         VARCHAR2(32767);
BEGIN
  -- Open the file.
  l_file := UTL_FILE.FOPEN(l_location, l_filename, 'r');
 
  UTL_FILE.GET_LINE(l_file, l_text, 32767);
 
  -- Close the file.
  UTL_FILE.FCLOSE(l_file);
END;
/

SELECT object_name FROM DBMS_CLOUD.LIST_FILES('FSS_DIR');

Use the DBMS_CLOUD_ADMIN.DETACH_FILE_SYSTEM procedure to detach a file system from a directory in your Autonomous Database.

BEGIN
   DBMS_CLOUD_ADMIN.DETACH_FILE_SYSTEM (
    file_system_name      => 'FSS'
  );
END;
/

Provides an example for setting up an NSFv4 server for use with Autonomous Database.

1. Set up a private endpoint for the Autonomous Database instance.

   See Configuring Network Access with Private Endpoints for more information.

   The following ingress and egress rules need to be set for your VCN’s security list so that Autonomous Database and the NFSv4 server can talk to each other

   • Stateful ingress from ALL ports in source CIDR block to TCP port 2049.
   • Stateful egress from TCP ALL ports to port 2049 in destination CIDR block.
2. Set up the NFS server on an Oracle Cloud VM with Oracle Linux 8 in the private subnet, which can connect to the Autonomous Database instance.

   Compute Instance Image: Oracle-Linux-8.8-2023.09.26-0
   $ sudo su -
   $ mkdir /exports
   $ chown nobody /exports
   $ chgrp nobody /exports
    
   # If the VM is using Linux 7, "data" directory may need having the privilege 777 so that ADB can have access to NFS.
   uname -a
   chmod 777 /exports/data
    
   $ mkdir /exports/data
   $ chown nobody /exports/data
   $ chgrp nobody /exports/data
    
   # Either the private IP or the private FQDN can be used in "/etc/exports".
   # Both can be found in the information of the autonomous database on the OCI console.
   $ tee -a /etc/exports <<'EOF'
     /exports/data *(rw,insecure)
     /exports/data example.adb.us-phoenix-1.oraclecloud.com(rw,insecure)
     EOF
    
   $ systemctl start nfs-server
   $ systemctl enable nfs-server
    
   # Configure the firewall to allow NFS connections. "public" is the default zone on Oracle Cloud VM.
   $ firewall-cmd --get-default-zone
   public
    
   $ firewall-cmd --zone=public --add-service=nfs
   $ firewall-cmd --permanent --zone=public --add-service=nfs
    
   $ firewall-cmd --reload
    
   # Display a list of the exported file systems.
   $ showmount -e
    
   # Displays all of the current clients and all of the file systems that the clients have mounted.
   $ showmount -a

3. Mount the NFSv4 file system with DBMS_CLOUD_ADMIN.ATTACH_FILE_SYSTEM.

   See Attach Network File System to Autonomous Database for more information.

The DBA_CLOUD_FILE_SYSTEMS view lists information about the network file system attached to a directory location in the database.