ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted]
来源：互联网 发布：软件需求文档ppt 编辑：程序博客网 时间：2024/05/20 14:43
1.
SQL> ALTER DISKGROUP DG1 ADD DISK 'ORCL:VOL4'
Tue Apr 17 16:37:42 2012NOTE: 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
- ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted]
- ASM 实例 ORA-15063 ORA-15186 ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted] 解决方法
- ASM 实例 ORA-15063 ORA-15186 ASMLIB error function = [asm_open], error = [1], mesg = [Operation not pe
- mac intellj IDE下tomcat catalina.sh error=13, Permission denied和error =1 Operation not permitted
- ORA-27125: unable to create shared memory segment Linux-x86_64 Error: 1: Operation not permitted
- insmod: error inserting 'hello.ko': -1 Operation not permitted
- Operation not permitted on IsolatedStorageFileStream error
- iperf error: "bind failed: Operation not permitted"
- Installing CocoaPods "Operation not permitted" error
- linux多线程创建失败，errno=1:Operation not permitted
- ORA-15183: ASMLIB initialization error [driver/agent not installed]
- Linux UDP sendto error: Operation not permitted解决方法
- "npm ERR! Error: EPERM: operation not permitted"问题解决
- react-native ERROR EPERM: operation not permitted报错解决
- npm ERR! Error: EPERM: operation not permitted, scandir 'D:\
- ceph启动时遇到osd.0 authentication error (1) Operation not permitted
- 【greenplum】ERROR: Interconnect error writing an outgoing packet: Operation not permitted
- npm: 2.15.1 should be >= 3.0.0 npm install express operation not permitted
- js 函数一览表
- SIP协议及与Freeswitch的关系
- 解决Ubuntu环境变量错误导致无法正常登录
- USACO section 1.5.1 Number Triangles
- 构建高性能的web站点学习笔记四------浏览器缓存
- ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted]
- 图像二值化
- VB作业题
- md5整理
- html select标签的selectIndex用法
- mysql常用操作
- 第一次编程序的感想
- 一些jdbc连接
- Android提高篇之SQLite分页读取
