ORA-15055 ASM Diskgroup Status Showing Dismounted From RDBMS Instance

在数据库实例中检查asm 磁盘组的状态时,显示 DISMOUNTED,但是在asm 实例上却显示MOUNTED
在数据库实例的alert 日志中会出现如下信息:

SUCCESS: diskgroup ASMDISK02 was mounted
SUCCESS: diskgroup ASMDISK02 was dismounted
SUCCESS: diskgroup ASMDISK02 was mounted
SUCCESS: diskgroup ASMDISK02 was dismounted
SUCCESS: diskgroup ASMDISK02 was mounted

ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '+ASMDISK01/cnf2/redo01.log'
ORA-17503: ksfdopn:2 Failed to open file +ASMDISK01/cnf2/redo01.log
ORA-15055: unable to connect to ASM instance
ORA-00020: maximum number of processes () exceeded
ORA-15055: unable to connect to ASM instance
ORA-00020: maximum number of processes () exceeded
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '+ASMDISK01/cnf2/redo01.log'
ORA-17503: ksfdopn:2 Failed to open file +ASMDISK01/cnf2/redo01.log
ORA-12549: TNS:operating system resource quota exceeded

原因:
这个问题是由于数据库实例不能和asm 实例进行通讯,不管何时尝试连接asm,它都用尽os 资源。在系统级别上不能创建新的进程。
在 数据库实例上检查磁盘组的状态:
SQL > select name,state from v$asm_diskgroup;

NAME                                  STATE
------------------------------    -----------
ASMDISK01                       CONNECTED
ASMDISK02                       DISMOUNTED

CONNECTED 意味着数据库实例正在使用这个磁盘组
DISMOUNTED 意味着数据库实例将磁盘组视为不可用。

解决办法:
在这种情况下由于asm 进程数已经达到上限,新的asm进程不能创建导致数据库实例不能够连接到asm上。默认的ASM进程数为40,可以将 进程相关的参数设置为更高一些 比如150

时间: 2024-08-01 18:03:17

ORA-15055 ASM Diskgroup Status Showing Dismounted From RDBMS Instance的相关文章

ASM diskgroup dismount with "Waited 15 secs for write IO to PST" (文档 ID 1581684.1)

ASM diskgroup dismount with "Waited 15 secs for write IO to PST" (文档 ID 1581684.1) 转到底部 In this Document Symptoms   Cause   Solution   References APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.1 [Release 11.2 to 12

oracle中rename asm diskgroup的例子

在11.2之后,已经可以rename asm diskgroup了,而不必再新建diskgroup之后,再做image copy. 在11.2.中的gi home中,自带了一个命令renamedg,看下面的例子: renamedg phase=<both|one|two> dgname=<old_diskgroup_name>  newdgname=<new_diskgroup_name> [asm_diskstring='<path_name>' ] [v

ASM Diskgroup Creation Failed with &quot;IBM AIX RISC system/6000: 6:no such device or address&quot; [ID 12634

In this Document  Symptoms   Cause   Solution   References Applies to:   Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later   [Release: 10.2 and later ] IBM AIX on POWER Systems (64-bit) Symptoms When attempting to create an ASM(Automat

oracle中分区无法识别导致asm diskgroup无法mount问题解决办法

有客户咨询由于主机重启之后,导致四个磁盘组中的data2磁盘组无法mount(报ORA-15032,ORA-15017,ORA-15063),数据库无法open,让我们帮忙分析解决 Wed Mar 09 18:10:53 2016 NOTE: Assigning number (1,1) to disk (/dev/oracleasm/disks/VOL011) Wed Mar 09 18:10:53 2016 ERROR: no read quorum in group: required 1

oracle数据库11.2.0.4 RAC CRS diskgroup auto dismount问题

这几天出差到甘肃,某客户的集群有点小问题.其中节点的crs检测发现有点异常,不过怪异的是业务却没有受到任何影响.如下是我检测的结果: [grid@tysy1 bin]$ ocrcheck PROT-602: Failed to retrieve data from the cluster registry PROC-26: Error while accessing the physical storage   [grid@tysy1 bin]$ crsctl query css votedis

oracle 11.2.0.4 RAC CRS diskgroup auto dismount问题

这几天出差到甘肃,某客户的集群有点小问题.其中节点的crs检测发现有点异常,不过怪异的是业务却没有受到任何影响.如下是我检测的结果: [grid@tysy1 bin]$ ocrcheck PROT-602: Failed to retrieve data from the cluster registry PROC-26: Error while accessing the physical storage   [grid@tysy1 bin]$ crsctl query css votedis

oracle数据库oracleasm createdisk重新创建asm disk后数据0丢失恢复案例

有客户反馈他们重启系统之后,发现asmlib创建的asmdisk丢失了,然后又使用oracleasm deletedisk和createdisk重新创建的asm disk,最后发现asm diskgroup无法mount.让客户通过dd 备份5m数据,然后使用kfed分析 kefd分析结果 E:\OneDrive\ORACLE\recover\no_backup\asm\kfedwin>kfed read H:\temp\asmlib\xx.img kfbh.endian:           

oracle数据库1.4TB ASM(RAC) 磁盘损坏恢复案例

这周折腾了2天的时间帮客户成功恢复了一套近1.4TB的10.2.0.5 RAC(ASM). 该库在3月4号直接crash了. 大家可以看到,该库在开始报错读取redo,controlfile报错,本质原因是DISKGROUP dismount了,信息如下: Tue Mar 04 18:09:59 CST 2014 Errors in file /home/oraprod/10.2.0/db/admin/xxxx/bdump/xxxx_lgwr_15943.trc: ORA-00345: redo

oracle中存储精简卷导致asm磁盘组异常

有朋友在一个存储空间给asm使用,发生空间不足,然后使用另外一个存储中的lun给asm的data磁盘组增加asm disk,运行了大概1天之后,asm磁盘组直接dismount,数据库crash.然后就无法正常mount.包括这个存储上的几个其他磁盘组也无法正常mount. 数据库异常日志 Sun Oct 23 08:43:59 2016 SUCCESS: diskgroup DATA was dismounted SUCCESS: diskgroup DATA was dismounted S