Saturday, December 17, 2016


Oracle Cluster and DB restart 

While restarting you can start cluster services and then databases .

Stop:
   Stop Agent 
   /u01/app/oracle/agent12c/core/12.1.0.5.0/bin/emctl stop agent
   Stop DB
set db enviroment
srvctl status database -d OBID1 -v
srvctl stop database -d OBID1
         **   srvctl stop database –d OBIP –o immediate
srvctl status instance -i OBID12 -d OBID1  
        -- i instnace name, d database name

   Stop Cluster services
In 11gR2 and beyond, you can start the HA Service Daemon (OHASD) and Clusterware stack in two ways:

    1) The crsctl command is sudo.  sudo -l for path
                User oracle may run the following commands on this host:
                (root) NOPASSWD: /u01/oracle/11.2.0/grid/bin/crsctl
             
              /usr/local/bin/sudo /u01/oracle/11.2.0/grid/bin/ crsctl check crs   
              /usr/local/bin/sudo /u01/oracle/11.2.0/grid/bin/crsctl stop crs

  Check CRS sample output
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


       2) set asm environment           
                  crsctl status resource -t
                  crsctl stop cluster -all
                  crsctl start has (additional )

  Start: 
     Start Agent 
/u01/app/oracle/agent12c/core/12.1.0.5.0/bin/emctl stop agent
    Start cluster 
    crsctl status resource -t
   crsctl start cluster –all  ( Or usr/local/bin/sudo /u01/oracle/11.2.0/grid/bin/crsctl start crs )
    crsctl start has 
         --Start CRS if needed.  Skip if all cluster resources are online (except DB)
   Start DB 
   srvctl start database -d OBID1
















No comments:

Post a Comment