{"id":155,"date":"2017-08-16T22:53:39","date_gmt":"2017-08-16T22:53:39","guid":{"rendered":"http:\/\/www.mrmarkyoung.com\/oracle\/?p=155"},"modified":"2017-08-16T22:53:39","modified_gmt":"2017-08-16T22:53:39","slug":"everything-rac-cheat-sheet","status":"publish","type":"post","link":"http:\/\/www.mrmarkyoung.com\/oracle\/2017\/08\/16\/everything-rac-cheat-sheet\/","title":{"rendered":"Everything RAC – Cheat Sheet"},"content":{"rendered":"

The is to guide you through the Oracle RAC clustered system
\nCRSCTL Command<\/strong><\/p>\n

Note: -Any command which just needs to query information can be run using oracle user. But anything which alters Oracle Clusterware requires root privileges.<\/p>\n

First set oracle environment to CRS<\/p>\n

Start Oracle Clusterware<\/strong><\/p>\n

UNIX>crsctl start crs<\/pre>\n
Stop Oracle Clusterware<\/strong><\/p>\n
UNIX>crsctl stop crs<\/pre>\n
Enable Oracle Clusterware<\/strong><\/p>\n
UNIX>crsctl enable crs<\/pre>\n
This enables automatic startup of Clusterware daemons<\/p>\n
Disable Oracle Clusterware<\/strong><\/p>\n
UNIX>crsctl disable crs<\/pre>\n
It disables automatic startup of Clusterware daemons. This is useful when you are performing some operations like OS patching and does not want clusterware to start the daemons automatically.<\/p>\n
Checking Voting disk Location<\/strong><\/p>\n
UNIX>crsctl query css votedisk\r\n##  STATE    File Universal Id                File Name Disk group\r\n--  -----    -----------------                --------- ---------\r\n 1. ONLINE   9032f8742b1f4f82bf95c1ef9d433939 (\/dev\/rdsk\/c0d2s0) [DATA]\r\nLocated 1 voting disk(s).<\/pre>\n
Add Voting disk<\/strong><\/p>\n
UNIX>crsctl add css votedisk path<\/pre>\n
Remove Voting disk<\/strong><\/p>\n
UNIX>crsctl delete css votedisk path<\/pre>\n
Check CRS Status<\/strong><\/p>\n
UNIX>crsctl check crs\r\nCRS-4638: Oracle High Availability Services is online\r\nCRS-4537: Cluster Ready Services is online\r\nCRS-4529: Cluster Synchronization Services is online\r\nCRS-4533: Event Manager is online\r\nEvent Manager appears healthy<\/pre>\n
Check daemon status<\/strong><\/p>\n
UNIX>crsctl check cssd\r\nCRS-272: This command remains for backward compatibility only\r\nCluster Synchronization Services is online\r\n \r\nUNIX>crsctl check evmd\r\nCRS-272: This command remains for backward compatibility only\r\nEvent Manager is online<\/pre>\n
Check Clusterware status on all nodes using<\/strong><\/p>\n
UNIX>crsctl check cluster -all\r\n**************************************************************\r\noradbaud02:\r\nCRS-4537: Cluster Ready Services is online\r\nCRS-4529: Cluster Synchronization Services is online\r\nCRS-4533: Event Manager is online\r\n**************************************************************\r\noradbaud03:\r\nCRS-4537: Cluster Ready Services is online\r\nCRS-4529: Cluster Synchronization Services is online\r\nCRS-4533: Event Manager is online\r\n**************************************************************\r\noradbaud04:\r\nCRS-4537: Cluster Ready Services is online\r\nCRS-4529: Cluster Synchronization Services is online\r\nCRS-4533: Event Manager is online\r\n**************************************************************<\/pre>\n
Determine the software version (binary version of the software on a particular cluster node)<\/p>\n
UNIX>crsctl query crs softwareversion\r\nOracle Clusterware version on node [oradbaud03] is [12.1.0.1.0]<\/pre>\n
Checking active version on cluster<\/p>\n
UNIX> crsctl query crs activeversion\r\nOracle Clusterware active version on the cluster is [12.1.0.1.0]<\/pre>\n
As per documentation, multiple versions are used while upgrading. There are other options for CRSCTL too which can be seen using<\/p>\n
UNIX>crsctl\r\nOr\r\nUNIX>crsctl help<\/pre>\n
Check the status of the cluster<\/p>\n
UNIX>crsctl stat res -t<\/pre>\n
or an alias crsstat<\/p>\n
$ crsstat\r\n--------------------------------------------------------------------------------\r\nName           Target  State        Server                   State details\r\n--------------------------------------------------------------------------------\r\nLocal Resources\r\n--------------------------------------------------------------------------------\r\nora.DATA.dg\r\n               ONLINE  ONLINE       oradbaud02               STABLE\r\n               ONLINE  ONLINE       oradbaud03               STABLE\r\n               ONLINE  ONLINE       oradbaud04               STABLE\r\nora.FRA.dg\r\n               ONLINE  ONLINE       oradbaud02               STABLE\r\n               ONLINE  ONLINE       oradbaud03               STABLE\r\n               ONLINE  ONLINE       oradbaud04               STABLE\r\nora.LISTENER.lsnr\r\n               ONLINE  ONLINE       oradbaud02               STABLE\r\n               ONLINE  ONLINE       oradbaud03               STABLE\r\n               ONLINE  ONLINE       oradbaud04               STABLE\r\nora.asm\r\n               ONLINE  ONLINE       oradbaud02               Started,STABLE\r\n               ONLINE  ONLINE       oradbaud03               Started,STABLE\r\n               ONLINE  ONLINE       oradbaud04               Started,STABLE\r\nora.net1.network\r\n               ONLINE  ONLINE       oradbaud02               STABLE\r\n               ONLINE  ONLINE       oradbaud03               STABLE\r\n               ONLINE  ONLINE       oradbaud04               STABLE\r\nora.ons\r\n               ONLINE  ONLINE       oradbaud02               STABLE\r\n               ONLINE  ONLINE       oradbaud03               STABLE\r\n               ONLINE  ONLINE       oradbaud04               STABLE\r\n--------------------------------------------------------------------------------\r\nCluster Resources\r\n--------------------------------------------------------------------------------\r\nora.LISTENER_SCAN1.lsnr\r\n      1        ONLINE  ONLINE       oradbaud04               STABLE\r\nora.LISTENER_SCAN2.lsnr\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.LISTENER_SCAN3.lsnr\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\nora.MGMTLSNR\r\n      1        ONLINE  ONLINE       oradbaud02               169.254.19.185 172.1\r\n                                                             8.64.97 172.18.64.11\r\n                                                             3,STABLE\r\nora.NEWDSSOAD01.DSSOAD011.inst\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\nora.NEWDSSOAD01.DSSOAD012.inst\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.NEWDSSOAD01.DSSOAD013.inst\r\n      1        ONLINE  ONLINE       oradbaud04               STABLE\r\nora.NEWDSSOAD01.db\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.NEWDSSOAQ01.DSSOAQ011.inst\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\nora.NEWDSSOAQ01.DSSOAQ012.inst\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.NEWDSSOAQ01.DSSOAQ013.inst\r\n      1        ONLINE  ONLINE       oradbaud04               STABLE\r\nora.NEWDSSOAQ01.db\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\nora.NEWDSSOAQ02.DSSOAQ021.inst\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\nora.NEWDSSOAQ02.DSSOAQ022.inst\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.NEWDSSOAQ02.DSSOAQ023.inst\r\n      1        ONLINE  ONLINE       oradbaud04               STABLE\r\nora.NEWDSSOAQ02.DSSOAQ2.DSSOAQ021.srv\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\nora.NEWDSSOAQ02.DSSOAQ2.DSSOAQ022.srv\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.NEWDSSOAQ02.DSSOAQ2.DSSOAQ023.srv\r\n      1        ONLINE  ONLINE       oradbaud04               STABLE\r\nora.NEWDSSOAQ02.DSSOAQ2.cs\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\nora.NEWDSSOAQ02.db\r\n      1        ONLINE  ONLINE       oradbaud04               STABLE\r\nora.NEWSOAD01.SOAD011.inst\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\nora.NEWSOAD01.SOAD012.inst\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.NEWSOAD01.SOAD013.inst\r\n      1        ONLINE  ONLINE       oradbaud04               STABLE\r\nora.NEWSOAD01.db\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\nora.NEWSOAD02.SOAD021.inst\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\nora.NEWSOAD02.SOAD022.inst\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.NEWSOAD02.SOAD023.inst\r\n      1        ONLINE  ONLINE       oradbaud04               STABLE\r\nora.NEWSOAD02.db\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.NEWSOAD03.SOAD031.inst\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\nora.NEWSOAD03.SOAD032.inst\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.NEWSOAD03.SOAD033.inst\r\n      1        ONLINE  ONLINE       oradbaud04               STABLE\r\nora.NEWSOAD03.db\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\nora.NEWSOAD04.SOAD041.inst\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\nora.NEWSOAD04.SOAD042.inst\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.NEWSOAD04.SOAD043.inst\r\n      1        ONLINE  ONLINE       oradbaud04               STABLE\r\nora.NEWSOAD04.SOAD4.SOAD041.srv\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\nora.NEWSOAD04.SOAD4.SOAD042.srv\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.NEWSOAD04.SOAD4.SOAD043.srv\r\n      1        ONLINE  ONLINE       oradbaud04               STABLE\r\nora.NEWSOAD04.SOAD4.cs\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\nora.NEWSOAD04.db\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.NEWSOAQ01.SOAQ011.inst\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\nora.NEWSOAQ01.SOAQ012.inst\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.NEWSOAQ01.SOAQ013.inst\r\n      1        ONLINE  ONLINE       oradbaud04               STABLE\r\nora.NEWSOAQ01.db\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.NEWSOAQ02.SOAQ021.inst\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\nora.NEWSOAQ02.SOAQ022.inst\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.NEWSOAQ02.SOAQ023.inst\r\n      1        ONLINE  ONLINE       oradbaud04               STABLE\r\nora.NEWSOAQ02.db\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.cvu\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.mgmtdb\r\n      1        ONLINE  ONLINE       oradbaud02               Open,STABLE\r\nora.oc4j\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.oradbaud02.vip\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\nora.oradbaud03.vip\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.oradbaud04.vip\r\n      1        ONLINE  ONLINE       oradbaud04               STABLE\r\nora.scan1.vip\r\n      1        ONLINE  ONLINE       oradbaud04               STABLE\r\nora.scan2.vip\r\n      1        ONLINE  ONLINE       oradbaud03               STABLE\r\nora.scan3.vip\r\n      1        ONLINE  ONLINE       oradbaud02               STABLE\r\n--------------------------------------------------------------------------------<\/pre>\n
You are looking for anything that is not online, however oc4j may sometimes be offline<\/p>\n
OLSNODES<\/pre>\n
The OLSNODES command provides the list of nodes and other information for all nodes participating in the cluster.<\/p>\n
UNIX>olsnodes\r\noradbaud02\r\noradbaud03\r\noradbaud04\r\n<\/pre>\n
SERVER CONTROL<\/p>\n
SRVCTL is used to manage configuration information. You can use SRVCTL commands to add, remove, start, stop, modify, enable, and disable a number of entities, such as databases, instances, listeners, SCAN listeners, services, grid naming service (GNS), and Oracle ASM.<\/p>\n
Note: You must use the srvctl version relevant to the version of the database. i.e. set the Oracle environment relevant.<\/p>\n
Database<\/strong><\/p>\n
To start or stop all instances in a cluster<\/p>\n
srvctl start database -d  -o\r\nsrvctl stop database -d  -o\r\ne.g.\r\nsrvctl start database -d NEWSOAQ02\r\nsrvctl start database -d NEWDSS03PRD\r\nsrvctl stop database -d NEWDSS03PRD<\/pre>\n
Note: starts listeners if not already running, you can use the -o option to specify startup\/shutdown options<\/p>\n
Instance<\/strong><\/p>\n
srvctl stop instance -d  -i  -o\r\ne.g.\r\nsrvctl stop instance -d NEWSOAQ02 -i DSSOAQ021\r\nor\r\nsrvctl start instance -d NEWSOAQ02 -i DSSOAQ021 -o mount (if you require the database to be mounted, default is open)<\/pre>\n
Status<\/strong><\/p>\n
srvctl status database -d \r\nsrvctl status instance -d  -i ,\r\nsrvctl status service -d      \r\nsrvctl status nodeapps -n \r\nsrvctl status asm -n<\/pre>\n
Nodeapps<\/strong><\/p>\n
Nodeapp Services run on each node of the cluster and will switched over to other nodes through VIP during the failover.<\/p>\n
Nodeapps are standard set of oracle application services which are started automatically for RAC. They include:
\n\u2022 Virtual IPs
\n\u2022 Oracle Net Listener
\n\u2022 Global Service Daemon \u2022 Oracle Notification Services.<\/p>\n
srvctl config nodeapps\r\nNetwork 1 exists\r\nSubnet IPv4: 10.65.0.0\/255.255.240.0\/vnet0, static\r\nSubnet IPv6:\r\nVIP exists: network number 1, hosting node oradbaud02\r\nVIP Name: oradbaud02-vip\r\nVIP IPv4 Address: 10.65.3.65\r\nVIP IPv6 Address:\r\nVIP exists: network number 1, hosting node oradbaud03\r\nVIP Name: oradbaud03-vip\r\nVIP IPv4 Address: 10.65.3.66\r\nVIP IPv6 Address:\r\nVIP exists: network number 1, hosting node oradbaud04\r\nVIP Name: oradbaud04-vip\r\nVIP IPv4 Address: 10.65.3.67\r\nVIP IPv6 Address:\r\nONS exists: Local port 6100, remote port 6200, EM port 2016<\/pre>\n","protected":false},"excerpt":{"rendered":"
The is to guide you through the Oracle RAC clustered system CRSCTL Command Note: -Any command which just needs to query information can be run using oracle user. But anything which alters Oracle Clusterware requires root privileges. First set oracle environment to CRS Start Oracle Clusterware UNIX>crsctl start crs Stop Oracle Clusterware UNIX>crsctl stop crs … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,42],"tags":[44,43],"class_list":["post-155","post","type-post","status-publish","format-standard","hentry","category-oracle-database","category-rac","tag-crs","tag-rac"],"_links":{"self":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/comments?post=155"}],"version-history":[{"count":2,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/155\/revisions"}],"predecessor-version":[{"id":157,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/155\/revisions\/157"}],"wp:attachment":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/media?parent=155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/categories?post=155"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/tags?post=155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}