{"id":301,"date":"2011-08-04T00:00:00","date_gmt":"2011-08-04T00:00:00","guid":{"rendered":"http:\/\/www.scmgalaxy.com\/tutorials\/2011\/08\/04\/oracle-rac-cheat-sheet\/"},"modified":"2019-10-20T04:25:49","modified_gmt":"2019-10-20T04:25:49","slug":"oracle-rac-cheat-sheet","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/oracle-rac-cheat-sheet\/","title":{"rendered":"Oracle RAC Web References & Cheatsheet"},"content":{"rendered":"

\"oracle-rac-cheat-sheet\"<\/h1>\n

Check CRS Status<\/span><\/h1>\n
[root@racnode1 ~]#crsctl check crs<\/pre>\n
<\/a>Check Clusterware Resources<\/h5>\n
[root@racnode1 ~]# crs_stat -t -v<\/pre>\n
<\/a>Stopping the Oracle Clusterware Stack on the Local Server<\/h5>\n
[root@racnode1 ~]# \/u01\/app\/11.2.0\/grid\/bin\/crsctl stop cluster<\/pre>\n
CRS-2673: Attempting to stop 'ora.crsd' on 'racnode1'<\/pre>\n
...<\/pre>\n
...<\/pre>\n
<\/a>Stop Oracle Clusterware stack on all servers in the cluster<\/h5>\n
[root@racnode1 ~]# crsctl stop cluster -all<\/pre>\n
<\/a>Starting the Oracle Clusterware Stack on the Local Server<\/h5>\n
[root@racnode1 ~]# \/u01\/app\/11.2.0\/grid\/bin\/crsctl start cluster<\/pre>\n
CRS-2673: Attempting to start 'ora.crsd' on 'racnode1'<\/pre>\n
...<\/pre>\n
...<\/pre>\n
<\/a>Start Oracle Clusterware stack on all servers in the cluster<\/h5>\n
[root@racnode1 ~]# crsctl start cluster -all<\/pre>\n
<\/a>Check Cluster Nodes<\/h5>\n
[oracle@racnode1 ~]$olsnodes -n<\/pre>\n
<\/a>Confirming Oracle ASM Function for Oracle Clusterware Files<\/h5>\n
If you installed the OCR and voting disk files on Oracle ASM, then use the following command syntax as the Grid Infrastructure installation owner to confirm that your Oracle ASM installation is running:<\/p>\n
[oracle@racnode1 ~]$srvctl status asm -a<\/pre>\n
<\/a>Check Oracle Cluster Registry (OCR)<\/h5>\n
[oracle@racnode1 ~]$ocrcheck<\/pre>\n
<\/a>Check Voting Disk<\/h5>\n
[oracle@racnode1 ~]$crsctl query css votedisk<\/pre>\n
<\/a>Check Status Oracle Enterprise Manager<\/h5>\n
[oracle@racnode1 ~]$emctl status dbconsole<\/pre>\n
<\/a>Start Oracle Enterprise Manager<\/h5>\n
[oracle@racnode1 ~]$emctl start dbconsole<\/pre>\n
<\/a>Stop Oracle Enterprise Manager<\/h5>\n
[oracle@racnode1 ~]$emctl stop dbconsole<\/pre>\n
<\/a>All Oracle Instances – (Database Status)<\/h5>\n
[oracle@racnode1 ~]$ srvctl status database -d racdb<\/pre>\n
<\/a>Single Oracle Instance – (Status of Specific Instance)<\/h5>\n
[oracle@racnode1 ~]$ srvctl status instance -d racdb -i racdb1<\/pre>\n
<\/a>Start\/Stop All Instances with SRVCTL<\/h5>\n
[oracle@racnode1 ~]$ srvctl stop database -d racdb<\/pre>\n
[oracle@racnode1 ~]$ srvctl start database -d racdb<\/pre>\n
<\/a>Node Applications – (Status)<\/h5>\n
[oracle@racnode1 ~]$ srvctl status nodeapps<\/pre>\n
<\/a>Node Applications – (Configuration)<\/h5>\n
[oracle@racnode1 ~]$ srvctl config nodeapps<\/pre>\n
<\/a>List all Configured Databases<\/h5>\n
[oracle@racnode1 ~]$ srvctl config database<\/pre>\n
<\/a>Database – (Configuration)<\/h5>\n
[oracle@racnode1 ~]$ srvctl config database -d racdb -a<\/pre>\n
<\/a>ASM – (Status)<\/h5>\n
[oracle@racnode1 ~]$ srvctl status asm<\/pre>\n
<\/a>ASM – (Configuration)<\/h5>\n
[oracle@racnode1 ~]$srvctl config asm -a<\/pre>\n
<\/a>TNS listener – (Status)<\/h5>\n
[oracle@racnode1 ~]$ srvctl status listener<\/pre>\n
<\/a>SCAN – (Status)<\/h5>\n
[oracle@racnode1 ~]$ srvctl status scan<\/pre>\n
<\/a>SCAN – (Configuration)<\/h5>\n
[oracle@racnode1 ~]$ srvctl config scan<\/pre>\n
<\/a>VIP – (Status of Specific Node)<\/h5>\n
[oracle@racnode1 ~]$ srvctl status vip -n racnode1<\/pre>\n
[oracle@racnode1 ~]$ srvctl status vip -n racnode2<\/pre>\n
<\/a>VIP – (Configuration of Specific Node)<\/h5>\n
[oracle@racnode1 ~]$ srvctl config vip -n racnode1<\/pre>\n
[oracle@racnode1 ~]$ srvctl config vip -n racnode2<\/pre>\n
<\/a>Configuration for Node Applications – (VIP, GSD, ONS, Listener)<\/h5>\n
[oracle@racnode1 ~]$ srvctl config nodeapps -a -g -s -l<\/pre>\n
<\/a>Verifying Clock Synchronization across the Cluster Nodes<\/h5>\n
[oracle@racnode1 ~]$ cluvfy comp clocksync -verbose<\/pre>\n","protected":false},"excerpt":{"rendered":"
Check CRS Status [root@racnode1 ~]#crsctl check crs Check Clusterware Resources [root@racnode1 ~]# crs_stat -t -v Stopping the Oracle Clusterware Stack on the Local Server [root@racnode1 ~]# \/u01\/app\/11.2.0\/grid\/bin\/crsctl stop cluster CRS-2673: Attempting to stop ‘ora.crsd’ on ‘racnode1’ … … Stop Oracle Clusterware stack on all servers in the cluster [root@racnode1 ~]# crsctl stop cluster -all Starting…<\/p>\n","protected":false},"author":1,"featured_media":3882,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_joinchat":[],"footnotes":""},"categories":[2],"tags":[1385,599,2693,2692,2690,2695,2694,2696,2691,2688,2689],"class_list":["post-301","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorised","tag-cheatsheet","tag-oracle","tag-oracle-clusterware","tag-oracle-database","tag-oracle-rac","tag-oracle-rac-guide","tag-oracle-rac-reference","tag-oracle-rac-tutorial","tag-oracle-real-application-clusters","tag-rac","tag-rac-cheatsheet"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/301","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=301"}],"version-history":[{"count":2,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/301\/revisions"}],"predecessor-version":[{"id":7253,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/301\/revisions\/7253"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media\/3882"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}