• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

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

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Database » Useful Cluster command in Oracle clusterware 10g , 11g and 12c

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

September 12, 2022 by techgoeasy 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

Table of Contents

  •  CRSCTL command
  • CRS_STAT command
  • OCRDUMP command
  • OCRCHECK command
  • OCRCONFIG command
  • oifcfg command
  • Cluvfy command
  • srvctl
  • oclumon (Cluster Health Monitor)
  • OLSNODES
  • 12c New Features

 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:

[[email protected] 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:

[[email protected] bin]# ./crsctl check cssd

CSS appears healthy

[[email protected] bin]# ./crsctl check crsd

CRS appears healthy

[[email protected] bin]# ./crsctl check evmd
EVM appears healthy

c. To start oracle Clusterware

[[email protected] bin]# ./crsctl start crs
Attempting to start CRS stack
The CRS stack will be started shortly

d. To stop Oracle Clusterware

[[email protected] 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:

[[email protected] bin]# ./crsctl disable crs

f. To enable oracle Clusterware:

[[email protected] bin]# ./crsctl enable crs

g. To get the current value of CSS parameter

[[email protected] bin]# ./crsctl get css

for example: to get the value of miscount parameter

[[email protected] bin]# ./crsctl get css misscount
60

h. To set a new value of CSS parameter

[[email protected] bin]# ./crsctl set css

for example: to set the value of miscount parameter

[[email protected] bin]# ./crsctl set css misscount 120
Configuration parameter misscount is now set to 120.

i. To unset CSS parameter value

[[email protected] bin]# ./crsctl unset css

for example: to unset value of miscount parameter

[[email protected] bin]# ./crsctl unset css misscount
Configuration parameter misscount is now undefined.

j. To list the module for debugging in CSS

[[email protected] 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.

[[email protected] 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.

[[email protected] bin]# ./ocrdump /home/oracle/ocr.dmp

OCRCHECK command

It verifies the integrity of the OCR.

[[email protected] 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

[[email protected]]# olsnodes
PROD1
PROD2
PROD3
PROD4

List the VIP addresses for all nodes currently in the cluster

[[email protected]]# 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)

[[email protected]]# 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

Filed Under: Oracle, Oracle Database Tagged With: Cluster command in 10g and 11g, RAC

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • Password Version in oracle
  • How to login as user without changing the password in Oracle database(alter user identified by values)
  • How to check encrypted tablespace in the Database
  • How To Export -Import TDE Master Encryption Key
  • How to Configure Auto Login TDE Wallet

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us