Stopping/Starting RAC instances for a rolling patch

You’ve done a rolling patch for a RAC test environment right?  And some of you have multiple instances running on the same node for testing, development, training, whatever… it can be a pain taking all those instances up and down.

Patching has come a long way with Oracle and the rolling patch is a beautiful thing compared to what it used to be, however, it’s still a pain to take down each instance on a particular node especially when you have more than a few when doing a rolling patch.

So… I’ve created a customizable script for doing just that.  It will take down the instances you want on each node and restart them before moving on to the next node.  This script was built with our PSoft environment in mind.