ORA-17503: ksfdopn:2 Failed to open file +PROD_DATA_01/prod/spfileprod.ora & ORA-12547: TNS:lost contact

Problem:
************

 You attempted to start you database after silent installation and received this error message:

[root@dell ~]# su - oracle
[oracle@dell ~]$ . oraenv
ORACLE_SID = [oracle] ? prod
The Oracle base has been set to /u01/app/oracle
[oracle@dell ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 14 08:50:02 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+PROD_DATA_01/prod/spfileprod.ora'
ORA-17503: ksfdopn:2 Failed to open file +PROD_DATA_01/prod/spfileprod.ora
ORA-12547: TNS:lost contact

 This message indicates you start you database, you need check you oracle utility permissions.

Solution:
***********


To place your database in archivelog mode, perform the following steps:

  1. Check listener status.
  2. Check oracle utility permission for both users grid & oracle.
  3. Change permission of oracle utility for both users grid & oracle.
  4. Startup your database.


Check listener status:
***************************

LSNRCTL> status

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                14-SEP-2016 08:17:33
Uptime                    0 days 0 hr. 32 min. 6 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/grid/11.2.0/grid_home/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/dell/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dell.localdomain)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
The command completed successfully


Check oracle utility permission for both users grid & oracle:
*************************************************************************


[grid@dell bin]$ ls -al oracle
-rwxrwxr-x 1 grid oinstall 209914513 Sep 11 08:23 oracle

[oracle@dell bin]$ ls -al oracle
-rwxrwsr-x 1 oracle asmadmin 239626683 Sep 11 09:28 oracle


Change permission of oracle utility for both users grid & oracle:
******************************************************************************

[root@dell ~]# cd /u01/app/grid/11.2.0/grid_home/bin
[root@dell bin]# chmod 6751 oracle

[root@dell bin]# ls -lrth oracle
-rwsr-s--x 1 grid oinstall 201M Sep 11 08:23 oracle

[root@dell bin]# cd /u01/app/oracle/product/11.2.0/db_1/bin/
[root@dell bin]# chmod 6555 oracle

[root@dell bin]# ls -lrth oracle
-r-sr-sr-x 1 oracle asmadmin 229M Sep 11 09:28 oracle


Startup your database:
****************************

[root@dell ~]# su - oracle
[oracle@dell ~]$ . oraenv
ORACLE_SID = [oracle] ? prod
The Oracle base has been set to /u01/app/oracle
[oracle@dell ~]$
[oracle@dell ~]$
[oracle@dell ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 14 09:51:57 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  839282688 bytes
Fixed Size                  2257880 bytes
Variable Size             545262632 bytes
Database Buffers          289406976 bytes
Redo Buffers                2355200 bytes
Database mounted.
Database opened.
SQL>