ORA-01565: error in identifying file /dbs/spfile@.ora
When we’re going to create pfile from spfile while spfile running on ASM instance, We can face the below errors,
SQL> create pfile=’/u01/inittest.ora’ from spfile;
create pfile=’/u01/inittest.ora’ from spfile
*
ERROR at line 1:
ORA-01565: error in identifying file ‘?/dbs/spfile@.ora’
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Solution :
We need to give ASM path of SPFILE.
SQL> create pfile=’/u01/inittest.ora’ from spfile=’+DATA/dbasm/spfiledbasm.ora’;
File created.
4 Comments
Post a comment
DBA 
Hi Azar,
i am getting the below error message while creating pfile –
SQL> create pfile=’/u01/app/oracle/initram1.ora’ from spfile=’+DATA/ram/spfileram.ora’;
create pfile=’/u01/app/oracle/initram1.ora’ from spfile=’+DATA/ram/spfileram.ora’
*
ERROR at line 1:
ORA-01565: error in identifying file ‘+DATA/ram/spfileram.ora’
ORA-17503: ksfdopn:2 Failed to open file +DATA/ram/spfileram.ora
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Operation not permitted
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 1000 (oinstall), current egid
= 1200 (dba)
Is anything wrong in the permission. Your advise is must appreciated.
Thanks
Rk
i am getting error when creating pfile
SQL> create pfile=’/u01/inittest.ora’ from spfile=’+DATA/dbasm/spfiledbasm.ora’;
create pfile=’/u01/inittest.ora’ from spfile=’+DATA/dbasm/spfiledbasm.ora’
*
ERROR at line 1:
ORA-17503: ksfdopn:2 Failed to open file +DATA/dbasm/spfiledbasm.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager