RAC: SRVCTL Cannot Start Database or Instances - ORA-01565 Encountered in imon log
Last updated on FEBRUARY 06, 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
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