In Oracle : Oracle RAC Services Administration (11gR2)

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle DBA

Real Application Cluster (RAC) Maintenance tasks Backup and Recovery Database Architecture Replication Oracle Performance Tuning Oracle DBA - Other articles Oracle scripts/ Selects for DBA Oracle Errors (ORA-nnnnn)

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle DBA -> Oracle RAC (Real Application Cluster)

-> Oracle RAC Services Administration (11gR2)

 

 Oracle RAC Services Administration (11gR2)

 

 

Checking CRS Status       

Clusterware Resource Status Check

Stop the Oracle clusterware stack   

Start the Oracle clusterware stack

Start the Oracle Database

Stop the Oracle Database

Checking CRS Status

 

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
 

 


srvctl status nodeapps

 

VIP tzdev1vip is enabled
VIP tzdev1vip is running on node: tzdev1rac
VIP tzdev2vip is enabled
VIP tzdev2vip is running on node: tzdev2rac
Network is enabled
Network is running on node: tzdev1rac
Network is running on node: tzdev2rac
GSD is disabled
GSD is not running on node: tzdev1rac
GSD is not running on node: tzdev2rac
ONS is enabled
ONS daemon is running on node: tzdev1rac
ONS daemon is running on node: tzdev2rac
eONS is enabled
eONS daemon is running on node: tzdev1rac
eONS daemon is running on node: tzdev2rac

 

Clusterware Resource Status Check

 

$ crsctl status resource -t
 

--------------------------------------------------------------------------------
NAME                  TARGET  STATE      SERVER            STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr    

                      ONLINE  ONLINE    tzdev1rac
                      ONLINE  ONLINE    tzdev2rac
ora.asm              

                      OFFLINE OFFLINE   tzdev1rac
                      OFFLINE OFFLINE   tzdev2rac
ora.eons             

                      ONLINE  ONLINE    tzdev1rac
                      ONLINE  ONLINE    tzdev2rac
ora.gsd
                      OFFLINE OFFLINE   tzdev1rac
                      OFFLINE OFFLINE   tzdev2rac
ora.net1.network
                      ONLINE  ONLINE    tzdev1rac
                      ONLINE  ONLINE    tzdev2rac
ora.ons
                      ONLINE  ONLINE    tzdev1rac
                      ONLINE  ONLINE    tzdev2rac
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1                     ONLINE  ONLINE    tzdev1rac
ora.LISTENER_SCAN2.lsnr
1                     ONLINE  ONLINE    tzdev2rac
ora.LISTENER_SCAN3.lsnr
1                     ONLINE  ONLINE    tzdev2rac
ora.oc4j
1                     OFFLINE OFFLINE
ora.scan1.vip
1                     ONLINE  ONLINE    tzdev1rac
ora.scan2.vip
1                     ONLINE  ONLINE    tzdev2rac
ora.scan3.vip
1                     ONLINE  ONLINE    tzdev2rac
ora.trezor.db
1                     ONLINE  ONLINE    tzdev1rac         Open
2                     ONLINE  ONLINE    tzdev2rac
ora.tzdev1rac.vip
1                     ONLINE  ONLINE    tzdev1rac
ora.tzdev2rac.vip
1                     ONLINE  ONLINE    tzdev2rac

 

 

Stop the Oracle clusterware stack

 

crsctl stop crs or you can run

crsctl stop has


CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'tzdev1rac'
CRS-2673: Attempting to stop 'ora.crsd' on 'tzdev1rac'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'tzdev1rac'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'tzdev1rac'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'tzdev1rac'
CRS-2673: Attempting to stop 'ora.trezor.db' on 'tzdev1rac'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'tzdev1rac'
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'tzdev1rac' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'tzdev1rac'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'tzdev1rac' succeeded
CRS-2673: Attempting to stop 'ora.tzdev1rac.vip' on 'tzdev1rac'
CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'tzdev1rac' succeeded
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'tzdev1rac'
CRS-2677: Stop of 'ora.tzdev1rac.vip' on 'tzdev1rac' succeeded
CRS-2672: Attempting to start 'ora.tzdev1rac.vip' on 'tzdev2rac'
CRS-2677: Stop of 'ora.scan2.vip' on 'tzdev1rac' succeeded
CRS-2672: Attempting to start 'ora.scan2.vip' on 'tzdev2rac'
CRS-2677: Stop of 'ora.scan3.vip' on 'tzdev1rac' succeeded
CRS-2672: Attempting to start 'ora.scan3.vip' on 'tzdev2rac'
CRS-2676: Start of 'ora.tzdev1rac.vip' on 'tzdev2rac' succeeded
CRS-2677: Stop of 'ora.trezor.db' on 'tzdev1rac' succeeded
CRS-2676: Start of 'ora.scan2.vip' on 'tzdev2rac' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'tzdev2rac'
CRS-2676: Start of 'ora.scan3.vip' on 'tzdev2rac' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'tzdev2rac'
CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'tzdev2rac' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'tzdev2rac' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'tzdev1rac'
CRS-2673: Attempting to stop 'ora.eons' on 'tzdev1rac'
CRS-2677: Stop of 'ora.ons' on 'tzdev1rac' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'tzdev1rac'
CRS-2677: Stop of 'ora.net1.network' on 'tzdev1rac' succeeded
CRS-2677: Stop of 'ora.eons' on 'tzdev1rac' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'tzdev1rac' has completed
CRS-2677: Stop of 'ora.crsd' on 'tzdev1rac' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'tzdev1rac'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'tzdev1rac'
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'tzdev1rac'
CRS-2673: Attempting to stop 'ora.ctssd' on 'tzdev1rac'
CRS-2673: Attempting to stop 'ora.evmd' on 'tzdev1rac'
CRS-2677: Stop of 'ora.cssdmonitor' on 'tzdev1rac' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'tzdev1rac' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'tzdev1rac' succeeded
CRS-2677: Stop of 'ora.evmd' on 'tzdev1rac' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'tzdev1rac' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'tzdev1rac'
CRS-2677: Stop of 'ora.cssd' on 'tzdev1rac' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on 'tzdev1rac'
CRS-2673: Attempting to stop 'ora.gipcd' on 'tzdev1rac'
CRS-2677: Stop of 'ora.gipcd' on 'tzdev1rac' succeeded
CRS-2677: Stop of 'ora.diskmon' on 'tzdev1rac' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'tzdev1rac' has completed
CRS-4133: Oracle High Availability Services has been stopped.
 

Start the Oracle clusterware stack

 

crsctl start crs or you can run

crsctl start has
CRS-4123: Oracle High Availability Services has been started.

 

Start the Oracle Database

 

To start all Oracle RAC instances for a database, enter the following command, where db_name is the name of the database:
$ oracle_home/bin/srvctl start database -d db_name     (this command is starting all the instances)

 

Stop the Oracle Database

 

To shut down all Oracle RAC instances for a database, enter the following command, where db_name is the name of the database:
$ oracle_home/bin/srvctl stop database -d db_name     (this command is starting all the instances)

 

 

ATTENTION:

  • When you stop the database you must be sure that no application is using the database;

  • When you start the clusterware you must be sure that the database is running.

 

In-Oracle.com  -> Oracle DBA -> Oracle RAC (Real Application Cluster)

-> Oracle RAC Services Administration (11gR2)

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.