Oracle Clusterware is the Clusterware technology from oracle to Manage the Oracle RAC database on various platforms. Oracle has provided cluster utilities to manage it. Here are some of the useful oracle Cluster commands(oracle RAC commands) in 10g,11g, and 12c
CRSCTL command
Cluster Control utility performs the various administrative operations of Oracle Clusterware. It is located in $ORA_CRS_HOME/bin and must be executed by the “root” user.
- Starting and stopping Oracle Clusterware resources
- Enabling and disabling Oracle Clusterware daemons
- Checking the health of the cluster
- Managing resources that represent third-party applications
- Integrating Intelligent Platform Management Interface (IPMI) with Oracle Clusterware to provide failure isolation support and to ensure cluster integrity
- Debugging Oracle Clusterware components
a. To check the current state of all oracle Clusterware daemon:
[root@PROD1 bin]# ./crsctl check crs CSS appears healthy CRS appears healthy EVM appears healthy
b.You can also check the state of individual oracle Clusterware daemon:
[root@PROD1 bin]# ./crsctl check cssd CSS appears healthy [root@PROD1 bin]# ./crsctl check crsd CRS appears healthy [root@PROD1 bin]# ./crsctl check evmd EVM appears healthy
c. To start oracle Clusterware
[root@PROD1 bin]# ./crsctl start crs Attempting to start CRS stack The CRS stack will be started shortly
d. To stop Oracle Clusterware
[root@PROD1 bin]# ./crsctl stop crs Stopping resources. Successfully stopped CRS resources Stopping CSSD. Shutting down CSS daemon. Shutdown request successfully issued.
e. To disable oracle Clusterware:
[root@PROD1 bin]# ./crsctl disable crs
f. To enable oracle Clusterware:
[root@PROD1 bin]# ./crsctl enable crs
g. To get the current value of CSS parameter
[root@PROD1 bin]# ./crsctl get css
for example: to get the value of miscount parameter
[root@PROD1 bin]# ./crsctl get css misscount 60
h. To set a new value of CSS parameter
[root@PROD1 bin]# ./crsctl set css
for example: to set the value of miscount parameter
[root@PROD1 bin]# ./crsctl set css misscount 120 Configuration parameter misscount is now set to 120.
i. To unset CSS parameter value
[root@PROD1 bin]# ./crsctl unset css
for example: to unset value of miscount parameter
[root@PROD1 bin]# ./crsctl unset css misscount Configuration parameter misscount is now undefined.
j. To list the module for debugging in CSS
[root@PROD2 bin]# ./crsctl lsmodules css The following are the CSS modules :: CSSD COMMCRS COMMNS
CRS_STAT command
It reports the current state of resources configured in the OCR.
[oracle@rac1 bin]$ ./crs_stat -t Name Type Target State Host ———————————————————————————– ora….C1.inst application ONLINE ONLINE PROD1 ora….C2.inst application ONLINE ONLINE PROD2 ora….AC1.srv application ONLINE ONLINE PROD1 ora.RAC.abc.cs application ONLINE ONLINE PROD1 ora.RAC.db application ONLINE ONLINE PROD2 ora….AC1.srv application ONLINE ONLINE PROD1 ora….ice2.cs application ONLINE ONLINE PROD1 ora….AC1.srv application ONLINE ONLINE PROD1
OCRDUMP command
It dumps the contents of OCR into a text file.
[root@PROD1 bin]# ./ocrdump /home/oracle/ocr.dmp
OCRCHECK command
It verifies the integrity of the OCR.
[root@PROD2 bin]# ./ocrcheck Status of Oracle Cluster Registry is as follows : Version : 2 Total space (kbytes) : 5237072 Used space (kbytes) : 9360 Available space (kbytes) : 5227712 ID : 794527192 Device/File Name : /u01/oracle/oradata/ocr Device/File integrity check succeeded Cluster registry integrity check succeeded
OCRCONFIG command
It performs various administrative operations on the OCR.
To know more about ocrconfig use click here: OCRCONFIG
ocrconfig -showbackup
ocrconfig -manualbackup
oifcfg command
$ORA_CRS_HOME/bin/oifcfg getif
eth0 10.2.13.0 global public
eth1 192.13.1.0 global cluster_interconnect
Oifcfg Usage:
oifcfg iflist
oifcfg setif {-node <nodename> | -global} {<if_name>/<subnet>:<if_type>}...
oifcfg getif [-node <nodename> | -global] [ -if <if_name>[/<subnet>] [-type <if_type>] ]
oifcfg delif [-node <nodename> | -global] [<if_name>[/<subnet>]]
oifcfg [-help]
<nodename> – the name of the host, as known to a communications network
<if_name> – the name by which the interface is configured in the system
<subnet> – subnet address of the interface
<if_type> – type of the interface { cluster_interconnect | public | storage }
These commands are used to change the VIP, private network configuration in the cluster
Cluvfy command
It is Cluster Verification Utility
cluvfy commands
cluvfy [-help] or cluvfy -h
cluvfy stage {-pre|-post} stage_name stage_specific_options [-verbose]
cluvfy stage -post hwos -n node_list [-verbose]
./runcluvfy.sh stage -post hwos -n node1,node2 -verbose
cluvfy stage -pre cfs -n node_list [-verbose]
cluvfy stage -post cfs -n node_list [-verbose]
cluvfy stage -pre crsinst -n node_list [-c ocr_location] [-r {10gR1|10gR2|11gR1|11gR2}] [-q voting_disk] [-osdba osdba_group]
[-orainv orainventory_group] [-verbose]
cluvfy stage -pre crsinst -n node1,node2,node3
./runcluvfy.sh stage -pre crsinst -n all -verbose
cluvfy stage -post crsinst -n node_list [-verbose]
cluvfy stage -pre dbinst -n node_list [-r {10gR1|10gR2|11gR1|11gR2}] [-osdba osdba_group] [-orainv orainventory_group] [-verbose]
cluvfy stage -pre dbcfg -n node_list -d oracle_home [-verbose]
srvctl
This can be used to start Oracle ASM, database instance, SCAN, VIP
srvctl start nodeapps -n node1 srvctl start asm -n node1 srvctl start instance -d PRODDB -i "PRODDB1" srvctl start nodeapps -n node2 srvctl start asm -n node2 srvctl start instance -d PRODDB -i "PRODDB2" srvctl config database -d TESTDB srvctl status scan srvctl status scan_listener srvctl config scan
oclumon (Cluster Health Monitor)
oclumon -help oclumon version oclumon debug version oclumon debug [log daemon module:log_level] [version] oclumon debug [log all/osysmond/ologgerd/client debuglevel] [0-3] oclumon debug log osysmond CRFMOND:3 oclumon debug log ologgerd CRFLOGD:2 oclumon debug log client allcomp:1 oclumon debug log all allcomp:0
OLSNODES
The olsnodes command provides the list of nodes and other information for all nodes participating in the cluster
olsnodes [[-n] [-i] [-s] [-t] [node_name | -l [-p]] | [-c]] [-g] [-v]
List the names of the PROD in the cluster
[root@PROD1]# olsnodes
PROD1
PROD2
PROD3
PROD4
List the VIP addresses for all nodes currently in the cluster
[root@PROD1]# olsnodes -i
PROD1 195.92.1.1
PROD2 195.192.2.1
PROD3 195.192.3.1
PROD4 195.192.4.1
List the node names and node numbers for cluster members(how to check how many nodes in oracle rac)
[root@PROD1]# olsnodes -n
PROD1 1
PROD2 2
PROD3 3
PROD4 4
12c New Features
The What-if command (eval, predict) is the 12c Clusterware new feature. This feature is used to determine the impact of cluster operations without actually executing these commands. Administrators can use these commands to analyze and determine the impact of a certain operation before actually executing the operation and minimizes the potential risk.
./crsctl eval delete server <server name> srvctl predict diskgroup -diskgroup FRA -verbose
Hope like this post on Oracle cluster command (Oracle RAC commands)
Related articles
Oracle documentation on crsctl
Oracle Flex Cluster 12c
How to Recreate Central Inventory in Real Applications Clusters
What is Oracle Clusterware
How to add any node to Oracle RAC cluster in 10g and 11g
why-database-not-startup-automatic in 11gR2 cluster
SCAN information
interconnect setup in RAC
srvctl commands