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.

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s