Oracle錯(cuò)誤日志：11gR2 RAC升級(jí)后啟動(dòng)報(bào)ORA-01565,ORA-17503,ORA-

AIX平臺(tái)下，Oracle 11G RAC，從11.2.0.2升級(jí)到11.2.0.3后，數(shù)據(jù)庫啟動(dòng)失敗，報(bào)錯(cuò)如下：

[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

經(jīng)檢查，ASM實(shí)例啟動(dòng)正常，diskgroup mount正常。

最終確定這個(gè)問題是因?yàn)閎in/Oracle權(quán)限引起，解決方法如下：

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.

本篇文章來源于 Linux公社網(wǎng)站(www.linuxidc.com)  原文鏈接：http://www.linuxidc.com/Linux/2012-07/66644.htm

服務(wù)器租用/服務(wù)器托管中國五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]