Awesome notes.
As it turns out I'm working my way through another one of these upgrades.
FYI, I went on a bit of a tear this week and fixed a bunch of oracle upgrade scripts on oacs-5-1 and oacs-5-2 (I'm assuming a future merge from oacs-5-2 to HEAD).
./acs-events/sql/oracle/upgrade/upgrade-0.3d-0.4d.sql
./acs-mail/sql/oracle/upgrade/upgrade-4.6.2-5.0d1.sql
./acs-subsite/sql/oracle/upgrade/upgrade-5.1.2-5.1.3.sql
./categories/sql/oracle/category-synonym-package.sql
./categories/sql/oracle/category-link-package.sql
./rss-support/sql/oracle/upgrade/upgrade-0.3d2-0.3d3.sql
./calendar/sql/oracle/upgrade/upgrade-2.0d1-2.0b2.sql
./file-storage/sql/oracle/upgrade/upgrade-5.1.0a4-5.1.0a5.sql
./file-storage/sql/oracle/upgrade/upgrade-5.1.0a13-5.1.0a14.sql
./forums/sql/oracle/upgrade/upgrade-1.0.6-1.0.7d.sql
./dotlrn/sql/oracle/upgrade/upgrade-1.0-2.0d1.sql