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 )

 

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *