Oracledatabasefilesystem (DBFS) simple configuration document
Oracle database filesystem (DBFS) simple configuration document
Local Environment: 11.2.0.1
1. download fuse package on website
Download 2.7.4
Check the rpm package.
Rpm-q kernel-devel
Kernel-devel-2.6.18-308.el5
2. Install fuse
Tar-xzvf fuse-2.7.4.tar.gz
./Configure
Make
Make install
/Sbin/depmod
/Sbin/modprobe fuse
Chmod 666/dev/fuse
Echo "/sbin/modprobe fuse">/etc/rc. modules
3. Create a script on the server
SQL> create smallfile tablespace dbfsts
2 datafile '+ JAMES' size 200 m;
SQL> create user dbfsusr identified by xiaojun default tablespace dbfsts quota unlimited on dbfsts;
SQL> grant create session, create table, create procedure, dbfs_role to dbfsusr;
SQL> conn dbfsusr/xiaojun
Connected.
Create:
-- Fs1 creates a fs1 folder under the mount point of your client, and creates a table named t_fs1 under dbfsusr.
SQL> @ $ Oracle_HOME/rdbms/admin/dbfs_create_filesystem_advanced dbfsts fs1 nocompress nodeduplicate noencrypt non-partition
Drop:
@ $ ORACLE_HOME/rdbms/admin/dbfs_drop_filesystem. SQL file system name
4. Client Configuration:
Create a folder (Ensure permissions)
Mkdir/u02
The client can use this command to mount:
Dbfs_client dbfsusr @ james/u02
Or
Nohup dbfs_client dbfsusr @ james/u02 <passwd.txt &
Then let's take a look.
[Oracle @ oel1 ~] $ Df-h
Filesystem Size Used Avail Use % Mounted on
/Dev/sda1 15 GB 7.5G 6.3G 55%/
/Dev/sda5 2.0G 36 M 1.9G 2%/tmp
/Dev/sda2 15G 8.4G 5.4G 61%/u01
Tmpfs 2.0G 367 M 1.6G 19%/dev/shm
Dbfs 448 K 27 K 421 K 7%/u02
[Oracle @ oel1 ~] $ Cp/u01/fuse-2.7.4.tar.gz/u02/fs1/
[Oracle @ oel1 ~] $ Df-h
Filesystem Size Used Avail Use % Mounted on
/Dev/sda1 15 GB 7.5G 6.3G 55%/
/Dev/sda5 2.0G 36 M 1.9G 2%/tmp
/Dev/sda2 15G 8.4G 5.4G 61%/u01
Tmpfs 2.0G 367 M 1.6G 19%/dev/shm
Dbfs 1.5 M 531 K 941 K 37%/u02
The file system is automatically expanded.
