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***
Symptom 1. The database and instances cannot be started with srvctl.
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.
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'
2009-03-05 02:07:33.519: [ RACG] [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
Symptom 3. Starting the database manually with sqlplus may also fail with the same error.
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
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
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
|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.|
|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|