Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > Oracle database filesystem (DBFS) 简单配置文档

Oracle database filesystem (DBFS) 简单配置文档

WBOY
Release： 2016-06-07 17:14:40
Original
1406 people have browsed it

Oracle database filesystem (DBFS) 简单配置文档

本机环境：11.2.0.1 

1. download fuse package on website


download 2.7.4 版本

看一下需要的rpm包
rpm -q kernel-devel
kernel-devel-2.6.18-308.el5

2. 安装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. 服务器端创建脚本


SQL> create smallfile tablespace dbfsts 
  2  datafile '+JAMES' size 200m ;

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 会在在你客户端的挂载点下面创建一个fs1 的文件夹，，并且会在dbfsusr用户下创建一个名为t_fs1 的表
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. 客户端配置：
创建文件夹（保证权限）
mkdir /u02

客户端使用这个命令即可挂载：

dbfs_client dbfsusr@james /u02

或者
nohup dbfs_client dbfsusr@james /u02

然后看一下

[oracle@oel1 ~]$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1              15G  7.5G  6.3G  55% /
/dev/sda5             2.0G   36M  1.9G   2% /tmp
/dev/sda2              15G  8.4G  5.4G  61% /u01
tmpfs                 2.0G  367M  1.6G  19% /dev/shm
dbfs                  448K   27K  421K   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              15G  7.5G  6.3G  55% /
/dev/sda5             2.0G   36M  1.9G   2% /tmp
/dev/sda2              15G  8.4G  5.4G  61% /u01
tmpfs                 2.0G  367M  1.6G  19% /dev/shm
dbfs                  1.5M  531K  941K  37% /u02

可以看到这个文件系统是自动拓展的。

linux
Related labels：
Oracle存储过程 Oracle database fil
source：php.cn
Previous article：Oralce之递归算法 Next article：Ubuntu 12.04 下安装MySQL 5.5.25
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
What are the best practices for displaying version information in web applications? I'm developing a web application. What are the best practices for displaying version infor...
From 2024-04-06 19:13:16
0
2
476
Possibility to store ASP Classic code as string in MYSQL database Is it possible to store asp classic code into a MySQL database and have it execute the cod...
From 2024-04-06 13:38:43
0
1
358
Unable to get cookie data from Go server using React After React I started going into the backend and added githubOAUTH and sessions on the bac...
From 2024-04-06 13:09:26
0
1
384
Push objects to array, composable API There is a project. There are two selection options "size" (large, small) and qu...
From 2024-04-05 14:41:47
0
1
1526
How to update a React component's dependencies in useEffect without creating an infinite loop I have a React component where I need to wait for a stored value (member) to update and th...
From 2024-04-05 14:31:46
0
1
1383
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template