11g , Upgrading Using the Manual Method : Scripts explained

You use Oracle-supplied pre- and postupgrade scripts to upgrade to Oracle Database 11g. You can find all these scripts in the ORACLE_HOME/rdbms/admin directory. There is a different set of upgrade
scripts you must use, depending on the release number of the database you’re upgrading from. In this example, I’m upgrading from an Oracle Database 10g release database to Oracle Database 11g and would need to use the scripts utlu111i.sql, catupgrd.sql,utilu111s.sql, catuppst.sql, and utlrp.sql to perform the manual upgrade.

Following is a summary of the functions performed by each of the upgrade scripts:

■ utlu111i.sql This script, also known as the Pre-Upgrade Information Tool,gathers information from the database and analyzes it to make sure that it meets all the upgrade requirements, such as whether the database already contains the SYSAUX tablespace or not. As you know, a pre–Oracle Database 10g database doesn’t have a SYSAUX tablespace; therefore, the Pre-Upgrade Information Tool would recommend that you create the SYSAUX tablespace to meet the requirements for the upgrade. The Pre-Upgrade Information Tool will issue warnings about potential upgrade issues such as database version
and compatibility, redo log size, initialization parameters, and tablespace size estimates, and generates warnings if your database doesn’t satisfy the requirements for upgrading to Oracle Database 11g.

■ catupgrd.sql This is the script that performs the actual upgrading of the database to the Oracle Database 11g release and it now supports parallel upgrades of the database.

■ utlu111s.sql This is the Upgrade Status Utility script which lets you check the status of the upgrade—that is, whether the upgraded database’s components have a valid status.

■ catuppst.sql This is the script you run to perform post-upgrade actions. This is new in Oracle Database 11g Release 1.
■ utlrp.sql This script recompiles and revalidates any remaining application objects.