Wednesday, February 10, 2016

RAC Administration

How to check the status of CRS on specific node?

[ora11g@racnode1 ~]$ crsctl check crs

Note: crsctl command will be present in GRID_INRA_HOME

How to check the status of services on all nodes:

[ora11g@racnode1 ~]$ srvctl status nodeapps

How to check the status of complete clusterware stack on all nodes:

[ora11g@racnode1 ~]$ crsctl status resource -t

How to check the status of clusterware servers:

[ora11g@racnode1 ~]$ crsctl status server -f

How to stop csr on all nodes of clusterware:

[root@racnode1 bin]# ./crsctl stop cluster -all

How to stop crs on specific node:

[root@racnode1 bin]# ./crsctl stop crs

How to start crs on specific node:

[root@racnode1 bin]# ./crsctl start crs

How to check the status of specific Instance across cluster nodes:

[ora11g@racnode1 ~]$ srvctl status instance -d racdb -i racdb1

How to check the status of all instances across the cluster nodes:

[ora11g@racnode1 ~]$ srvctl status instance -d racdb -i racdb1,racdb2,racdb3,racdb4

How to start specific Instance across cluster nodes:

[ora11g@racnode1 ~]$ srvctl start instance -d racdb -i racdb4

How to check the status of database across cluster nodes:

[ora11g@racnode1 ~]$ srvctl status database -d racdb

How to stop cluster database:

[ora11g@racnode1 ~]$ srvctl stop database -d racdb

-- Start/ Stop database / instance services status:
From oracle user
1) Verify instance status

$ srvctl status instance -d EHISKOL -i EHISKOL2
Instance EHISKOL2 is running on node ekrac2

2) To Stop instance

$ srvctl stop instance -d EHISKOL -i EHISKOL2

3) To start instance

$ srvctl start instance -d EHISKOL -i EHISKOL2

-- If below message found, then instance services might be runnng.

PRCC-1015 : EHISKOL was already running on ekrac2
PRCR-1004 : Resource ora.ehiskol.db is already running

4) To stop all instance services across the nodes:

$ srvctl stop database -d EHISKOL

-- Start/ Stop SCAN listeners in RAC databases:

1) Verify SCAN listener status:

$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node ekrac2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node ekrac1
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node ekrac1

$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): ekrac2,ekrac1

Note: Assume 3 scan IP configured with DNS.

When single / default IP configured with SCAN listener, then status will be shown like below:

$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node host1

2) To stop the scan listener:

$ srvctl stop scan_listener

3) To start the scan listener

$ srvctl start scan_listener

1) Verify Cluster services / CRS status
   ( for single node)

# ./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

for all nodes)

# crsctl check cluster -all
**************************************************************
ekrac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

2) To stop Cluster services / CRS (single node)

./crsctl stop crs


No comments:

Post a Comment