Site icon IT Tutorial

ORA-17503: ksfdopn Failed to open file | ORA-01565 ORA-17503 ORA-01034 ORA-27121

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 )

 

Exit mobile version