DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, June 16, 2015

ORA-01565: Unable to open Spfile

ORA-01565: Unable to open Spfile
Scenario:

Someone from the team opened the spfile using server command ie vi, vim etc ., and updated the entry and that corrupted the spfile. After that got the below error continuously in the alert log and huge trace file got generated.

Error:

ORA-01565: Unable to open Spfile /u01/oracle/app/oracle/product/11.3/dbs/spfilePROD.ora.

Tue Jun 09 15:16:56 2015

ORA-01565: Unable to open Spfile /u01/oracle/app/oracle/product/11.3/dbs/spfilePROD.ora.

Tue Jun 09 15:17:57 2015

ORA-01565: Unable to open Spfile /u01/oracle/app/oracle/product/11.3/dbs/spfilePROD.ora.

Tue Jun 09 15:18:58 2015

ORA-01565: Unable to open Spfile /u01/oracle/app/oracle/product/11.3/dbs/spfilePROD.ora.

Tue Jun 09 15:45:02 2015

Solution:

1.

If you have a pfile create a spfile from pfile and rename spfile with newly created a spfile.

1.create spfile=’/tmp/spfilePROD.ora’ from pfile;

2.cd $ORACLE_HOME/dbs

3.mv spfilePROD.ora spfilePROD.ora_orig - It can be done when the DB is running, so no need downtime at all.

4.cp –rp /tmp/spfilePROD.ora spfilePROD.ora

and see error will be disappeared from the alert log.

2.
If you have a spfile backup, restore from the backup. That’s it problem solved.

3.
If spfile backup and pfile are not available, Reconstruct the pfile from the alert log entries and repeat the step No: 1