DBA Hub

📋Steps in this guide1/13

Useful CRSCTL commands - DBACLASS DBACLASS

CRSCTL Utility is used to managed oracle clusterware resources and components. 1. STOP & START CRS: ( run from root user) $GRID_HOME/bin/crsctl stop crs $GRID_HOME/bin/crsctl start crs 2. Enable/Disable auto restart of CRS. $GRID_HOME/bin/crsctl disable crs $GRID_HOME/bin/crsctl enable crs 3. Find the cluster name $GRID_HOME/bin/cemutlo -n or $GRID_HOME/bin/olsnodes -c 4. Find grid version: SYNATX

oracle clusteringintermediate
by OracleDba
12 views
1

Overview

CRSCTL Utility is used to managed oracle clusterware resources and components. 1. STOP & START CRS: ( run from root user) 2. Enable/Disable auto restart of CRS.

Code/Command (click line numbers to comment):

1
2
3
$GRID_HOME/bin/crsctl stop crs

$GRID_HOME/bin/crsctl start crs
2

Section 2

3. Find the cluster name 4. Find grid version:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
$GRID_HOME/bin/crsctl disable crs

$GRID_HOME/bin/crsctl enable crs

$GRID_HOME/bin/cemutlo -n

or 

$GRID_HOME/bin/olsnodes -c
3

Section 3

SYNATX – $GRID_HOME/bin/crsctl query crs softwareversion <hostname) 5. check cluster component status 6. Find voting disk location

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
$GRID_HOME/bin/crsctl query crs softwareversion host-dbaclass1

$GRID_HOME/bin/crsctl stat res -t

$GRID_HOME/bin/crsctl check crs

$GRID_HOME/bin/crsctl check cssd

$GRID_HOME/bin/crsctl check crsd

$GRID_HOME/bin/crsctl check evmd
4

Section 4

7. Find OCR location: 8. Find cluster interconnect details

Code/Command (click line numbers to comment):

1
2
3
$GRID_HOME/bin/crsctl query css votedisk

$GRID_HOME/bin/ocrcheck
5

Section 5

9. Check CRS status of local node 10. Check status of all crs resourcs

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
$GRID_HOME/bin/oifcfg getif

app-ipmp0 172.21.39.128 global public
loypredbib0 172.16.3.192 global cluster_interconnect
loypredbib1 172.16.4.0 global cluster_interconnect



select NAME,IP_ADDRESS from v$cluster_interconnects;

NAME IP_ADDRESS
--------------- ----------------
loypredbib0 172.16.3.193
loypredbib1 172.16.4.1

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
6

Section 6

10. Check active version of cluster 11. Stop and start high availability service ( HAS)

Code/Command (click line numbers to comment):

1
2
3
4
5
$GRID_HOME/bin/crsctl stat res -t
$GRID_HOME/bin/crsctl stat res -t -init

crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [12.1.0.2.0]
7

Section 7

12. Check CRS status of remote nodes 13. Disk timeout from node to voting disk(disktimeout)

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
crsctl stop has

crsctl start has

crsctl check cluster

crsctl check cluster -all
8

Section 8

14. Network latency in the node interconnect (Misscount) 15. Move voting disk to another diskgroup:

Code/Command (click line numbers to comment):

1
2
3
4
5
crsctl get css disktimeout
CRS-4678: Successful get disktimeout 200 for Cluster Synchronization Services.

crsctl get css misscount
CRS-4678: Successful get misscount 30 for Cluster Synchronization Services.
9

Section 9

16. Add another voting disk: 17. Delete voting disk:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
crsctl replace votedisk +OCRVD
Successful addition of voting disk 2e4ded6cee504fc8bf078b080fb7be6f.
Successful addition of voting disk 8e87826024e24fffbf5add65c011fc66.
Successful addition of voting disk e1ba56dedff84fa8bf5605e0302fc81e.
Successful deletion of voting disk 2b7ce864c44d4fecbf60885a188290af.
Successfully replaced voting disk group with +OCRVD.
CRS-4266: Voting file(s) successfully replaced

crsctl add css votedisk
10

Section 10

18 . Get ocr disk backup details 19 . Check whether standard or flex ASM

Code/Command (click line numbers to comment):

1
2
3
crsctl delete css votedisk

ocrconfig -showbackup
11

Section 11

20 . Check CRS configuation 21 . Find cluster configuration information:

Code/Command (click line numbers to comment):

1
2
3
4
5
crsctl get cluster mode status

Cluster is running in "standard" mode

crsctl config crs
12

Section 12

21 . Find node roles in cluster

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
$
crsctl get cluster configuration
Name                : dbaclass-cluster
Configuration       : Cluster
Class               : Standalone Cluster
Type                : flex
The cluster is not extended.
--------------------------------------------------------------------------------
        MEMBER CLUSTER INFORMATION
      Name       Version        GUID                       Deployed Deconfigured

================================================================================
================================================================================

crsctl get node role status -all
Node 'dbhost1' active role is 'hub'
Node 'dbhost1' active role is 'hub'
13

Section 13

22. crsctl has commands for standalone grid infrastrcuture

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
crsctl check has
crsctl config has
crsctl disable has
crsctl enable has
crsctl query has releaseversion
crsctl query has softwareversion
crsctl start has
crsctl stop has

Comments (0)

Please to add comments

No comments yet. Be the first to comment!