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.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: