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

praveen
what if i dont know the path of the spfile ?
Reply · 5 months ago

Buğra ÇOMAK
Hi, solution: show parameter spfile;
Reply · 3 months ago

A. Smith
This was helpful. Thanks!
Reply · 4 months ago