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

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

孙立锋

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

阅读量3.6k

点赞数 2

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/weixin_43288613/article/details/108076415

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一、问题描述：
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
2 ;

NAME STATE

ARCH MOUNTED
DATA MOUNTED
OCR_VOTE MOUNTED

三、问题解决：
1.查看ORACLE程序的权限：
[oracle@lnx67 db_1]$ cd bin
[oracle@lnx67 bin]$ ls -al oracle --ORACLE_HOME下的
-rwsr-s–x 1 oracle oinstall 239626665 Jan 6 10:59 oracle
[oracle@lnx67 bin]$ cd $GRID_HOME [oracle@lnx67 grid1]$ cd bin
[oracle@lnx67 bin]$ ls -al oracle —GRID_HOME下的
-rwxr-x–x 1 grid oinstall 209914471 Jan 6 10:33 oracle
[oracle@lnx67 bin]$ pwd
/u01/11.2.0/grid1/bin
2.修改权限为6751后，恢复正常：
[grid@lnx67 ~]$ cd /u01/11.2.0/grid1/bin
[grid@lnx67 bin]$ ls -al oracle
-rwxr-x–x 1 grid oinstall 209914471 Jan 6 10:33 oracle
[grid@lnx67 bin]$ chmod 6751 oracle
[grid@lnx67 bin]$ ls -al oracle