SAP Knowledge Base Article - Preview

1894803 - Oracle database instance does not start

Symptom

When starting the database instance using crsctl you see the following errors:

$ crsctl start resource ora.<sid>.db

CRS-2672: Attempting to start 'ora.<sid>.db' on '<hostname>'
CRS-5017: The resource action "ora.<sid>.db start" encountered the following error:
ORA-00205: error in identifying control file, check alert log for more info
. For details refer to "(:CLSN00107:)" in "/oracle/grid/11203/log/<hostname>/agent/ohasd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.<sid>.db' on '<hostname>' failed
CRS-2679: Attempting to clean 'ora.<sid>.db' on '<hostname>'
CRS-2681: Clean of 'ora.<sid>.db' on '<hostname>' succeeded
CRS-4000: Command Start failed, or completed with errors.

Or directly on sqlplus:

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1185927168 bytes
Fixed Size                  2227744 bytes
Variable Size             603980256 bytes
Database Buffers          570425344 bytes
Redo Buffers                9293824 bytes
ORA-00205: error in identifying control file, check alert log for more info

On the alert.log, you see the following errors:

ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DATA/cntrl<sid>.dbf'
ORA-17503: ksfdopn:2 Failed to open file +DATA/cntrl<sid>.dbf
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Operation not permitted
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = <id1> (dba), current egid = <id2> (asmadmin)
ORA-205 signalled during: ALTER DATABASE MOUNT /* db agent *//* {0:0:231} */...


Read more...

Environment

  • Oracle 11g or newer
  • Unix or Linux OS
  • Automatic Storage Management (ASM) with or without RAC

Product

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

crash start srvctl sqlplus startup sysdba sysadm 12c 12.1 12.1.0.2 11.2.0.2 11.2.0.3 11.2.0.4 , KBA , BC-DB-ORA , Oracle , BC-DB-ORA-RAC , Oracle Real Application Clusters (RAC) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.