oracle11gr2,dbca创建时使用asm,报ORA-17502报错
958941Aug 30 2012 — edited Aug 30 2012今天在用oracle11gr2,dbca创建时使用asm,报ORA-17502报错,创建日志:
ORACLE instance started.
Total System Global Area 2221395968 bytes
Fixed Size 2215264 bytes
Variable Size 1258291872 bytes
Database Buffers 956301312 bytes
Redo Buffers 4587520 bytes
CREATE DATABASE "test"
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file: '+DATA/test/control01.ctl'
ORA-15012: ASM file 'test/control01.ctl' does not exist
ORA-17502: ksfdcre:5 Failed to create file +DATA/test/control01.ctl
ORA-15081: failed to submit an I/O operation to a disk
检查下asm的磁盘确实是660权限:
[grid@dbs disks]$ ll
total 0
brw-rw---- 1 grid asmadmin 8, 17 Aug 30 10:53 OCR_VOTE01
brw-rw---- 1 grid asmadmin 8, 18 Aug 30 10:53 OCR_VOTE02
brw-rw---- 1 grid asmadmin 8, 19 Aug 30 10:53 OCR_VOTE03
brw-rw---- 1 grid asmadmin 8, 21 Aug 30 10:53 VOL1
brw-rw---- 1 grid asmadmin 8, 22 Aug 30 10:53 VOL2
brw-rw---- 1 grid asmadmin 8, 23 Aug 30 10:53 VOL3
brw-rw---- 1 grid asmadmin 8, 24 Aug 30 10:53 VOL4
diskgroup已经是mount状态,asm实例登录没问题:
SQL> select group_number,name,sector_size,block_size,allocation_unit_size,state,type,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME SECTOR_SIZE BLOCK_SIZE ALLOCATION_UNIT_SIZE STATE TYPE TOTAL_MB FREE_MB
------------ ------------------------------ ----------- ---------- -------------------- ----------- ------ ---------- ----------
2 DATA 512 4096 1048576 MOUNTED NORMAL 29319 29139
1 ARCH 512 4096 1048576 MOUNTED EXTERN 9773 9721
数据库的版本号确实是11.2:
SQL> select group_number, name, compatibility, database_compatibility from v$asm_diskgroup;
GROUP_NUMBER NAME COMPATIBILITY DATABASE_COMPATIBILITY
------------ ------------------------------ ------------------------------ ------------------------------
1 ARCH 11.2.0.0.0 10.1.0.0.0
2 DATA 11.2.0.0.0 10.1.0.0.0
装asm的时候用的是grid用户,3个操作系统组的时候使用都是dba,装oracle时用的是oracle用户,2个操作系统组的时候使用也都是dba:
[grid@dbs disks]$ id grid
uid=501(grid) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),504(asmadmin),505(asmoper),506(asmdba)
[grid@dbs disks]$ id oracle
uid=500(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),506(asmdba)
为什么会报ORA-17502错误?