{"id":452,"date":"2019-12-09T14:40:30","date_gmt":"2019-12-09T13:40:30","guid":{"rendered":"https:\/\/ilmarkerm.eu\/blog\/?p=452"},"modified":"2019-12-09T14:40:30","modified_gmt":"2019-12-09T13:40:30","slug":"oracle-rac-is-hanging-get-systemstate-and-hanganalyze-from-all-instances","status":"publish","type":"post","link":"https:\/\/ilmarkerm.eu\/blog\/2019\/12\/oracle-rac-is-hanging-get-systemstate-and-hanganalyze-from-all-instances\/","title":{"rendered":"Oracle RAC is hanging? Get systemstate and hanganalyze from all instances."},"content":{"rendered":"<p>So your RAC database hangs\/has occasional stalls\/you want to do an emergency reboot?<br \/>\n<a href=\"https:\/\/blog.dbi-services.com\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/\">Franck Pachot has written a good article what traces to get for troubleshooting or for Oracle support<\/a><\/p>\n<p>I had a problem &#8211; all RAC instances seem to &#8220;stall&#8221; occasionally so I wanted to execute Francks script on all instances at the same time when the problem was happening.<\/p>\n<p>Ansible to the rescue.<\/p>\n<p>First I pushed out the following script to all instances, this script actually does the diagnostics dump.<\/p>\n<p><script src=\"https:\/\/gist.github.com\/ilmarkerm\/87cfafc09b79ae06fc92a6c47e8d4643.js\"><\/script><\/p>\n<p>Then the Ansible playbook to execute the script above on all instances at the same time and afterwards download all traces to your local ansible controller host:<\/p>\n<p><script src=\"https:\/\/gist.github.com\/ilmarkerm\/828fc1ea2d84c3aadf0fe0f095529478.js\"><\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>So your RAC database hangs\/has occasional stalls\/you want to do an emergency reboot? Franck Pachot has written a good article what traces to get for troubleshooting or for Oracle support I had a problem &#8211; all RAC instances seem to &#8220;stall&#8221; occasionally so I wanted to execute Francks script on all instances at the same [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[53,4],"class_list":["post-452","post","type-post","status-publish","format-standard","hentry","category-blog-entry","tag-ansible","tag-oracle"],"_links":{"self":[{"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/posts\/452","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/comments?post=452"}],"version-history":[{"count":6,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/posts\/452\/revisions"}],"predecessor-version":[{"id":458,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/posts\/452\/revisions\/458"}],"wp:attachment":[{"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/media?parent=452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/categories?post=452"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ilmarkerm.eu\/blog\/wp-json\/wp\/v2\/tags?post=452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}