Oracle错误日志：11gR2 RAC升级后启动报ORA-01565,ORA-17503,ORA-12547

AIX平台下，Oracle 11G RAC，从11.2.0.2升级到11.2.0.3后，数据库启动失败，报错如下：[oracle@p520]$sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.3.0 Production on Fri Apr 6 12:04:52 2012
Copyright （c） 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file "+SYSTEMDG/racdb/spfileracdb.ora"
ORA-17503: ksfdopn:2 Failed to open file +SYSTEMDG/racdb/spfileracdb.ora
ORA-12547: TNS:lost contact经检查，ASM实例启动正常，diskgroup mount正常。最终确定这个问题是因为bin/oracle权限引起，解决方法如下：Oracle binary should have permission of 6751. To correct the permission, as owner of oracle binary:
cd $GRID_HOME/bin
chmod 6751 oracle
cd $ORACLE_HOME/bin
chmod 6751 oracle
After the change, permission should show:
[oracle@p520]/oracle/app/oracle/product/11.2.0/dbs $ls -al $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle asmadmin 300821572 Apr 06 11:00 /oracle/app/oracle/product/11.2.0.3/bin/oracle
Once the permission is fixed, if database still fails to come up, restart Grid Infrastructure.更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12Oracle错误日志：Oracle11g R2 RAC重建oraInventory目录升级Oracle 11.2.0.3后遭遇ORA-00600 [kfioTranslateIO03] [17090]相关资讯 Oracle错误日志

Oracle 11g安装中遇到的问题及解决（11/30/2012 18:49:13）
重启数据库遇到PRCR-1079，CRS- （08/17/2012 09:40:27）
ORA-32004 的错误处理（08/04/2012 15:46:08）

ORA-01652，temp表空间不足的相关（10/15/2012 15:50:12）
ORA-00245 错误解决（08/17/2012 09:37:43）
ORA-04031错误的解决思路（07/30/2012 15:14:18）

本文评论查看全部评论（0）