{"id":465,"date":"2024-08-04T17:55:16","date_gmt":"2024-08-04T17:55:16","guid":{"rendered":"https:\/\/humtechno.com\/intro\/?p=465"},"modified":"2024-08-04T17:57:48","modified_gmt":"2024-08-04T17:57:48","slug":"oracle-clusterware-useful-commands","status":"publish","type":"post","link":"https:\/\/humtechno.com\/intro\/2024\/08\/04\/oracle-clusterware-useful-commands\/","title":{"rendered":"Oracle Clusterware Useful Commands"},"content":{"rendered":"\n\n\n\n<p>Oracle Clusterware is a software suite that provides infrastructure for Oracle Real Application Clusters (RAC) to enable high availability and scalability. It manages cluster resources such as databases and applications, ensuring they run smoothly across multiple servers. Clusterware monitors the health of these resources and automatically handles failures to minimize downtime.<\/p>\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Advance Oracle 19c Rac Administration - Introduction | oracle technical training\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/jvWT3U1Csv0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n<p><strong>Check Cluster Services<br><\/strong>crsctl check cluster<br>crsctl check crs<br>crsctl check has<\/p>\n\n<p><strong>Check status CRS Nodes<br><\/strong>olsnodes<br>olsnodes -n<\/p>\n\n<p><strong>Check Private Interconnect of connected Node<br><\/strong>olsnodes -l -p<\/p>\n\n<p><strong>Check Virtual IP of Nodes<br><\/strong>olsnodes -i<br>olsnodes -i node1<\/p>\n\n<p><strong>Check Status of Nodes<br><\/strong>olsnodes -s<\/p>\n\n<p><strong>Check Clusterware Name<br><\/strong>olsnodes -c<\/p>\n\n<p><strong>Check global public and global cluster_interconnect :<br><\/strong>oifcfg getif<\/p>\n\n<p><strong>Start Cluster All Service<br><\/strong>su &#8211; root<br>cd $GRID_HOME\/bin<br>crsctl start crs<\/p>\n\n<p><strong>Check CRS Version<br><\/strong>crsctl query crs softwareversion<\/p>\n\n<p><strong>Oracle Clusterware active version<br><\/strong>crsctl query crs activeversion<\/p>\n\n<p><strong>Enable Cluster for Autostart<br><\/strong>crsctl enable crs<\/p>\n\n<p><strong>Disable Cluster for Autostart<br><\/strong>crsctl disable crs<\/p>\n\n<p><strong>Stop Cluster All Service<br><\/strong>su &#8211; root<br>cd $GRID_HOME\/bin<br>crsctl stop crs<\/p>\n\n<p><strong>Stop Cluster All Service on All Available Node2<br><\/strong>crsctl stop cluster -all<\/p>\n\n<p><strong>Start Cluster All Service on All Available Node2<br><\/strong>crsctl start cluster -all<\/p>\n\n<p><strong>Check Status of Cluster Resources<br><\/strong>crsctl status resource -t<br>crsctl stat res -t<br>crs_stat -t<br>crsctl status res -t<\/p>\n\n<p><strong>Stop Cluster Specific Resource<br><\/strong>crsctl start resource<br>crsctl stop resource<\/p>\n\n<p><strong>Check ASM Disk Group Size<br><\/strong>asmcmd lsdg<\/p>\n\n<p><strong>Check ASM Disk Size<br><\/strong>asmcmd lsdsk<\/p>\n\n<p><strong>Check All Configuration of Cluster<br><\/strong>srvctl config all<\/p>\n\n<p><strong>Check Specific Database Configuration<br><\/strong>srvctl config database -d TESTRACDB<\/p>\n\n<p><strong>Check Status of Node<br><\/strong>srvctl status nodeapps<\/p>\n\n<p><strong>Check Current Configuration of Scan<br><\/strong>srvctl config scan<\/p>\n\n<p><strong>Stop Scan Listener<br><\/strong>srvctl stop scan_listener<\/p>\n\n<p><strong>Start Scan Listener<br><\/strong>srvctl start scan_listener<\/p>\n\n<p><strong>Check Status of Scan<br><\/strong>srvctl status scan<\/p>\n\n<p><strong>Check Status of Scan Listener<br><\/strong>srvctl status scan_listener<\/p>\n\n<p><strong>Health Check of OCR<br><\/strong>ocrcheck<\/p>\n\n<p><strong>Check Backup of OCR<br><\/strong>ocrconfig -showbackup<\/p>\n\n<p><strong>Take Backup of OCR<br><\/strong>ocrconfig -manualbackup<\/p>\n\n<p><strong>Change Backup Location of OCR<br><\/strong>ocrconfig -backuploc \/backups\/ocr<\/p>\n\n<p><strong>Modify SPFILE on Database within Cluster Configuration<br><\/strong>srvctl modify database -d PRIM -spfile +DATA\/PRIM\/spfile<br>srvctl modify database -d PRIM -p +DATA\/PRIM\/spfile<\/p>\n\n<p><strong>Register Database and Instance in Cluster<br><\/strong>srvctl add database -d y100d -o \/optware\/oracle\/11.2.0.4\/db_1<br>srvctl add instance -d  y100d -i y100d1 -n kxxxxsgtu21<\/p>\n\n<p><strong>Check Status Specific Database<br><\/strong>srvctl status database -d<\/p>\n\n<p><strong>Start Specific Database<br><\/strong>srvctl start database -d<\/p>\n\n<p><strong>Stop Specific Database<br><\/strong>srvctl stop database -d<\/p>\n\n<p><strong>Check Status Specific Database Instance on Particular Node<br><\/strong>srvctl status instance -d -i<\/p>\n\n<p><strong>Start Specific Database Instance on Particular Node<br><\/strong>srvctl start instance -d -i<\/p>\n\n<p><strong>Stop Specific Database Instance on Particular Node<br><\/strong>srvctl stop instance -d -i<\/p>\n\n<p><strong>Stop Listener on Specific Node<br><\/strong>srvctl stop listener -n racnode1<\/p>\n\n<p><strong>Start Listener on Specific Node<br><\/strong>srvctl stop listener -n racnode1<\/p>\n\n<p><strong>Stop ASM on Specific Node<br><\/strong>srvctl stop asm -n racnode1 -f<\/p>\n\n<p><strong>Start ASM on Specific Node<br><\/strong>srvctl stop asm -n racnode2 -f<\/p>\n\n<p><strong>Check Log File<br><\/strong>crsctl query cssd logfile<br>$ORACLE_BASE\/diag\/crs\/crs\/trace\/alert.log<\/p>\n\n<p><strong>Check Alert Log File of ASM<br><\/strong>tail -f $ORACLE_BASE\/diag\/asm\/+asm\/+ASM1\/trace\/alert_+ASM1.log<\/p>\n\n<p><strong>Check Alert Log File of Database<br><\/strong>tail -f $ORACLE_BASE\/diag\/rdbms\/\/\/trace\/alert_.log<\/p>\n\n<p><\/p>\n\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":333,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[3],"tags":[57,58],"class_list":["post-465","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-oracle-clusterware","tag-oracle-clusterware-useful-commands"],"_links":{"self":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/465","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/comments?post=465"}],"version-history":[{"count":3,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/465\/revisions"}],"predecessor-version":[{"id":468,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/465\/revisions\/468"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media\/333"}],"wp:attachment":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media?parent=465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/categories?post=465"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/tags?post=465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}