I got “ ORA-17503: ksfdopn Failed to open file | ORA-01565 ORA-17503 ORA-01034 ORA-27121 ” error in Oracle database during startup.
ORA-17503: ksfdopn Failed to open file | ORA-01565 ORA-17503 ORA-01034 ORA-27121
Details of error are as follows.
SQL> startup mount ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATA/MSDBDR/parameterfile/spfile.ora' ORA-17503: ksfdopn:10 Failed to open file +DATA/MSDBDR/parameterfile/spfile.ora ORA-01034: ORACLE not available ORA-27121: unable to determine size of shared memory segment Linux-x86_64 Error: 13: Permission denied Additional information: 8210 Additional information: 2457603 SQL>
ORA-17503: ksfdopn Failed to open file
The ORA-01565 ORA-17503 ORA-01034 ORA-27121 error is related with the Oracle utility permission for both users grid or oracle users in my Case.
To solve this error, I have run the following commands. I have changed executable oracle binary ownership to grid:oinstall and permission to 6751 as follows.
If the problem was related with Oracle database, then you need to do same action for Oracle home instead of Grid Home.
[grid@msdbadm03 grid]$ cd $GRID_HOME/bin/ [grid@msdbadm03 bin]$ [grid@msdbadm03 bin]$ ls -ltr oracle -rwxr-x--x 1 grid asmadmin 420392488 Sep 9 17:37 oracle [grid@msdbadm03 bin]$ [grid@msdbadm03 bin]$ [grid@msdbadm03 bin]$ chown grid:oinstall oracle [grid@msdbadm03 bin]$ [grid@msdbadm03 bin]$ [grid@msdbadm03 bin]$ ls -ltr oracle -rwxr-x--x 1 grid oinstall 420392488 Sep 9 17:37 oracle [grid@msdbadm03 bin]$ [grid@msdbadm03 bin]$ [grid@msdbadm03 bin]$ chmod 6751 oracle [grid@msdbadm03 bin]$
If you are still getting same error, then go to Oracle database’s Oracle Home and do same action for Oracle database software as follows.
[oracle@msdbadm03 oracle]$ cd $ORACLE_HOME/bin/ [oracle@msdbadm03 bin]$ [oracle@msdbadm03 bin]$ ls -ltr oracle -rwxr-x--x 1 oracle oinstall 420392488 Sep 9 17:37 oracle [oracle@msdbadm03 bin]$ [oracle@msdbadm03 bin]$ [oracle@msdbadm03 bin]$ ls -ltr oracle -rwxr-x--x 1 oracle oinstall 420392488 Sep 9 17:37 oracle [oracle@msdbadm03 bin]$ [oracle@msdbadm03 bin]$ [oracle@msdbadm03 bin]$ chmod 6751 oracle [oracle@msdbadm03 bin]$
Now you can startup database successfully.
Do you want to learn Oracle Database for Beginners, then Click and read the following articles.
Oracle Database Tutorials for Beginners ( Junior Oracle DBA )