My Oracle Support Banner

Oracle Database Fails to Start with Error ORA-12547 (Doc ID 1307075.1)

Last updated on JULY 26, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 17-Oct-2012***
***Checked for relevance on 11-May-2014***

Symptoms


1. When attempting to startup database,the following error occurs.

ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/RACDB/spfileRACDB.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/RACDB/spfileRACDB.ora
ORA-12547: TNS:lost contact



2. DB alert log:

ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=$GI_HOME/bin/oracle)(ARGV0=oracle+ASM_pmon_RACDB)(ENVS='ORACLE_HOME=$GI_HOME,ORACLE_SID=+ASM')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file $ORACLE_BASE/diag/rdbms/RACDB/RACDB/trace/RACDB_pmon_26924.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact



3. ASM instance and required diskgroups are online and no error in ASM alert:

crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg ONLINE ONLINE host1 
ora.DATA2.dg ONLINE ONLINE host1 
ora.asm ONLINE ONLINE prod Started

Changes

 

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
Changes
Cause
Solution


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