Post-Install Database Tasks - Oracle Exadata Recipes: A Problem-Solution Approach - page 590

REGISTER STORE:
begin dbms_dbfs_content.registerStore(store_name=> 'FS_DATA_DBFS', provider_name
=> 'sample1', provider_package => 'dbms_dbfs_sfs'); end;
--------
MOUNT STORE:
begin dbms_dbfs_content.mountStore(store_name=>'FS_DATA_DBFS',
store_mount=>'DATA_DBFS'); end;
--------
CHMOD STORE:
declare m integer; begin m := dbms_fuse.fs_chmod('/DATA_DBFS', 16895); end;
No errors.
SQL>

7. Once your DBFS data store (file system) is created, you need to mount it. The first thing you

should need to do is create a text file containing the DBFS password. Below, we've created
this password file in /home/oracle/dbfs/passwd.txt on both nodes of our Quarter Rack:

■ this password file is only required when mounting the DBFS file system. once it is mounted, you do not need
the password file.

Note

[oracle@cm01dbm01 ~]$ echo "dbfs" > /home/oracle/dbfs/passwd.txt
[oracle@cm01dbm01 ~]$ scp /home/oracle/dbfs/passwd.txt oracle@cm01dbm02:/home/oracle/dbfs
passwd.txt
100% 5 0.0KB/s 00:00
[oracle@cm01dbm01 ~]$

Next, mount your DBFS file system on each node using the command below: 8.

[oracle@cm01dbm01 ~]$ nohup $ORACLE_HOME/bin/dbfs_client dbfs@visx \
> -o allow_other,direct_io /data_dbfs < /home/oracle/dbfs/passwd.txt &
[1] 8060
[oracle@cm01dbm01 ~]$ nohup: appending output to 'nohup.out'

[oracle@cm01dbm01 ~]$ ls /data_dbfs
DATA_DBFS
[oracle@cm01dbm01 ~]$

9. Once mounted, list the contents of your file system directory and validate from each

compute node:

[oracle@cm01dbm01 ~]$ ls /data_dbfs
DATA_DBFS
[oracle@cm01dbm01 ~]$

10. After the file system is created and mounted, you're going to need to complete a few more

tasks so that you can use it:

a. Create an Oracle directory pointing to the DBFS file system mount point

b. Grant permissions on the directory to whatever Oracle user needs to access it