This is a guest post by David Clement, a veteran database engineer and a friend of mine. You can find him online at davidclement.org.
A handy feature that I’ve just found out about is that there is a link from Metalink document 884522.1 to the Oracle Pre-Upgrade Utility. You can get the utility without downloading the entire installation set and unpacking it.
For me, the easiest way to use the utility is to invoke the non-XML version from SQL Plus. For example:
SQL> conn sys/<password>@<tns_entry> as sysdba SQL> spool utlu112_prereqs.out SQL> @@utlu112i .... SQL> spool off
The utility checks some interesting things:
If you did unpack the entire installation set, the utility script is in rdbms/admin.