ASM Instance doesn't start in Oracle Restart (Standalone GI) enviroment after node reboot (Doc ID 1917176.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

ora.asm resource is reported as offline after reboot

$crsctl stat res -t -init  

--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADG.dg
              OFFLINE OFFLINE      ecmdevdb                                    
ora.FLASHDG.dg
              OFFLINE OFFLINE      ecmdevdb                                    
ora.LISTENER.lsnr
              OFFLINE OFFLINE      ecmdevdb                                    
ora.REDODG.dg
              OFFLINE OFFLINE      ecmdevdb                                    
ora.asm
              OFFLINE OFFLINE      ecmdevdb                 Instance Shutdown     >>>>>>>>>>>>>>
ora.ons
              OFFLINE OFFLINE      ecmdevdb                                    
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
     1        ONLINE  OFFLINE         >>>>>>          The process ocssd.bin needs to be running for this to work but this process has not started.                               
ora.diskmon
     1        OFFLINE OFFLINE                                                  
ora.ecsmall.db
     1        OFFLINE OFFLINE                               Instance Shutdown  
ora.evmd
     1        ONLINE  ONLINE       ecmdevdb                                   

 

$ps -ef|grep d.bin 

Above ps command will show only following processes after node reboot or manually start of HAS stack. cssd demon is missing from the output.

/export/u01/app/oracle/product/11.2.0/grid/bin/ohasd.bin reboot
/export/u01/app/oracle/product/11.2.0/grid/bin/oraagent.bin
/export/u01/app/oracle/product/11.2.0/grid/bin/evmd.bin
/export/u01/app/oracle/product/11.2.0/grid/bin/evmlogger.bin -o /export/u01/app

 

<grid_home>/log/<node>/alert<node>.log

2014-08-07 16:07:15.526:
[/export/u01/app/oracle/product/11.2.0/grid/bin/oraagent.bin(16807)]CRS-5818:Aborted command 'check' for resource 'ora.DATADG.dg'. Details at (:CRSAGF00113:) {0:0:2} in /export/u01/app/oracle/product/11.2.0/grid/log/ecmdevdb/agent/ohasd/oraagent_oracle/oraagent_oracle.log.
2014-08-07 16:07:15.535:
[/export/u01/app/oracle/product/11.2.0/grid/bin/oraagent.bin(16807)]CRS-5818:Aborted command 'check' for resource 'ora.FLASHDG.dg'. Details at (:CRSAGF00113:) {0:0:2} in /export/u01/app/oracle/product/11.2.0/grid/log/ecmdevdb/agent/ohasd/oraagent_oracle/oraagent_oracle.log.

  

grid_home>/log/<node>/agent/ohasd/oraagent_oracle/oraagent_oracle.log

2014-08-07 16:06:50.553: [    AGFW][9]{0:0:2} Agent sending last reply for: RESOURCE_DELETE[ora.ecsmall.db 1 1] ID 4358:162
2014-08-07 16:06:50.554: [    AGFW][9]{0:0:2} ora.ecsmall.db 1 1 marked as deleted.
2014-08-07 16:07:15.526: [   AGENT][13]{0:0:2} {0:0:2} Created alert : (:CRSAGF00113:) :  Aborting the command: check for resource: ora.DATADG.dg ecmdevdb 1
2014-08-07 16:07:15.526: [ora.DATADG.dg][13]{0:0:2} [check] (:CLSN00110:) clsn_agent::abort {
2014-08-07 16:07:15.526: [ora.DATADG.dg][13]{0:0:2} [check] abort {
2014-08-07 16:07:15.526: [ora.DATADG.dg][13]{0:0:2} [check] Agent::abort last call info:  "Agent::Agent refreshAttr"
2014-08-07 16:07:15.526: [ora.DATADG.dg][13]{0:0:2} [check] DgpAgent::abortPreLock cmdId 0 m_pConnxn
2014-08-07 16:07:15.526: [ora.DATADG.dg][13]{0:0:2} [check] abort command: check
2014-08-07 16:07:15.526: [ora.DATADG.dg][13]{0:0:2} [check] tryActionLock {
2014-08-07 16:07:15.535: [   AGENT][15]{0:0:2} {0:0:2} Created alert : (:CRSAGF00113:) :  Aborting the command: check for resource: ora.FLASHDG.dg ecmdevdb 1
2014-08-07 16:07:15.535: [ora.FLASHDG.dg][15]{0:0:2} [check] (:CLSN00110:) clsn_agent::abort {
2014-08-07 16:07:15.535: [ora.FLASHDG.dg][15]{0:0:2} [check] abort {
2014-08-07 16:07:15.535: [ora.FLASHDG.dg][15]{0:0:2} [check] Agent::abort last call info:  "Agent::Agent refreshAttr"
2014-08-07 16:07:15.535: [ora.FLASHDG.dg][15]{0:0:2} [check] DgpAgent::abortPreLock cmdId 0 m_pConnxn
2014-08-07 16:07:15.535: [   AGENT][7]{0:0:2} {0:0:2} Created alert : (:CRSAGF00113:) :  Aborting the command: check for resource: ora.REDODG.dg ecmdevdb 1

 

 

Changes

 Newly installed Standalone Grid Infrastructure  environment.

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