Upgrading Oracle 9.2.0.6 to 10.2.0.3 on AIX 5.2

Here are my notes (10gR2_upgrade.txt) on upgrading from Oracle 9.2.0.6 to 10.2.0.3 on AIX 5.2, including checking the prerequisites, installing the RDBMS software, gathering the statistics for the cost-based optimizer, upgrading the databases, building the make files, and recompiling the programs. This is only the RDBMS upgrade for AIX. It does not include the RDBMS upgrade for Windows or the Application Server upgrade, which we haven't done yet; although, there are some notes and downloads relating to those that are included in these notes.

Also here is a modified version of Scott Harden's runStats.ksh to collect the statistics on all of the tables, which you will need to change to meet your institution's needs, including the variables emailList, listOfTables, listOfHistograms, scrDir, logDir, and oraver (see Summit 2008 session 133: Banner Performance on Oracle 10g; http://www.cmcgc.com/media/handouts/280413/0133.pdf).

As always, make sure you know what you are doing with these notes and scripts, make changes to them as appropriate for your site, and use them at your own risk!

A BIG THANKS to all of you on the SunGardHE BORACLE listserv that contributed your expertise, thoughts, and notes on your own 10gR2 upgrades, especially Scott Harden and the rest of the University of Illinois team, Dave Midgett, Brandon Cole, Alison O'Connor, Bob Rahe, and others that made for a successful conversion here at our site.

Copyright © 2009 by Maristream.   All information, scripts, forms, and other material
on this web site are freely available to all Banner and Oracle Database Administrators,
Systems Administrators, Programmers, and others that may need it.

The webmaster who maintains this web site may be reached at srea@maristream.org. Visit our other web sites:

Disclaimer:  As with all software, especially where it affects your vital data, make sure that you examine theses scripts and that you understand what they do before you use them to see if they would have any adverse effect on your particular setup or database layout.  Make a full backup of your database in case you have to revert to your original copy of the database before the scripts were run.  Use these scripts at your own risk.  As a condition of using these scripts, you agree to hold harmless both Maristream and Stephen Rea for any problems that they may cause or other situations that may arise from their use, and that neither Maristream nor I will be held liable for those consequences.