ORA-01565: error in identifying file ‘?/dbs/spfile@.ora’ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3
Cause:
Very simple error when spfile is not found in $ORACLE_HOME/dbs location
SQL> create pfile from spfile;
create pfile 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
Workaround:
Spfile is not in use by instance
SQL> show parameter spfile
NAME TYPE VALUE
———————————— ———– ——————————
spfile string
Create spfile from pfile first and bounce the database instance to use spfile
SQL> create spfile from pfile;
File created.
