[oracle@dbserver ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 1 02:39:44 2014
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, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> create tablespace eisoo1 datafile '+RAW12' size 100M autoextend on;
create tablespace eisoo1 datafile '+RAW12' size 100M autoextend on
*
ERROR at line 1:
ORA-01119: error in creating database file '+RAW12'
ORA-15045: ASM file name '+RAW12' is not in reference form
ORA-17502: ksfdcre:5 Failed to create file +RAW12
ORA-15081: failed to submit an I/O operation to a disk
SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 1 02:39:44 2014
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, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> create tablespace eisoo1 datafile '+RAW12' size 100M autoextend on;
create tablespace eisoo1 datafile '+RAW12' size 100M autoextend on
*
ERROR at line 1:
ORA-01119: error in creating database file '+RAW12'
ORA-15045: ASM file name '+RAW12' is not in reference form
ORA-17502: ksfdcre:5 Failed to create file +RAW12
ORA-15081: failed to submit an I/O operation to a disk
SQL>
查看ASM磁盘权限
[root@dbserver raw]# ls -al /dev/raw/raw*
crw-rw---- 1 grid asmadmin 162, 1 10-01 02:44 /dev/raw/raw1
crw-rw---- 1 grid asmadmin 162, 2 10-01 02:44 /dev/raw/raw2
crw-rw---- 1 grid asmadmin 162, 3 10-01 02:44 /dev/raw/raw3
crw-rw---- 1 grid asmadmin 162, 4 10-01 02:20 /dev/raw/raw4
crw-rw---- 1 grid asmadmin 162, 5 10-01 02:21 /dev/raw/raw5
查看$ORACLE_HOME/bin/oracle权限
[oracle@dbserver bin]$ ls -al oracle
-rwsr-s--x 1 oracle asmadmin 210824714 2013-08-20 oracle
确保$ORACLE_HOME/bin/oracle与ASM磁盘属于同一个用户组,并chmod +s oracle
然后重启oracle实例。