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/[email protected]’
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:
praveen
what if i dont know the path of the spfile ?
· 5 years ago
Buğra ÇOMAK
Hi, solution: show parameter spfile;
· 4 years ago
A. Smith
This was helpful. Thanks!
· 4 years ago