Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

Home » Oracle » Oracle Database » Useful Cluster command in Oracle clusterware 10g , 11g and 12c

Useful Cluster command in Oracle clusterware 10g , 11g and 12c

by Leave a Comment

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

Oracle RAC commands

 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

Reader Interactions

Leave a Reply

Your email address will not be published.