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
屬性值對後,建立資料庫正常,前期盤的規劃屬性一定要設定準確。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-667597/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 11gR2 RAC連線報錯ora-12537錯誤Oracle
- Oracle DataGuard Standby database ID mismatch錯誤OracleDatabase
- How to create and relocate an 11gr2 RAC DATABASE SERVICEDatabase
- 解決:客戶端連線11gR2 RAC報ORA-12545錯誤客戶端
- aix下的oracle oracle 10g rac報ora-04030錯誤AIOracle 10g
- Oracle 11gR2 RAC Database使用emca配置叢集dbconsoleOracleDatabase
- navicat 建立事件報語法錯誤事件
- 11gR2 RAC安裝時遇到的一些錯誤
- [排錯]安裝Oracle 10g RAC報Failure at final check of Oracle CRS stack 10錯誤Oracle 10gAI
- oracle 報大小寫錯誤Oracle
- rac錯誤除錯除錯
- 11GR2執行DBCA報錯誤(打補丁)
- oracle 客戶端連線11gR2 SCAN 報ORA-12545錯誤Oracle客戶端
- Oracle 11g RAC操作DBCA期間報ORA-04031錯誤Oracle
- oracle 11gR2 RAC root.sh 錯誤 ORA-15072 ORA-15018Oracle
- Oracle RAC 錯誤記錄以及處理方法Oracle
- oracle 11gr2 rac 安裝Oracle
- oracle RAC中表空間資料檔案錯誤建立到了節點本地位置Oracle
- How to drop Oracle RAC database manually?OracleDatabase
- 1 Oracle Database 11.2.0.3.0 RAC On Oralce Linux 6.5 使用-建立共享磁碟OracleDatabaseLinux
- oracle 10g rac安裝報錯Oracle 10g
- Oracle Database 11gR2引入的DBFS(Database File System)OracleDatabase
- Oracle Database 11gR2 OEM故障排除案例OracleDatabase
- Oracle RAC中ORA-01843錯誤分析Oracle
- oracle 11gR2 關閉asm例項 報ORA-01031 錯誤處理OracleASM
- duplicate standby database 報ORA-05507錯誤解決方法Database
- Oracle 11gR2 RAC修改SCAN IPOracle
- RMAN備份報錯ORA-27040: skgfrcre: 建立錯誤,無法建立檔案
- Oracle 11.2.0.4 RAC Database for Windows 2012安裝DB時收到[INS-35423]錯誤OracleDatabaseWindows
- oracle10g rac 報ora-12545錯誤的解決方案(zt)Oracle
- 連線11gR2 RAC時收到ORA-12502報錯
- 一步一步搭建oracle 11gR2 rac+dg之database安裝(五)OracleDatabase
- opensips建立資料庫時報database engine not specified錯誤的解決資料庫Database
- 11gR2 syaasm連線錯誤ASM
- Oracle DataBase單例項遷移到Oracle RACOracleDatabase單例
- 【RAC安裝】 AIX下安裝Oracle 11gR2 RACAIOracle
- Create RAC Standby Database for RAC Primary DatabaseDatabase
- Oracle DG建立Physical Standby DatabaseOracleDatabase