一、 问题描述:
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 GRIDHOME[oracle@lnx67grid1]GRID_HOME
[oracle@lnx67 grid1]GRIDHOME[oracle@lnx67grid1] 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
-rwsr-s–x 1 grid oinstall 209914471 Jan 6 10:33 oracle