ORA-17503: ksfdopn:2 Failed to open file +DATA/dbname/spfiledb.ora

Issue:

PRCR-1013 : Failed to start resource ora.DBname.db
PRCR-1064 : Failed to start resource ora.DBname.db on node servername
CRS-5017: The resource action "ora.DBname.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/DBname/spfileDBname.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/DBname/spfileDBname.ora
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Operation not permitted
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 501 (oinstall), current egid = 502 (dba)
. For details refer to "(:CLSN00107:)" in "/rdbms/app/oracle/diag/crs/servername/crs/trace/crsd_oraagent_ora12c.trc".

CRS-2674: Start of 'ora.DBname.db' on 'servername' failed

Solution :

Login to server by oracle user

Set DB profile (.bash_profile) and check the permission of oracle 

Ora12c:

RAC Server 1  :  -rwsr-s--x. 1 oracle oinstall 234M dec 12 02:32 oracle

RAC Server 2  :  -rwsr-s--x. 1 oracle oinstall 234M dec 12 03:45 oracle

Set DB profile (.bash_profile) and check the permission of oracle 

Grid :

Set ASM profile (.bash_profile_asm ) and check the permission of oracle 

RAC Server 1   : -rwxrwxr-x. 1 grid oinstall 239734521 dec 12 02:32 /rdbms/app/12.1.0/grid/bin/oracle

RAC Server 2   : -rwsr-s--x. 1 grid oinstall 239734521 12 03:45 /rdbms/app/12.1.0/grid/bin/oracle

Login using root user and change permission to 6751 (node which causing issue i.e node 1 in my case)

chmod 6751 /rdbms/app/12.1.0/grid/bin/oracle

-rwsr-s--x. 1 grid oinstall 239734521 12 03:45 /rdbms/app/12.1.0/grid/bin/oracle

then start DB using 

[ora12c@server1 bin]$ srvctl start instance -i instancename -d DBname

For reference:

PFB.

Server  RAC 1

Oracle

[ora12c@server1 ~]$ echo $ORACLE_HOME

/rdbms/app/12.1.0/dbhome

[ora12c@server1 ~]$ cd /rdbms/app/12.1.0/dbhome

[ora12c@server1 dbhome]$ cd bin

[ora12c@server1 bin]$ ls -ltr oracle*

-rwsr-s--x. 1 oracle oinstall 234M dec 12 02:32 oracle

Grid

[ora12c@server1 ~]$ . ./.bash_profile_asm

[ora12c@server1 ~]$ cd $ORACLE_HOME/bin

[ora12c@server1 bin]$ ls -ltr oracle*

-rwxrwxr-x. 1 grid oinstall 239734521 dec 12 02:32 oracle

[ora12c@server1 bin]$

Server  RAC 2

Oracle

[ora12c@server2 ~]$ echo $ORACLE_HOME

/rdbms/app/12.1.0/dbhome

[ora12c@server2 ~]$ cd /rdbms/app/12.1.0/dbhome

[ora12c@server2 dbhome]$ cd bin

[ora12c@server2 bin]$ ls -ltr oracle*

-rwsr-s--x. 1 oracle oinstall 234M dec 12 02:32 oracle

Grid

[ora12c@server2 ~]$ . ./.bash_profile_asm

[ora12c@server2~]$ cd $ORACLE_HOME/bin

[ora12c@server2 bin]$ ls -ltr oracle*

-rwsr-s--x. 1 grid oinstall 239734521 12 03:45 oracle

[ora12c@server1 bin]$

Login by root

[ora12c@server1 bin]$ sudo su -

Last login: Wed Aug  2 11:42:51 IST 2017 on tty1

[root@server1 ~]# chmod 6751 /rdbms/app/12.1.0.2/grid/bin/oracle

[root@server1 ~]# ls -ltr /rdbms/app/12.1.0.2/grid/bin/oracle

-rwsr-s--x. 1 ora12c oinstall 291255117 Jun 30 21:55 /rdbms/app/12.1.0.2/grid/bin/oracle

[root@server1 ~]# logout

[ora12c@server1 bin]$ srvctl start instance -i DBname1 -d DBname

[ora12c@server1 bin]$ ps -ef | grep pmon

ora12c   19636     1  0 11:29 ?        00:00:00 ora_pmon_DBname1

ora12c   19911 18507  0 11:29 pts/0    00:00:00 grep --color=auto pmon

ora12c   47857     1  0 Aug02 ?        00:00:04 asm_pmon_+ASM1

[ora12c@server1 bin]$

thats it :)