ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 创建raw device tablespace报Linux Error: 13: Permission denied

创建raw device tablespace报Linux Error: 13: Permission denied

原创 Linux操作系统 作者:wisdomone1 时间:2013-06-21 18:43:56 0 删除 编辑

---查询oracle用户的用户组
[root@rhel5 ~]# id oracle
uid=502(oracle) gid=102(oinstall) groups=102(oinstall),103(dba)

---给新建的卷组vg2授权
[root@rhel5 ~]# chown -Rf oracle:oinstall /dev/vg2
[root@rhel5 ~]# chmod -Rf 777 /dev/vg2

---切到oracle
[root@rhel5 ~]# su - oracle
-bash-3.2$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jun 21 10:02:56 2013

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  313860096 bytes
Fixed Size                  1336232 bytes
Variable Size             159386712 bytes
Database Buffers          146800640 bytes
Redo Buffers                6336512 bytes
Database mounted.
Database opened.

SQL> select file#,name from v$datafile

     FILE# NAME
---------- --------------------------------------------------
         1 /oracle/app/oracle/oradata/zxy/system01.dbf
         2 /oracle/app/oracle/oradata/zxy/sysaux01.dbf
         3 /oracle/app/oracle/oradata/zxy/undotbs01.dbf
         4 /oracle/app/oracle/oradata/zxy/users01.dbf
         5 /oracle/newwisdomone.dbf
         6 /oracle/rawfile
         7 /oracle/rawfile2
         8 /oracle/tbs_mod1.dbf
         9 /oracle/tbs_mod2_newposition.dbf

9 rows selected.

---创建裸设备表空间报权限不足
SQL> create tablespace tbs_top datafile '/dev/vg2/lv2' size 30m;
create tablespace tbs_top datafile '/dev/vg2/lv2' size 30m
*
ERROR at line 1:
ORA-01119: error in creating database file '/dev/vg2/lv2'
ORA-27041: unable to open file
Linux Error: 13: Permission denied
Additional information: 1

---确认卷组vg2的权限与用户组,是正确的
[root@rhel5 ~]# ls -l /dev/vg2
total 0
lrwxrwxrwx 1 oracle oinstall 19 Jun 21 09:59 lv2 -> /dev/mapper/vg2-lv2 ----注意:这里lv2是个链接文件
[root@rhel5 ~]# ls -l /oracle/tbs_mod2_newposition.dbf
-rw-r----- 1 oracle oinstall 26222592 Jun 21 10:03 /oracle/tbs_mod2_newposition.dbf
[root@rhel5 ~]# ls -l /dev/vg2/lv2
lrwxrwxrwx 1 oracle oinstall 19 Jun 21 09:59 /dev/vg2/lv2 -> /dev/mapper/vg2-lv2

----查看lv2链接文件对应的真正文件
[root@rhel5 ~]# ls -l /dev/mapper/vg2-lv2
brw-rw---- 1 root disk 253, 1 Jun 21 09:59 /dev/mapper/vg2-lv2 --可以看到还是root:disk


----给lv2对应的真正文件授权
[root@rhel5 ~]# chown -Rf oracle:oinstall /dev/mapper/vg2-lv2
[root@rhel5 ~]# ls -l /dev/mapper/vg2-lv2
brw-rw---- 1 oracle oinstall 253, 1 Jun 21 09:59 /dev/mapper/vg2-lv2


[root@rhel5 ~]# chmod -Rf 777 /dev/mapper/vg2-lv2
[root@rhel5 ~]# su - oracle
-bash-3.2$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jun 21 10:07:28 2013

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

---创建裸设备表空间成功
SQL> create tablespace tbs_top datafile '/dev/vg2/lv2' size 30m;

Tablespace created.


---为了防止重启主机反复授权直接添加裸设备的链接及真正文件到/etc/profile中
[root@rhel5 ~]# tail -5 /etc/profile
chown -Rf oracle:oinstall /dev/mapper/vg2-lv2
chmod -Rf 777 /dev/mapper/vg2-lv2
chown -Rf oracle:oinstall /dev/vg2
chmod -Rf 777 /dev/vg2

 

小结:

      1,链接与真正设备文件都要进行授权

      2,上述授权脚本写入到/etc/profile中

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9240380/viewspace-764556/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
提供针对oracle初学者及进阶的数据库培训,欢迎大家咨询: 微信: wisdomone 微信公众号: lovedb 工作经历: 中国普天 北京科蓝 北京云和恩墨 北京神州新桥

注册时间:2008-04-04

  • 博文量
    2189
  • 访问量
    12689906