ORA-15001: diskgroup “DATA“ does not exist or is not mounted

Oracle数据库启动错误与ASM权限修复

最新推荐文章于 2022-06-04 16:36:07 发布

原创

最新推荐文章于 2022-06-04 16:36:07 发布 · 3.7k 阅读

3 ·

CC 4.0 BY-SA版权

本文描述了Oracle数据库启动时遇到的错误，包括控制文件识别错误和ASM实例连接失败的问题，通过调整oracle和grid用户的权限，成功解决了启动失败的情况。

一、问题描述：
rac1节点主机资源内存使用率较高，机器很卡，于是关闭集群，重启主机释放资源。主机启动后，数据库启动报错：
SQL> startup force（自动虚拟机呀）
ORACLE instance started.

Total System Global Area 835104768 bytes
Fixed Size 2232960 bytes
Variable Size 553651584 bytes
Database Buffers 276824064 bytes
Redo Buffers 2396160 bytes
ORA-00205: error in identifying control file, check alert log for more info

alert 日志报错：
ASMB started with pid=30, OS id=9284
ORA-00210: cannot open the specified control file
ORA-00202: control file: ‘+DATA/orcl/controlfile/current.260.1013980813’
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/controlfile/current.260.1013980813
ORA-15001: diskgroup “DATA” does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied

二、检查磁盘组
SQL> select name,state from v$asm_diskgroup