昨晚对一套RAC系统顺利进行了PSU补丁包的安装后，在启动数据库时报错如下：
Mon Oct 19 17:52:31 2015
ALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=10.0.61.96)(PORT=1526))' SCOPE=MEMORY SID='hbdbuat1';
This instance was first to mount
NOTE: Loaded library: System
ORA-15025: could not open disk "/dev/asm-diskd"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
ORA-15025: could not open disk "/dev/asm-diske"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
SUCCESS: diskgroup DATA01 was dismounted
ERROR: diskgroup DATA01 was not mounted
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DATA01/hbdbuat/controlfile/current.256.857995095'
ORA-17503: ksfdopn:2 Failed to open file +DATA01/hbdbuat/controlfile/current.256.857995095
ORA-15001: diskgroup "DATA01" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-205 signalled during: ALTER DATABASE MOUNT...
Mon Oct 19 17:52:48 2015
Shutting down instance (immediate)
Mon Oct 19 17:52:31 2015
ALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=10.0.61.96)(PORT=1526))' SCOPE=MEMORY SID='hbdbuat1';
This instance was first to mount
NOTE: Loaded library: System
ORA-15025: could not open disk "/dev/asm-diskd"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
ORA-15025: could not open disk "/dev/asm-diske"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
SUCCESS: diskgroup DATA01 was dismounted
ERROR: diskgroup DATA01 was not mounted
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DATA01/hbdbuat/controlfile/current.256.857995095'
ORA-17503: ksfdopn:2 Failed to open file +DATA01/hbdbuat/controlfile/current.256.857995095
ORA-15001: diskgroup "DATA01" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-205 signalled during: ALTER DATABASE MOUNT...
Mon Oct 19 17:52:48 2015
Shutting down instance (immediate)
检查另外一个节点，并启动DB，同样的报错。
查了下相关资料，应该是有个oracle的文件权限问题：$ORACLE_HOME/bin/oracle这个文件的权限问题。
d4jtfmcvurd01-> ls -lrt orac*
-rwxr-xr-x 1 oracle oinstall 46 Nov 7 2000 oracg
-rwsr-s--x 1 oracle oinstall 239815197 Oct 19 16:31 oracleO
-rwsr-s--x 1 oracle oinstall 239815197 Oct 19 16:31 oracle
通过比对其他系统发现，该文件正确的权限应该是oracle：asmadmin才对，针对此问题，如下修改权限即可（在oracle账号下执行）：
$GI_HOME/bin/setasmgidwrap o=$ORACLE_HOME/bin/oracle
RV.png)
-rwxr-xr-x 1 oracle oinstall 46 Nov 7 2000 oracg
-rwsr-s--x 1 oracle oinstall 239815197 Oct 19 16:31 oracleO
-rwsr-s--x 1 oracle asmadmin 239815197 Oct 19 16:31 oracle
此时在启动DB 的时候，该报错不在出现了
查了下相关资料，应该是有个oracle的文件权限问题：$ORACLE_HOME/bin/oracle这个文件的权限问题。
d4jtfmcvurd01-> ls -lrt orac*
-rwxr-xr-x 1 oracle oinstall 46 Nov 7 2000 oracg
-rwsr-s--x 1 oracle oinstall 239815197 Oct 19 16:31 oracleO
-rwsr-s--x 1 oracle oinstall 239815197 Oct 19 16:31 oracle
通过比对其他系统发现，该文件正确的权限应该是oracle：asmadmin才对，针对此问题，如下修改权限即可（在oracle账号下执行）：
$GI_HOME/bin/setasmgidwrap o=$ORACLE_HOME/bin/oracle
-rwxr-xr-x 1 oracle oinstall 46 Nov 7 2000 oracg-rwsr-s--x 1 oracle oinstall 239815197 Oct 19 16:31 oracleO
-rwsr-s--x 1 oracle asmadmin 239815197 Oct 19 16:31 oracle
此时在启动DB 的时候，该报错不在出现了
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28612416/viewspace-1815104/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- Oracle RMAN 备份控制文件报错问题
- Oracle 12C RAC报错ORA-20001: Statistics Advisor
- Oracle 12.2 RAC 报错ora-600 ora-07445
- Redhat7 上安装RAC的问题
- RMAN命令configure，report，list，crosscheck，delete的使用方法
- Oracle Grid/RAC 11.2.0.4 on Oracle Linux 7 (Doc ID 1951613.1)
- linux7上安装RAC的问题
- RAC----> 单机DG问题
- Oracle12.1闪回功能
- Oracle 12.2对客户端工具的支持说明
