ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted]

1.

SQL> ALTER DISKGROUP DG1 ADD DISK 'ORCL:VOL4'

Tue Apr 17 16:37:42 2012
NOTE: ASMB process exiting due to lack of ASM file activity
Tue Apr 17 16:37:42 2012
NOTE: reconfiguration of group 1/0x2a7874c4 (DG1), full=1
Tue Apr 17 16:37:42 2012
ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted]
Tue Apr 17 16:37:42 2012
ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted]
Tue Apr 17 16:37:42 2012
ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted]
Tue Apr 17 16:37:42 2012
ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted]
Tue Apr 17 16:37:42 2012
NOTE: PST update: grp = 1
NOTE: requesting all-instance disk validation for group=1
Tue Apr 17 16:37:42 2012
NOTE: disk validation pending for group 1/0x2a7874c4 (DG1)
SUCCESS: validated disks for 1/0x2a7874c4 (DG1)
Tue Apr 17 16:37:43 2012
NOTE: PST update: grp = 1
NOTE: requesting all-instance PST refresh for group=1
Tue Apr 17 16:37:43 2012
NOTE: PST refresh pending for group 1/0x2a7874c4 (DG1)
SUCCESS: refreshed PST for 1/0x2a7874c4 (DG1)
Tue Apr 17 16:37:46 2012
NOTE: requesting all-instance PST refresh for group=1
Tue Apr 17 16:37:46 2012
NOTE: PST refresh pending for group 1/0x2a7874c4 (DG1)
SUCCESS: refreshed PST for 1/0x2a7874c4 (DG1)
Tue Apr 17 16:37:52 2012
NOTE: starting rebalance of group 1/0x2a7874c4 (DG1) at power 1
Starting background process ARB0
ARB0 started with pid=17, OS id=14216
Tue Apr 17 16:37:52 2012
NOTE: assigning ARB0 to group 1/0x2a7874c4 (DG1)
Tue Apr 17 16:38:09 2012
NOTE: stopping process ARB0
Tue Apr 17 16:38:09 2012
ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted]
Tue Apr 17 16:38:09 2012
ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted]
Tue Apr 17 16:38:09 2012
ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted]
Tue Apr 17 16:38:09 2012
ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted]
Tue Apr 17 16:38:12 2012
SUCCESS: rebalance completed for group 1/0x2a7874c4 (DG1)
Tue Apr 17 16:38:12 2012
SUCCESS: rebalance completed for group 1/0x2a7874c4 (DG1)
NOTE: PST update: grp = 1
NOTE: PST update: grp = 1

rac1->

2.--虽然没有提示错误，但后台却报了上边的错误

SQL> ALTER DISKGROUP DG1 ADD DISK 'ORCL:VOL4';

Diskgroup altered.

3.重新select, 可以看到新增加的磁盘RAW4的FREE_MB为0，大致肯定没有添加成功

SQL> select substr(name,1,10) name,substr(path,1,20) path, REDUNDANCY, TOTAL_MB, free_mb from V$ASM_DISK;

NAME PATH REDUNDA TOTAL_MB FREE_MB
---------- -------------------- ------- ---------- ----------
/dev/raw/raw4 UNKNOWN 3067 0
ORCL:VOL1 UNKNOWN 3067 0
ORCL:VOL2 UNKNOWN 3067 0
ORCL:VOL3 UNKNOWN 2047 0
ORCL:VOL4 UNKNOWN 3067 0
DG1_0000 /dev/raw/raw1 UNKNOWN 3067 29
DG1_0001 /dev/raw/raw2 UNKNOWN 3067 29
RECOVERYDE /dev/raw/raw3 UNKNOWN 2047 983

4.

SQL> select substr(name,1,10) name,substr(path,1,20) path, REDUNDANCY, TOTAL_MB, free_mb from V$ASM_DISK;

NAME PATH REDUNDA TOTAL_MB FREE_MB
---------- -------------------- ------- ---------- ----------
/dev/raw/raw4 UNKNOWN 3067 0
ORCL:VOL1 UNKNOWN 3067 0
ORCL:VOL2 UNKNOWN 3067 0
ORCL:VOL3 UNKNOWN 2047 0
ORCL:VOL4 UNKNOWN 3067 0
DG1_0000 /dev/raw/raw1 UNKNOWN 3067 29
DG1_0001 /dev/raw/raw2 UNKNOWN 3067 29
RECOVERYDE /dev/raw/raw3 UNKNOWN 2047 983

SQL> select name,total_mb,free_mb from v$asm_diskgroup;

NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
DG1 6134 58
RECOVERYDEST 2047 983

SQL> alter diskgroup DG1 add disk '/dev/raw/raw4'name DG1_0003
2 /
Diskgroup altered.

重新启动数据库,可以观察到数据库的启动在MOUNTED到OPENED时很慢，那是因为ASM在做REBLANCE（重新分布数据）

下面是变化过程

SQL> select substr(name,1,10) name,substr(path,1,20) path, REDUNDANCY, TOTAL_MB, free_mb from V$ASM_DISK;

NAME PATH REDUNDA TOTAL_MB FREE_MB
---------- -------------------- ------- ---------- ----------
ORCL:VOL1 UNKNOWN 3067 0
ORCL:VOL2 UNKNOWN 3067 0
ORCL:VOL3 UNKNOWN 2047 0
ORCL:VOL4 UNKNOWN 3067 0
DG1_0000 /dev/raw/raw1 UNKNOWN 3067 29
DG1_0001 /dev/raw/raw2 UNKNOWN 3067 29
RECOVERYDE /dev/raw/raw3 UNKNOWN 2047 983
DG1_0003 /dev/raw/raw4 UNKNOWN 3067 3062

SQL> l
1* select substr(name,1,10) name,substr(path,1,20) path, REDUNDANCY, TOTAL_MB, free_mb from V$ASM_DISK
SQL> /

NAME PATH REDUNDA TOTAL_MB FREE_MB
---------- -------------------- ------- ---------- ----------
ORCL:VOL1 UNKNOWN 3067 0
ORCL:VOL2 UNKNOWN 3067 0
ORCL:VOL3 UNKNOWN 2047 0
ORCL:VOL4 UNKNOWN 3067 0
DG1_0000 /dev/raw/raw1 UNKNOWN 3067 249
DG1_0001 /dev/raw/raw2 UNKNOWN 3067 250
RECOVERYDE /dev/raw/raw3 UNKNOWN 2047 983
DG1_0003 /dev/raw/raw4 UNKNOWN 3067 2323

8 rows selected.

SQL> /

NAME PATH REDUNDA TOTAL_MB FREE_MB
---------- -------------------- ------- ---------- ----------
ORCL:VOL1 UNKNOWN 3067 0
ORCL:VOL2 UNKNOWN 3067 0
ORCL:VOL3 UNKNOWN 2047 0
ORCL:VOL4 UNKNOWN 3067 0
DG1_0000 /dev/raw/raw1 UNKNOWN 3067 193
DG1_0001 /dev/raw/raw2 UNKNOWN 3067 197
RECOVERYDE /dev/raw/raw3 UNKNOWN 2047 983
DG1_0003 /dev/raw/raw4 UNKNOWN 3067 2209

8 rows selected.

5.数据正常启

SQL> startup
ORACLE instance started.

Total System Global Area 473956352 bytes
Fixed Size 1220096 bytes
Variable Size 218104320 bytes
Database Buffers 251658240 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.

9.注：当ASM磁盘组空间率不足时会报

ORA 03113 end of file on communication channel

ORA-15041: diskgroup space exhausted