Mir Sayeed Hassan – Oracle Blog

Oracle RAC Database fails to start with error ORA-12547/ORA-17503/CRS-5017/CRS-2674

 The below error occur while startup of the RAC Database 

[oracle(rac_1)@trac1:/u01/app/oracle]$ srvctl start instance -d rac -i rac_1
PRCR-1013 : Failed to start resource ora.rac.db
PRCR-1064 : Failed to start resource ora.rac.db on node trac1
CRS-5017: The resource action "ora.rac.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-01565: error in identifying file '+DATA/rac/spfilerac.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/rac/spfilerac.ora
ORA-12547: TNS:lost contact
. For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0/grid_1/log/trac1/agent/crsd/oraagent_oracle//oraagent_oracle.log".
CRS-2674: Start of 'ora.rac.db' on 'trac1' failed

 [oracle(rac_2)@trac1:/u01/app]$ sqlplus sys/test@rac_1 as sysdba
 SQL*Plus: Release 11.2.0.4.0 Production on Mon May 13 09:05:44 2019
 Copyright (c) 1982, 2013, Oracle.  All rights reserved.
 ERROR:
 ORA-12537: TNS:connection closed

Issue

The above main issue is caused by incorrect permission of $GRID_HOME/bin/oracle and

$ORACLE_HOME/bin/oracle, which lead to connection failure to ASM instance as shown below:

[oracle(rac_1)@trac1:~]$ ls -al $ORACLE_HOME/bin/oracle
-rwxr-x--x . 1 oracle asmadmin 239626689 Oct  1  2018 /u01/app/oracle/product/11.2.0/db_1/bin/oracle

[grid(+ASM1)@trac1:~]$ ls -al $GRID_HOME/bin/oracle
-rwxr-x--x .  1 grid oinstall 209914519 Sep 25  2018 /u01/app/11.2.0/grid_1/bin/oracle

Fallow the below require permission to assign as per requirement

In Oracle user:

[oracle(rac_1)@trac1:~]$ cd $ORACLE_HOME/bin
[oracle(rac_1)@trac1:~]$ chmod 6751 oracle
[oracle(rac_1)@trac1:/u01/app/oracle/product/11.2.0/db_1/network/admin]$ ls -lhrt $ORACLE_HOME/bin/oracle

Verify
-rwsr-s--x. 1 oracle asmadmin 229M Oct  1  2018 /u01/app/oracle/product/11.2.0/db_1/bin/oracle

 Grid user:
 [oracle(rac_1)@trac1:~]$ exit
 [root@trac1 ~]# su - grid

[grid(+ASM1)@trac1:/]$cd $GRID_HOME/bin
 [grid(+ASM1)@trac1:/u01/app/11.2.0/grid_1/bin]$ chmod 6751 oracle

After changing the permission, try to start up the database & verify

[oracle(rac_1)@trac1:~]$ srvctl start database -d rac

[oracle(rac_1)@trac1:~]$ !sq
sqlplus / as sysdba
SQL> select status from V$instance;

STATUS
------
OPEN

[oracle(rac_1)@trac1:~]$ sqlplus sys/test@rac_1 as sysdba

SQL> select instance_name,version from v$instance;

INSTANCE_NAME    VERSION
---------------- -----------------
rac_1            11.2.0.4.0

=========Hence tested & verified in our test env========