On the AIX platform, after ORACLE11GRAC is upgraded from 11.2.0.2 to 11.2.0.3, the database fails to start. The error is as follows: [oracle @ p520] $ sqlplusquot; assysdba
On the AIX platform, after ORACLE 11g rac is upgraded from 11.2.0.2 to 11.2.0.3, the database fails to start. The error is as follows: [oracle @ p520] $ sqlplus quot;/as sysdba
On the AIX platform, after Oracle 11g rac is upgraded from 11.2.0.2 to 11.2.0.3, the database fails to start. The error is as follows:
[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,201 1, 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
After checking, the ASM instance starts normally and the diskgroup mount is normal.
Finally, this problem is caused by bin/oracle permissions. The solution is as follows:
Oracle binary shocould 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 shocould 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.
For more information about Oracle, see the Oracle topic page? Tid = 12