Search

Friday, August 12, 2016

ASM instance does not start / EVMD.BIN in State INTERMEDIATE



ASM instance does not start / EVMD.BIN in State INTERMEDIATE

Reported error in oraagent_grid.log       : CRS-5017: The resource action "ora.asm start" encountered the following error: 
                                            ORA-12546: TNS:permission denied
Reported Clusterware Error in CW alert.log: [/u01/app/11204/grid/bin/oraagent.bin(6784)]CRS-5011:Check of resource "+ASM" failed: 
                                            [ohasd(6536)]CRS-2807:Resource 'ora.asm' failed to start automatically. 
Reported Error in ASM alert log           : ORA-07274: spdcr: access error, access to oracle denied.
                                            Linux-x86_64 Error: 13: Permission denied
                                            PSP0 (ospid: 3582): terminating the instance due to error 7274
...
Testing scenario :
[grid@grac41 grac41]$ cd $GRID_HOME/bin
[grid@grac41 bin]$ chmod 444 oracle
[grid@grac41 bin]$ ls -l oracle
-r--r--r--. 1 grid oinstall 209950863 May  4 10:26 oracle
# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
 
Clusterware status :
[grid@grac41 bin]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4529: Cluster Synchronization Services is online
CRS-4534: Cannot communicate with Event Manager
 
[grid@grac41 bin]$ crsi
NAME                           TARGET     STATE           SERVER       STATE_DETAILS   
-------------------------      ---------- ----------      ------------ ------------------
ora.asm                        ONLINE     OFFLINE                        
ora.cluster_interconnect.haip  ONLINE     ONLINE          grac41         
ora.crf                        ONLINE     ONLINE          grac41         
ora.crsd                       ONLINE     OFFLINE                        
ora.cssd                       ONLINE     ONLINE          grac41         
ora.cssdmonitor                ONLINE     ONLINE          grac41         
ora.ctssd                      ONLINE     ONLINE          grac41       OBSERVER  
ora.diskmon                    OFFLINE    OFFLINE                        
ora.drivers.acfs               ONLINE     ONLINE          grac41         
ora.evmd                       ONLINE     INTERMEDIATE    grac41         
ora.gipcd                      ONLINE     ONLINE          grac41         
ora.gpnpd                      ONLINE     ONLINE          grac41         
ora.mdnsd                      ONLINE     ONLINE          grac41         
 
[grid@grac41 bin]$ ps -elf | egrep "PID|d.bin|ohas|oraagent|orarootagent|cssdagent|cssdmonitor" | grep -v grep
F S UID        PID  PPID  C PRI  NI ADDR SZ WCHAN  STIME TTY          TIME CMD
4 S root      3408 28369  0  80   0 - 30896 poll_s 10:03 pts/3    00:00:00 view ./agent/crsd/oraagent_grid/oraagent_grid.log
4 S root      6098     1  0  80   0 -  2846 pipe_w May24 ?        00:00:01 /bin/sh /etc/init.d/init.ohasd run
4 S root      6536     1  2  80   0 - 179140 futex_ 13:51 ?       00:01:11 /u01/app/11204/grid/bin/ohasd.bin reboot
4 S grid      6784     1  0  80   0 - 173902 futex_ 13:52 ?       00:00:05 /u01/app/11204/grid/bin/oraagent.bin
0 S grid      6795     1  0  80   0 - 74289 poll_s 13:52 ?        00:00:00 /u01/app/11204/grid/bin/mdnsd.bin
0 S grid      6806     1  0  80   0 - 127382 hrtime 13:52 ?       00:00:04 /u01/app/11204/grid/bin/gpnpd.bin
0 S grid      6823     1  1  80   0 - 159711 hrtime 13:52 ?       00:00:39 /u01/app/11204/grid/bin/gipcd.bin
4 S root      6825     1  0  80   0 - 168698 futex_ 13:52 ?       00:00:24 /u01/app/11204/grid/bin/orarootagent.bin
4 S root      6840     1  4 -40   - - 160907 hrtime 13:52 ?       00:02:29 /u01/app/11204/grid/bin/osysmond.bin
4 S root      6851     1  0 -40   - - 162793 futex_ 13:52 ?       00:00:07 /u01/app/11204/grid/bin/cssdmonitor
4 S root      6870     1  0 -40   - - 162920 futex_ 13:52 ?       00:00:07 /u01/app/11204/grid/bin/cssdagent
4 S grid      6881     1  2 -40   - - 166593 futex_ 13:52 ?       00:01:24 /u01/app/11204/grid/bin/ocssd.bin 
4 S root      7256     1  6 -40   - - 178527 poll_s 13:52 ?       00:03:28 /u01/app/11204/grid/bin/ologgerd -M -d ..
4 S root      7847     1  0  80   0 - 159388 futex_ 13:52 ?       00:00:29 /u01/app/11204/grid/bin/octssd.bin reboot
0 S grid      7875     1  0  80   0 - 76018 hrtime 13:52 ?        00:00:05 /u01/app/11204/grid/bin/evmd.bin
 
Tracefile Details:
CW alert.log
[/u01/app/11204/grid/bin/oraagent.bin(6784)]CRS-5011:Check of resource "+ASM" failed: 
          details at "(:CLSN00006:)" in "../agent/ohasd/oraagent_grid/oraagent_grid.log"
[/u01/app/11204/grid/bin/oraagent.bin(6784)]CRS-5011:Check of resource "+ASM" failed: 
          details at "(:CLSN00006:)" in "../agent/ohasd/oraagent_grid/oraagent_grid.log"
2014-05-25 13:55:04.626:  [ohasd(6536)]CRS-2807:Resource 'ora.asm' failed to start automatically.
2014-05-25 13:55:04.626:  [ohasd(6536)]CRS-2807:Resource 'ora.crsd' failed to start automatically.
 
ASM alert log : ./log/diag/asm/+asm/+ASM1/trace/alert_+ASM1.log
Sun May 25 13:50:50 2014
Errors in file /u01/app/11204/grid/log/diag/asm/+asm/+ASM1/trace/+ASM1_psp0_3582.trc:
ORA-07274: spdcr: access error, access to oracle denied.
Linux-x86_64 Error: 13: Permission denied
PSP0 (ospid: 3582): terminating the instance due to error 7274
Sun May 25 13:50:50 2014
System state dump requested by (instance=1, osid=3591 (DIAG)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/11204/grid/log/diag/asm/+asm/+ASM1/trace/+ASM1_diag_3591_20140525135050.trc
Dumping diagnostic data in directory=[cdmp_20140525135050], requested by (instance=1, osid=3591 (DIAG)), 
   summary=[abnormal instance termination].
Instance terminated by PSP0, pid = 3582
 
agent/ohasd/oraagent_grid/oraagent_grid.log
2014-05-25 13:54:54.226: [    AGFW][3273144064]{0:0:2} ora.asm 1 1 state changed from: STARTING to: OFFLINE
2014-05-25 13:54:54.229: [    AGFW][3273144064]{0:0:2} Agent sending last reply for: RESOURCE_START[ora.asm 1 1] ID 4098:624
2014-05-25 13:54:54.239: [    AGFW][3273144064]{0:0:2} Agent received the message: RESOURCE_CLEAN[ora.asm 1 1] ID 4100:644
2014-05-25 13:54:54.239: [    AGFW][3273144064]{0:0:2} Preparing CLEAN command for: ora.asm 1 1
2014-05-25 13:54:54.239: [    AGFW][3273144064]{0:0:2} ora.asm 1 1 state changed from: OFFLINE to: CLEANING
 
Debugging steps :
  Try to start ASM databbase manually 
  [grid@grac41 grid]$ sqlplus / as sysasm
  ERROR:
  ORA-12546: TNS:permission denied
 
Fix: 
  [grid@grac41 grid]$  chmod 6751  $GRID_HOME/bin/oracle
  [grid@grac41 grid]$  ls -l  $GRID_HOME/bin/oracle
   -rwsr-s--x. 1 grid oinstall 209950863 May  4 10:26 /u01/app/11204/grid/bin/oracle
  [grid@grac41 grid]$ sqlplus / as sysasm
  --> works now again
 
EVMD.BIN does not start : State INTERMEDIATE 
==> For further details see GENERIC Networking troubleshooting chapter