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

Last updated on OCTOBER 12, 2016

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms