Saturday, August 25, 2018

ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+ERP_DB/spfileerp.ora_1522172043297' ORA-17503: ksfdopn:10 Failed to open file +ERP_DB/spfileerp.ora_1522172043297 ORA-01034: ORACLE not available ORA-27121: unable to determine size of shared memory segment Linux-x86_64 Error: 13: Permission denied Additional information: 6761 Additional information: 60391427

Issue Type:

SQL> startup mount
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+ERP_DB/spfileerp.ora_1522172043297'
ORA-17503: ksfdopn:10 Failed to open file +ERP_DB/spfileerp.ora_1522172043297
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
Linux-x86_64 Error: 13: Permission denied
Additional information: 6761
Additional information: 60391427


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.


[grid@myserver]$ cd $GRID_HOME/bin
[grid@myserver]$ chmod 6751 oracle

[oracle@myserver]$ cd $ORACLE_HOME/bin
[oracle@myserver]$ chmod 6751 oracle

No comments: