RAC Scripts

Display clusterware resources  in tabular form :    crs

  •  Output from script:   crs
[root@grac41 bin]#  crs
NAME                           TARGET     STATE           SERVER       STATE_DETAILS   
-------------------------      ---------- ----------      ------------ ------------------
ora.ASMLIB_DG.dg               ONLINE     ONLINE          grac41        
ora.ASMLIB_DG.dg               ONLINE     ONLINE          grac42        
ora.ASMLIB_DG.dg               ONLINE     ONLINE          grac43        
ora.DATA.dg                    ONLINE     ONLINE          grac41        
ora.DATA.dg                    ONLINE     ONLINE          grac42        
ora.DATA.dg                    ONLINE     ONLINE          grac43        
ora.FRA.dg                     ONLINE     ONLINE          grac41        
ora.FRA.dg                     ONLINE     ONLINE          grac42        
ora.FRA.dg                     ONLINE     ONLINE          grac43        
ora.LISTENER.lsnr              ONLINE     ONLINE          grac41        
ora.LISTENER.lsnr              ONLINE     ONLINE          grac42        
ora.LISTENER.lsnr              ONLINE     ONLINE          grac43        
ora.OCR.dg                     ONLINE     ONLINE          grac41        
ora.OCR.dg                     ONLINE     ONLINE          grac42        
ora.OCR.dg                     ONLINE     ONLINE          grac43        
ora.SSD.dg                     ONLINE     ONLINE          grac41        
ora.SSD.dg                     ONLINE     ONLINE          grac42        
ora.SSD.dg                     ONLINE     ONLINE          grac43        
ora.asm                        ONLINE     ONLINE          grac41       Started 
ora.asm                        ONLINE     ONLINE          grac42       Started 
ora.asm                        ONLINE     ONLINE          grac43       Started 
ora.gsd                        OFFLINE    OFFLINE         grac41        
ora.gsd                        OFFLINE    OFFLINE         grac42        
ora.gsd                        OFFLINE    OFFLINE         grac43        
ora.net1.network               ONLINE     ONLINE          grac41        
ora.net1.network               ONLINE     ONLINE          grac42        
ora.net1.network               ONLINE     ONLINE          grac43        
ora.ons                        ONLINE     ONLINE          grac41        
ora.ons                        ONLINE     ONLINE          grac42        
ora.ons                        ONLINE     ONLINE          grac43        
ora.registry.acfs              ONLINE     ONLINE          grac41        
ora.registry.acfs              ONLINE     ONLINE          grac42        
ora.registry.acfs              ONLINE     ONLINE          grac43        
ora.LISTENER_SCAN1.lsnr        ONLINE     ONLINE          grac42        
ora.LISTENER_SCAN2.lsnr        ONLINE     ONLINE          grac43        
ora.cvu                        ONLINE     ONLINE          grac43        
ora.gns                        ONLINE     ONLINE          grac43        
ora.gns.vip                    ONLINE     ONLINE          grac43        
ora.grac4.db                   ONLINE     ONLINE          grac41       Open 
ora.grac4.db                   ONLINE     ONLINE          grac42       Open 
ora.grac4.db                   ONLINE     ONLINE          grac43       Open 
ora.grac4.grac41.svc           ONLINE     ONLINE          grac41        
ora.grac4.grac42.svc           ONLINE     ONLINE          grac42        
ora.grac4.report.svc           ONLINE     ONLINE          grac42        
ora.grac41.vip                 ONLINE     ONLINE          grac41        
ora.grac42.vip                 ONLINE     ONLINE          grac42        
ora.grac43.vip                 ONLINE     ONLINE          grac43        
ora.oc4j                       ONLINE     ONLINE          grac43        
ora.scan1.vip                  ONLINE     ONLINE          grac42        
ora.scan2.vip                  ONLINE     ONLINE          grac43

Display Local Clusterware Resources:  crsi

  • Output from script : crsi
[root@grac41 bin]# crsi
NAME                           TARGET     STATE           SERVER       STATE_DETAILS   
-------------------------      ---------- ----------      ------------ ------------------
ora.asm                        ONLINE     ONLINE          grac41       Started 
ora.cluster_interconnect.haip  ONLINE     ONLINE          grac41        
ora.crf                        ONLINE     ONLINE          grac41        
ora.crsd                       ONLINE     ONLINE          grac41        
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     ONLINE          grac41        
ora.gipcd                      ONLINE     ONLINE          grac41        
ora.gpnpd                      ONLINE     ONLINE          grac41        
ora.mdnsd                      ONLINE     ONLINE          grac41

Display CHM Metrics in a human readable format

Debug a failed Clusterware Startup with cluvfy

Display Server Pool details

Verify major OS settings

DTRACE script to debug Clusterware Startup problems

 Shell Scripts to display Errors/Events inside Custerware Error Logs

4 thoughts on “RAC Scripts”

  1. I can’t find your fn.sh script, can you post or mail to me?

    thanks

    this is very good website.

    1. Hi Steven,

      you can NOW locate the scritps via the Menu Bar -> RAC -> RAC Generic -> RAC Scripts ->

      8. Shell Scripts to display Errors/Events inside Custerware Error Logs

      br Helmut

Leave a Reply

Your email address will not be published. Required fields are marked *