Applying patch oracle 11.2.0.4 on 11.2.0.2

oracleoracle-11gupgrade

We are going to apply Oracle patch 11.2.0.4 on Oracle 11.2.0.2. We have 11.2.0.4 patch. We are using (DBUA) for this upgrade. As DBUA will check the preupgrade requisites, we want to run preupgrade check manually.

Could you please help where we can find preupgrade check?
How to run this script?

From which ORACLE_HOME should we run this script, as we have two ORACLE_HOME directories?

Best Answer

Using the Pre-Upgrade Information Tool

Important:

The Pre-Upgrade Information Tool must be copied to and must be run from the environment of the database being upgraded.

...

Run the Pre-Upgrade Information Tool:

SQL> @$11g_ORACLE_HOME/rdbms/admin/utlu112i.sql
Related Question