Wednesday 2 November 2016

ORA-17503: ksfdopn:2 Failed to open file

issue
++++++
Unable to start the RAC database due to missing permision on oracle binary file.

SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/TEST/PARAMETERFILE/spfile.337.850220233'
ORA-17503: ksfdopn:2 Failed to open file +DATA/TEST/PARAMETERFILE/spfile.337.850220233
ORA-27300: OS system dependent operation:open failed with status: 13
ORA-27301: OS failure message: Permission denied
ORA-27302: failure occurred at: sskgmsmr_7





solution
+++++++++
[root@cstsd12 ~]# cd /u01/oracle/11.2.0/bin
[root@cstsd12 bin]# ls -l oracle
-rwsr-s--x 1 oracle dba 232519360 Jun 14 13:09 oracle
[root@cstsd12 bin]# chgrp asmadmin oracle
[root@cstsd12 bin]# chmod 6751 oracle
[root@cstsd12 bin]# ls -l oracle
-rwsr-s--x 1 oracle asmadmin 232519360 Jun 14 13:09 oracle
[root@cstsd12 bin]#

1 comment: