Saturday 4 January 2014

ORA-01565: error in identifying file / ORA-27037: unable to obtain file status.

When trying to create pfile from spfile getting below error.

SQL> create pfile='/d01/oracle/initsetting.ora' from spfile;
create pfile='/d01/oracle/initsetting.ora' from spfile

ERROR at line 1:
ORA-01565: error in identifying file '?/dbs/spfile@.ora'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

Cause: Database is not running with spfile,It is running with memory.
issue seen  while doing rman duplicate clone.

Solution:-

SQL> create pfile='/d01/oracle/initsetting.ora' from memory;

File created.

SQL>

Posted by at

2 comments:

  1. Director de EmpresaThursday 20 March 2014 at 21:56:00 GMT+5:30

    SQL> create pfile='/home/orpprd/initnew.ora' from memory;
    create pfile='/home/orpprd/initnew.ora' from memory
    *
    ERROR at line 1:
    ORA-00922: missing or invalid option

    ReplyDelete
  2. S.H.E.M.E.E.M Sunday 30 March 2014 at 09:41:00 GMT+5:30

    same error for me too..

    ReplyDelete

Subscribe to: Post Comments (Atom)