Oracle RAC is hanging? Get systemstate and hanganalyze from all instances.
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 – all RAC instances seem to “stall” occasionally so I wanted to execute Francks script on all instances at the same time when the problem was happening.
Ansible to the rescue.
First I pushed out the following script to all instances, this script actually does the diagnostics dump.
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: