Oracle11.2.0.4 PUS安装后问题解决

PUS安装后问题解决"/>

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博客 ” ，链接：/，如需转载，请注明出处，否则将追究法律责任。

转载于:/