My Oracle Support Banner

RAC: SRVCTL Cannot Start Database or Instances - ORA-01565 Encountered in imon log (Doc ID 845895.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 29-Mar-2013***

Symptoms

Symptom 1. The database and instances cannot be started with srvctl.

For example:

$ srvctl start instance -d PROD -i PROD1
PRKP-1001 : Error starting instance PROD1 on node oradb1
CRS-0215: Could not start resource 'ora.PROD.PROD1.inst'.



The reason can be determined by checking the resource log in the $RDBMS_HOME/log/[nodename]/racg directory.  The file is named imon_[dbname].

Symptom 2. The imon log shows ORA-01565.

For example:

2009-03-05 02:07:33.519: [ RACG][6] [6031][6][ora.PROD.PROD1.inst]:
SQL*Plus: Release 10.2.0.2.0 - Production on Thu Mar 5 02:07:30 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Enter user-name: Connected to an idle instance.

SQL> ORA-01565: error in identifying file '+DATA_DG/PROD/spfilePROD.ora'
ORA
2009-03-05 02:07:33.519: [ RACG][6] [6031][6][ora.PROD.PROD1.inst]: -17503: ksfdopn:2 Failed
to open file +DATA_DG/PROD/spfilePROD.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DATA_DG/PROD/spfilePRO
ORA-01078: failure in processing system parameters
SQL> Disconnected

 

Symptom 3. Starting the database manually with sqlplus may also fail with the same error.

For example:


SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 16 00:05:24 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORA-01565: error in identifying file '+DATA_DG/PROD/spfilePROD.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA_DG/PROD/spfilePROD.ora
ORA-01000: maximum open cursors exceeded
SQL> exit
Disconnected



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
 Symptom 1. The database and instances cannot be started with srvctl.
 Symptom 2. The imon log shows ORA-01565.
 Symptom 3. Starting the database manually with sqlplus may also fail with the same error.
Cause
Solution
 Where Oracle looks for the spfile
 Finding the spfile
 Correcting the pointer to the spfile
 Recreating the spfile
 Changing SPFILE or ORACLE_HOME values in the OCR
 Restart the instance
 Scalability RAC Community
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.