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


Usually I want to create pfile from spfile just run this command,

SQL> create pfile='/u01/app/oracle/backups/pools/pfiledb20120226.ora' from spfile;

File created.

But in ASM environment, the above command raises an error,

SQL> create pfile='/u01/app/oracle/backups/pools/pfileasm20120226.ora' from spfile;
create pfile='/u01/app/oracle/backups/pools/pfileasm20120226.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


SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string

Solution I found after googling,

SQL> create pfile='/u01/app/oracle/backups/pools/pfileasm20120226.ora' from memory;

File created.

Leave a comment