HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Applying patch oracle 11.2.0.4 on 11.2.0.2

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
applyingoraclepatch

Problem

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?

Solution

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

Code Snippets

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

Context

StackExchange Database Administrators Q#188550, answer score: 2

Revisions (0)

No revisions yet.