Overview

DBFS or database file system is another twerk of oracle. Basically it is similiar to the NFS in a sense that it can be mounted and dismounted, but also, it can be registered in a GRID infrastructure. That will allow it to failvoer in case of failure of one of the instances, so let's see how it is done.

Creation

To create DBFS we need couple things:

Edit FUSE config (that is the config file for the FUSE package needed for the DBFS.

Create folder (owned under oracle user and dba group)

Create a tablespace which will host the DBFS

Create user with the necessary permission

Create the DBFS env on the database

Configure the libraries

So let's get started:

First, we have to edit the configuration for FUSE:

Edit FUSE config

Then we have to create the directory:

Create directory

Optionally we can configure NOCACHE for the LOB of the DBFS table:

Modify DBFS table

After that, we have to create the Tablespace, user and the environment:

Configure DBFS on the database

Configure the libraries:

Configure Libraries

Management

The management of DBFS, includes, stop/start and registartion in the Grid Infra:

Start/Stop

Start DBFS

Register DBFS into Grid Infra

We can register the DBFS into Grid infra and though allow failover if the instance crashes:

Register DBFS into Grid Infra

Appendix

Below you can find the script we have used.

mount-dbfs.sh

add-dbfs-resource.sh