oracle 11gR2 rac 创建数据库database报ORA-00200错误
oracle 11gR2 rac 创建数据库database报ORA-00200错误
oracle 11gR2 rac创建数据库时,报ORA-00200错误,提示权限不够
NOTE: MARK has subscribed
NOTE: Loaded library: System
SUCCESS: diskgroup TESTDG was mounted
Errors in file /u01/app/oracle/diag/rdbms/racdb/racdb1/trace/racdb1_ora_16324.trc:
ORA-27091: unable to queue I/O
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
WARNING: IO Failed. group:2 disk(number.incarnation):0.0xe9684807 disk_path:/dev/raw/raw1
AU:32 disk_offset(bytes):134217728 io_size:16384 operation:Write type:synchronous
result:I/O error process_id:16324
Errors in file /u01/app/oracle/diag/rdbms/racdb/racdb1/trace/racdb1_ora_16324.trc:
ORA-15080: synchronous I/O operation to a disk failed
WARNING: failed to write mirror side 1 of virtual extent 0 logical extent 0 of file 256 in group 2 on disk 0 allocation unit 32
Errors in file /u01/app/oracle/diag/rdbms/racdb/racdb1/trace/racdb1_ora_16324.trc:
ORA-00200: control file could not be created
ORA-00202: control file: '+TESTDG'
ORA-15045: ASM file name '+TESTDG' is not in reference form
ORA-17502: ksfdcre:5 Failed to create file +TESTDG
ORA-15081: failed to submit an I/O operation to a disk
ORA-1501 signalled during: CREATE DATABASE "racdb"
MAXINSTANCES 32
MAXLOGHISTORY 1
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
DATAFILE SIZE 700M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE SIZE 600M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE SIZE 20M AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE SIZE 200M AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 SIZE 51200K,
GROUP 2 SIZE 51200K
USER SYS IDENTIFIED BY *USER SYSTEM IDENTIFIED BY ...
Thu Jul 08 16:47:59 2010
Shutting down instance (abort)
License high water mark = 1
USER (ospid: 16394): terminating the instance
Instance terminated by USER, pid = 16394
Thu Jul 08 16:47:59 2010
Instance shutdown complete
通过检查盘的属性为 640
[grid@rac2 raw]$ ls -ltr
total 0
crw-r---- 1 grid asmadmin 162, 1 Jul 8 16:43 raw1
crw-r---- 1 grid asmadmin 162, 2 Jul 8 17:11 raw2
正确的属性值为660
chmod 660 raw*
[grid@rac2 raw]$ ls -ltr
total 0
crw-rw---- 1 grid asmadmin 162, 1 Jul 8 16:43 raw1
crw-rw---- 1 grid asmadmin 162, 2 Jul 8 17:11 raw2
属性值对后,创建数据库正常,前期盘的规划属性一定要设置准确。