miércoles, 1 de agosto de 2012

Oracle RAC CRS Resources operations

On the previous post we saw how to install an Oracle RAC environment for testing purposes, in this section you will find some commands to manage your Oracle RAC infraestructure.

Stop CRS


[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl stop crs
CRS-2791: Iniciando cierre de los recursos gestionados por los Servicios de Alta Disponibilidad de Oracle en 'racnode1'
CRS-2673: Intentando parar ''ora.crsd'' en ''racnode1''
CRS-2790: Iniciando cierre de los recursos gestionados por Cluster Ready Services en 'racnode1'
CRS-2673: Intentando parar ''ora.CRS.dg'' en ''racnode1''
CRS-2673: Intentando parar ''ora.racdb.servicetest.svc'' en ''racnode1''
.
.
.
CRS-2677: La parada de ''ora.gipcd'' en ''racnode1'' se ha realizado correctamente
CRS-2677: La parada de ''ora.diskmon'' en ''racnode1'' se ha realizado correctamente
CRS-2793: Ha terminado el cierre de los recursos gestionados por los Servicios de Alta Disponibilidad de Oracle en 'racnode1'
CRS-4133: Oracle High Availability Services has been stopped.

Start CRS

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl start crs
CRS-4123: Oracle High Availability Services has been started.

CRS resources status


[root@racnode2 ~]# /u01/app/11.2.0/grid/bin/crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
               ONLINE  ONLINE       racnode2                                     
ora.DATA.dg
               ONLINE  ONLINE       racnode2                                     
ora.FRA.dg
               ONLINE  ONLINE       racnode2                                     
ora.LISTENER.lsnr
               ONLINE  ONLINE       racnode2                                     
ora.asm
               ONLINE  ONLINE       racnode2                                     
ora.eons
               ONLINE  ONLINE       racnode2                                     
ora.gsd
               OFFLINE OFFLINE      racnode2                                     
ora.net1.network
               ONLINE  ONLINE       racnode2                                     
ora.ons
               ONLINE  ONLINE       racnode2                                     
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       racnode2                                     
ora.oc4j
      1        OFFLINE OFFLINE                                                   
ora.racdb.db
      1        ONLINE  OFFLINE                                                   
      2        ONLINE  ONLINE       racnode2                                     
ora.racdb.servicetest.svc
      1        ONLINE  ONLINE       racnode2                                     
ora.racnode1.vip
      1        ONLINE  INTERMEDIATE racnode2                                     
ora.racnode2.vip
      1        ONLINE  ONLINE       racnode2                                     
ora.scan1.vip
      1        ONLINE  ONLINE       racnode2        

The Legacy way.

root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.CRS.dg     ora....up.type ONLINE    ONLINE    racnode1    
ora.DATA.dg    ora....up.type ONLINE    ONLINE    racnode1    
ora.FRA.dg     ora....up.type ONLINE    ONLINE    racnode1    
ora....ER.lsnr ora....er.type ONLINE    ONLINE    racnode1    
ora....N1.lsnr ora....er.type ONLINE    ONLINE    racnode2    
ora.asm        ora.asm.type   ONLINE    ONLINE    racnode1    
ora.eons       ora.eons.type  ONLINE    ONLINE    racnode1    
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
ora....network ora....rk.type ONLINE    ONLINE    racnode1    
ora.oc4j       ora.oc4j.type  OFFLINE   OFFLINE               
ora.ons        ora.ons.type   ONLINE    ONLINE    racnode1    
ora.racdb.db   ora....se.type ONLINE    ONLINE    racnode1    
ora....est.svc ora....ce.type ONLINE    ONLINE    racnode2    
ora....SM1.asm application    ONLINE    ONLINE    racnode1    
ora....E1.lsnr application    ONLINE    ONLINE    racnode1    
ora....de1.gsd application    OFFLINE   OFFLINE               
ora....de1.ons application    ONLINE    ONLINE    racnode1    
ora....de1.vip ora....t1.type ONLINE    ONLINE    racnode1    
ora....SM2.asm application    ONLINE    ONLINE    racnode2    
ora....E2.lsnr application    ONLINE    ONLINE    racnode2    
ora....de2.gsd application    OFFLINE   OFFLINE               
ora....de2.ons application    ONLINE    ONLINE    racnode2    
ora....de2.vip ora....t1.type ONLINE    ONLINE    racnode2    
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    racnode2    

Stop cluster on current node.

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl stop cluster

Stop cluster on a node.

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl stop cluster -n racnode2

Stop cluster on both nodes.

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl stop cluster -all

Start cluster.

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl start cluster -all

Start Cluster on a node.

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl start cluster -n racnode2

Check Cluster status.


root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

Check CRS status.

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

Check OHASD Daemon.

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl check has
CRS-4638: Oracle High Availability Services is online

Disable CRS Daemon.

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl disable crs

Enable CRS Daemon.

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl enable crs

Disable Cluster resource.

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl disable resource ora.rcat.db

Enable Cluster resource.

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl enable resource ora.rcat.db

Delete Cluster resource.

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl delete resource ora.rcat.db

Get permissions from a cluster resource.


[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl getperm resource ora.racdb.db -g dba
Name: ora.racdb.db
r--

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crs_getperm ora.racdb.db -g dba
Name: ora.racdb.db
r--

Get Oracle Clusterware versions.

root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl query crs softwareversion
Oracle Clusterware version on node [racnode1] is [11.2.0.1.0]
[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.1.0]
[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [11.2.0.1.0]