First, thanks a lot for this little gem. It works like a charm!

However, there is a small nitpick with the way you are grepping the oracle sid from the pmon process.

# Get the list of running databases.
SIDS=`ps -e -o args | grep pmon | grep -v grep | awk -F_ ‘{print $3}’ | sort`

If there is a underscore part of the oracle sid as below;

$ ps -e -o args | grep pmon | grep -v grep
ora_pmon_emrep_dr

Then your script will pick only the part of the oracle sid not the full one, which will eventually invalidate all the subsequent steps for that database.

$ ps -e -o args | grep pmon | grep -v grep | awk -F_ ‘{print $3}’ | sort
emrep

So, i replace that line with the below one, which will get the full SID;

$ ps -e -o args | grep pmon | grep -v grep | cut -c 10- | sort
emrep_dr

Thanks,
sathya