[20120926]DBFS测试.txt

[20120926]DBFS测试.txt

    DBFS就是Oracle数据库11gR2中提供的能够在Linux操作系统中将Oracle数据库当成文件系统来使用的功能。在DBFS内部，

文件是以SecureFiles LOBs（对比与以前的BasicFiles LOBs）的形式存储在数据表中。

    自己做一些测试:

    在测试过程中参考了链接: http://juliandyke.wordpress.com/2011/11/02/dbfs/

SQL> select  * from v$version ;

BANNER

--------------------------------------------------------------------------------

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

PL/SQL Release 11.2.0.1.0 - Production

CORE    11.2.0.1.0      Production

TNS for Linux: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production

看了一些文档,要安装fuse.http://fuse.sourceforge.net

我的测试机器是Red Hat Enterprise Linux AS release 4 (Nahant Update 3),很老的系统,内核

# cat /proc/version

Linux version 2.6.9-34.ELsmp (bhcompile@hs20-bc1-1.build.redhat.com) (gcc version 3.4.5 20051201 (Red Hat 3.4.5-2)) #1 SMP Fri Feb 24 16:56:28 EST 2006

我选择fuse-2.7.4.tar.gz来安装,

其他我测试没有生成fuse模块,很久没有搞kernel这些东西,暂时先放一下.

编译很简单,三部曲,解压,进入目录:

./configure

make 

make install

# /sbin/modprobe fuse

# chmod 666 /dev/fuse

1.建立DBFS文件系统:

create tablespace dbfs datafile '/u01/app/oracle11g/oradata/test/dbfs01.dbf' size 100m;

$ sqlplus / as sysdba

SQL> grant dbfs_role to scott;

Grant succeeded.

链接: http://juliandyke.wordpress.com/2011/11/02/dbfs/

    To create a file system use the dbms_create_filesystem.sql script. which is located in $ORACLE_HOME/rdbms/admin. This script

calls dbms_create_filesystem_advanced.sql which is located in the same directory. In my version, SQL*Plus was unable to locate

the latter script. unless it was in the current working directory. Therefore I had to change directory to $ORACLE_HOME/rdbms/admin

before executing SQL*Plus. For example:

    建立文件系统使用脚本dbms_create_filesystem.sql,位于$ORACLE_HOME/rdbms/admin.

[oracle@server1]$ cd $ORACLE_HOME/rdbms/admin

[oracle@server1]$ sqlplus scott/xxxx

SQL> @dbfs_create_filesystem.sql DBFS dbfs

链接: http://juliandyke.wordpress.com/2011/11/02/dbfs/

    The dbfs_create_filesystem.sql script. takes two parameters; the tablespace name (DBFS1) and the file system name (dbfs1).

In retrospect I should have assigned different names to the tablespace and file system.

--注意我的表空间dbfs,file system name=>dbfs.定义与他的不同.

2.安装DBFS文件系统:

    Now the new file system exists within the database. However, we cannot access it externally yet. A new utility called 

dbms_client which is shipped in $ORACLE_HOME/bin in Oracle 11.2.0.1 and above.allows the DBFS file system to be mounted 

and managed from the command line. The 11.2.0.1 version of this utility is quite basic and it is easy to imagine customer

feedback will drive improvements in functionality in subsequent releases.

    As the root user create a mount point. In this case the mount point will be called /mnt/dbfs1 and will be owned by the 

oracle user:

[root@server1]# mkdir /mnt/dbfs

[root@server1]# chown oracle:dba /mnt/dbfs

[root@server1]# chmod 775 /mnt/dbfs ==> 这个是我添加,不然mount会错误.

=> fusermount: user has no write access to mountpoint /mnt/dbfs

    In Oracle 11.2.0.1, unlike almost all other tools and utilities in $ORACLE_HOME/bin the dbms_client utility does not have

a wrapper script. On my server invoking dbfs_client failed with the following error:

[oracle@server1]$ cd $ORACLE_HOME/bin

[oracle@server1]$ ./dbfs_client

    ./dbfs_client: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory

--^_^,我的正常,没有这个提示,说明LD_LIBRARY_PATH环境变量配置正确.....

    This version of the dbfs_client utility does not support the bequeath protocol, so on the server it is not possible to 

identify the target instance using the $ORACLE_SID environment variable. It is therefore necessary to ensure that a TNS 

address is specified in $TNS_ADMIN/tnsnames.ora.

TEST=

(DESCRIPTION=

  (ADDRESS=

    (PROTOCOL=TCP)(HOST=vm7)(PORT=1521)

  )

  (CONNECT_DATA=(SERVICE_NAME=TEST))

)

--按照这个建议,需要配置tnsnames.ora.即使在服务端.

安装dbfs的命令如下:

$ cd $ORACLE_HOME/bin

$ ./dbfs_client scott@40 /mnt/dbfs

    A password will be requested. In this case it is the Oracle database password for the US01 user.

    By default dbfs_client will block until the file system is un-mounted.

    In this version it is possible to workaround the blocking of dbfs_client using the nohup command to run the utility in 

the background. For example:

[oracle@server1]$ cd $ORACLE_HOME/bin

[oracle@server1]$ nohup ./dbfs_client scott@40 /mnt/dbfs &

    In another shell session verify that the file system has been mounted using the mount command. For example:

# mount | column -t

/dev/sda3  on  /                         type  ext3         (rw)

none       on  /proc                     type  proc         (rw)

none       on  /sys                      type  sysfs        (rw)

none       on  /dev/pts                  type  devpts       (rw,gid=5,mode=620)

usbfs      on  /proc/bus/usb             type  usbfs        (rw)

/dev/sda2  on  /boot                     type  ext3         (rw)

none       on  /dev/shm                  type  tmpfs        (rw,size=3G)

/dev/sda6  on  /u01                      type  ext3         (rw)

/dev/sdb1  on  /data                     type  ext3         (rw)

none       on  /proc/sys/fs/binfmt_misc  type  binfmt_misc  (rw)

sunrpc     on  /var/lib/nfs/rpc_pipefs   type  rpc_pipefs   (rw)

dbfs       on  /mnt/dbfs                 type  fuse         (rw,nosuid,nodev,max_read=1048576,default_permissions,user=oracle11g)

=>按照文档的提示,执行后挂在后台,知道umount才退出.

    At this point it is possible to navigate into the new file system from the Linux shell using commands such as pwd, cd, 

mkdir, cp, rm etc.

这样可以像操作文件系统那样操作该目录/mnt/dbfs.

我做了一些测试:

$ ls -lR /mnt/

/mnt/:

drwxr-xr-x  3 root   root        0 Sep 26 10:50 dbfs

/mnt/dbfs:

total 0

drwxrwxrwx  3 root root 0 Sep 26 10:32 dbfs

/mnt/dbfs/dbfs:

total 0

--很奇怪,root用户看到的是这样:

# ls -l /mnt

?---------  ? ?      ?           ?            ? dbfs

$ cd /mnt/dbfs/dbfs

$ cp /tmp/fuse-2.7.4/README .

$ cp /etc/passwd .

$ ls -l

total 15

-rw-r--r--  1 oracle11g oinstall  2874 Sep 26 10:50 passwd

-rw-r--r--  1 oracle11g oinstall 11430 Sep 26 10:51 README

--感觉有点慢!不知道是否我的测试机器不行!

3.Unmounting a DBFS filesystem

    To unmount the DBFS file system use the fusemount command. For example:

fusermount -u /mnt/dbfs

$ mount | column -t

/dev/sda3  on  /                         type  ext3         (rw)

none       on  /proc                     type  proc         (rw)

none       on  /sys                      type  sysfs        (rw)

none       on  /dev/pts                  type  devpts       (rw,gid=5,mode=620)

usbfs      on  /proc/bus/usb             type  usbfs        (rw)

/dev/sda2  on  /boot                     type  ext3         (rw)

none       on  /dev/shm                  type  tmpfs        (rw,size=3G)

/dev/sda6  on  /u01                      type  ext3         (rw)

/dev/sdb1  on  /data                     type  ext3         (rw)

none       on  /proc/sys/fs/binfmt_misc  type  binfmt_misc  (rw)

sunrpc     on  /var/lib/nfs/rpc_pipefs   type  rpc_pipefs   (rw)

--只能做大概的了解.