Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01565: Unable to open Spfile found in alert log after reboot.

888 867-5309Mar 31 2017 — edited Apr 1 2017

I have a 2 node Rac 11.2.0.4 - and after rebooting the server all of the databases are showing this same error in the alert log.

ORA-01565: Unable to open Spfile

I have check $ORACLE_HOME/dbs, gv$parameter, srvctl config database and the alert logs (2 nodes).

From the alert log:

Using parameter settings in server-side pfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initnjwprd1.ora

System parameters with non-default values:

.............

alert log:spfile= "+DATA/njwprd/spfilenjwprd.ora"

..........

.../dbs directory has spfilenjwprd1.ora and spfilenjwprd2.ora -- both with single line: SPFILE='+DATA/njwprd/spfilenjwprd.ora'

srvctl shows +DATA/njwprd/spfilenjwprd.ora

gv$parameters spfile shows

+DATA/njwprd/spfilenjwprd.ora

I have no idea where the error is coming from when all these references are in agreement.

Is the problem in ASM?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 28 2017

Added on Mar 31 2017

#performance-availability, #real-application-clusters

3 comments

6,477 views