ORA-01565: error in identifying file /dbs/spfile@.ora

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/inittestdb.ora’ from spfile;

create pfile=’/u01/inittestdb.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/inittestdb.ora’ from spfile=’+DATA/testdb/spfiletestdb.ora’;

File created.