Skip to Main Content

Chinese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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错误?
This post has been answered by LiuMaclean(刘相兵) on Aug 30 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 27 2012
Added on Aug 30 2012
11 comments
738 views