Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to use the dbfs file system in oracle. It is very detailed and has a certain reference value. Friends who are interested must finish it!

1. Introduction of DBFS

Dbfs creates a standard file system structure on top of files and directories and stores data in the database base table. DBFS is much like NFS in that it provides a shared network file system that is the same as the local file system. Like NFS, it consists of Server and Client.

In DBFS, Server is the Oracle database, and the file is stored in a SecureFiles LOBs field of the table. A collection of PLSQL stored procedures that provide basic operations for accessing the file system, such as create, open, read, and write,ls. The DBFS catalog library allows each database user to create one or more file systems that can be used by clients. Each file system has proprietary data tables that guarantee the contents of the file system.

2. Install fuse on client side

Determine the fuse version

Uname-a

Linux DB-SERVER-02 2.6.18-164.el5#1 SMP Tue Aug 18 15:51:48 EDT 2009 x86 "64 GNU/Linux

Native kernelversion 2.6.18

Kernel version 2.6.x

Fuse-2.7.4 is required for x > 9.

Download the fuse installation package

Download address:

Http://fuse.sourceforge.net

Or

Http://sourceforge.net/projects/fuse

Check the kernel-devel package

# rpm-Q kernel-devel

If it is not installed, install package after mounting the installation disk

Install fuse

$tar-xzvf fuse-2.7.4.tar.gz

$cd [fuse_src_dir]

$. / configure-prefix=/usr-with-kernel= [yourkernel dir]

$make

$sudo su

# make install

# / sbin/depmod

# / sbin/modprobe fuse

# chmod 666 / dev/fuse

# echo "/ sbin/modprobe fuse" > > / etc/rc.modules

Example

Check to see if the required installation package is installed

[root@mytest] # rpm-Q kernel-devel

Package kernel-devel is not installed

Mount the CD

[root@mytest dev] # mount / dev/hdc / mnt

Mount: block device / dev/hdc iswrite-protected, mounting read-only

Install the kernel-devel package

[root@mytest Server] # rpm-ivh kernel-devel-2.6.18-308.el5.x86_64.rpm

Preparing... # [100%]

1:kernel-devel # # [100%]

View kernelversion

[root@mytest Server] # uname-a

Linux mytest 2.6.18-308.el5#1 SMP Sat Feb 25 12:40:07 EST 2012 x86 "64 GNU/Linux

Ftp uploads fuse2.7.4 to the server / root directory

[root@mytest ~] # pwd

/ root

[root@mytest ~] # ls-l fuse-2.7.4.tar.gz

-rw-r--r-- 1 root root 506658 Jun 11 13:54 fuse-2.7.4.tar.gz

Decompression

[root@mytest ~] # tar-xzvf fuse-2.7.4.tar.gz

[root@mytest ~] # cd fuse-2.7.4

Installation

[root@mytest fuse-2.7.4] #. / configure

[root@mytest fuse-2.7.4] # make

[root@mytest fuse-2.7.4] # make install

[root@mytest fuse-2.7.4] # / sbin/depmod

[root@mytest fuse-2.7.4] # / sbin/modprobe fuse

[root@mytest fuse-2.7.4] # chmod 666 / dev/fuse

[root@mytest fuse-2.7.4] # echo "/ sbin/modprobe fuse" > > / etc/rc.modules

Third, Oracle database configuration on the server side.

Server side configuration process

1 create a tablespace

The newly created tablespace is used to store related data in dbfs.

2 create a user

New users are used to manage dbfs-related files and source data

3 Authorization

Users who manage dbfs need to have relevant permissions

4 execute dbfs initialization script

Dbfs configuration script path:

$ORACLE_HOME/rdbms/admin/dbfs_create_filesystem_advanced

Note that the script needs to be executed with the newly created user.

Example

Log in using the dba user

[oracle@mytest~] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0Production on Thu Aug 2 13:40:42 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

Open the database

SQL > startup

ORACLE instance started.

Total System Global Area 1653518336 bytes

Fixed Size 2213896 bytes

Variable Size 956303352 bytes

Database Buffers 687865856 bytes

Redo Buffers 7135232 bytes

Database mounted.

Database opened.

Create a tablespace fsts (here large file tablespaces are used)

SQL > create bigfile tablespace fsts

2 datafile'/ u01amp appsUniplicoracleUniplicoradataUniver, David Universe fsts01.dbf'

3 size500m

Tablespace created.

Create user dexter

SQL > create user dexter identified byxiaojun default tablespace fsts quota unlimited on fsts

User created.

Authorization

SQL > grant create session,create table, create procedure, dbfs_role to dexter

Grant succeeded.

SQL > conn dexter/xiaojun

Connected.

Execute initialization script

SQL > @? / rdbms/admin/dbfs_create_filesystem_advanced fsts dir1 nocompressnodeduplicate noencrypt non-partition

IV. Client mount

The client needs to use the dbfs_client command, and the related programs are all in Oracle client, so the client must install Oracle client.

Client configuration proc

1. Use root users

2. Add a new library path.

Command:

# echo "/ usr/local/lib" > > / etc/ld.so.conf.d/usr_local_lib.conf

3. Change directory to lib, and create thefollowing symbolic links to the

Libclntsh.so.11.1 and libnnz11.so libraries.

Command:

# cd / usr/local/lib

# ln-s $ORACLE_HOME/lib/libclntsh.so.11.1

# ln-s $ORACLE_HOME/lib/libnnz11.so

4. Locate libfuse.so, and create a symbolic linkthis library.

# locate libfuse.so

Determined_path / libfuse.so

Command:

# ln-s determined_path / libfuse.so

5. Run ldconfig to create the links and cache for the new symbolic links.

Command:

# ldconfig

6. Create a symbolic link to dbfs_client in / sbin as mount.dbfs.

Command:

# ln-s $ORACLE_HOME/bin/dbfs_client/sbin/mount.dbfs

7. Login as admin user. (Oracle recommends th atyou do not perform the next step

As root user.)

8. Mount the DBFS store.

Command:

% dbfs_client @ / dbfsdb-owallet,rw,user,direct_io / mnt/dbfs

9. [Optional] To test if the previo us step wassuccessful, list the dbfs directory.

Command:

# ls / mnt/dbfs

Execute in the background:

Nohup dbfs_client ETLUser@DBConnectString/mnt/dbfs

< passwordfile.f & 示例 [oracle@mytest~]$ mkdir /u01/dbfs [oracle@mytest~]$ ls -l /u01 drwxr-xr-x 2 oracle oinstall 4096 Aug 2 13:51 dbfs [root@mytest~]# echo "/usr/local/lib" >

> / etc/ld.so.conf.d/usr_local_lib.conf

[root@mytest~] # cd / usr/local/lib

[root@mytestlib] # ln-s / u01/apps/oracle/product/11gr2/db_1/lib/libclntsh.so.11.1

[root@mytestlib] # ln-s / u01/apps/oracle/product/11gr2/db_1/lib/libnnz11.so

[root@mytestlib] # find /-name libfuse.so

/ usr/local/lib/libfuse.so

[root@mytestlib] # ln-s / usr/local/lib/libfuse.so

[root@mytestlib] # ldconfig

[root@mytestlib] # ln-s / u01/apps/oracle/product/11gr2/db_1/bin/dbfs_client/sbin/mount.dbfs

[root@mytestlib] # su-oracle

Configure password file

Using the oracle user as the administrative user of the dbfs mount

Create a password file

Echo xiaojun > passwd.t

View client configuration

[oracle@mytest~] $vi $ORACLE_HOME/network/admin/tnsnames.ora

DAVID =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = mytest) (PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = david)

)

)

You can log in remotely

[oracle@mytest~] $sqlplus dexter/xiaojun@david

SQL*Plus: Release 11.2.0.1.0Production on Thu Aug 2 14:17:32 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the Partitioning, OLAP, Data Mining andReal Application Testing options

SQL >

Execute mount command

Nohup dbfs_client dexter@david / u01/dbfs

< passwd.t & [1] 11665 [oracle@mytest ~]$ nohup: appending outputto `nohup.out' [oracle@mytest ~]$ df -h Filesystem Size Used Avail Use% Mounted on /dev/sda1 30G 15G 14G 53% / /dev/sda3 3.9G 473M 3.3G 13% /tmp tmpfs 2.0G 943M 1.1G 48% /dev/shm /dev/hdc 3.7G 3.7G 0 100% /mnt dbfs 1.5M 57K 1.4M 4% /u01/dbfs 五、测试 [oracle@mytest ~]$ ll /u01 drwxr-xr-x 3 root root 0 Aug 2 14:20 dbfs [oracle@mytest ~]$ ll /u01/dbfs/ total 0 drwxrwxrwx 3 root root 0 Aug 2 14:09 dir1 [oracle@mytest~]$ echo test >

/ u01/dbfs/dir1/test.t

[oracle@mytest~] $ll / u01/dbfs/dir1/

Total 1

-rw-r--r--1 oracle oinstall 5 Aug 2 14:21 test.t

[oracle@mytest ~] $cat / u01/dbfs/dir1/test.t

Test

[oracle@mytest~] $mkdir / u01/dbfs/dir1/sub_dir

[oracle@mytest~] $echo ffccddssdd > / u01/dbfs/dir1/sub_dir/test2.t

[oracle@mytest~] $sqlplus dexter/xiaojun@david

SQL*Plus: Release 11.2.0.1.0Production on Thu Aug 2 14:28:49 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the Partitioning, OLAP, Data Mining andReal Application Testing options

Pathtype=1 for file 2 for directory

[sql] view plaincopyprint?

1. SQL > select pathname, item, pathtype from t_dir1

2. PATHNAME ITEM PATHTYPE

3.-

4. / test.t test.t 1

5. / sub_dir sub_dir 2

6. / sub_dir/test2.t test2.t 1

7. / ROOT 2

8. /. Sfs .sfs 2

9. /. Sfs/attributes attributes 2

10. /. Sfs/tools tools 2

11. /. Sfs/snapshots snapshots 2

12. /. Sfs/RECYCLE RECYCLE 2

13. /. Sfs/content content 2

14.

15. 10 rows selected.

SQL > select pathname, item, pathtype from t_dir1

PATHNAME ITEM PATHTYPE

/ test.t test.t 1

/ sub_dir sub_dir 2

/ sub_dir/test2.t test2.t 1

/ ROOT 2

/. Sfs .sfs 2

/. Sfs/attributes attributes 2

/. Sfs/tools tools 2

/. Sfs/snapshots snapshots 2

/. Sfs/RECYCLE RECYCLE 2

/. Sfs/content content 2

10 rows selected.

Configuration complete

The above is all the contents of the article "how to use the dbfs file system in oracle". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.