Oracle11.2.0.4 PUS安装后问题解决

昨晚对一套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)
检查另外一个节点,并启动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博客 ” ,链接:http://blog.itpub.net/28612416/viewspace-1815104/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/28612416/viewspace-1815104/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值