How to fix ORA-01565: error in identifying file ‘?/dbs/spfile@.ora’

How to fix Oracle

While working on an Oracle ASM instance, we may encounter a spfile creation error like the one below.

SQL> create pfile=’/u01/ora/inittkitest3.ora’ from spfile;
create pfile=’/u01/ora/inittkitest3.ora’ from spfile
*
ERROR at line 1:
ORA-01565: error in identifying file ‘?/dbs/spfile@.ora’
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

You can follow a path like the one below for the solution.

SQL> create pfile=’/u01/app/ora/product/ora_dev_12102_n/dbs/inittest2.ora’ from spfile=’+DATA/ora/spfileinit.ora’;

File created.

Tags:

Comments