oracle 11gR2 rac 建立database報ORA-00200錯誤

paulyibinyi發表於2010-07-08

   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

屬性值對後,建立資料庫正常,前期盤的規劃屬性一定要設定準確。

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-667597/,如需轉載,請註明出處,否則將追究法律責任。

相關文章