Upgrading Oracle 10.2.0.5 to 11.2.0.3

Even if an upgrade seems easy from the shown instructions, there are a quite a few factors that the DBA should bear in mind.

Even if an upgrade seems easy from the shown instructions, there are a quite a few factors that the DBA should bear in mind.

The database can be upgraded in several ways, one example is an imp/exp of GoldenGate Dataguard Transportable tablespace.

 

It is highly recommended going through the pdf slides available in https://blogs.oracle.com/upgrade/.

Log on to https://support.oracle.com/ with a username and password (provided by your organization) and download the 11.2.0.3 patch. Upgrade documentation can be found with the patchset. While transitioning to 11G it is possible to move the file system structure to the ASM (Automatic Storage Management) structure type.

As can be seen, the database is currently on version 10.2.0.5.0.

Download and unzip the following files from https://support.oracle.com

p10404530_112030_Linux-x86-64_1of7.zip

p10404530_112030_Linux-x86-64_2of7.zip

p10404530_112030_Linux-x86-64_3of7.zip

p10404530_112030_Linux-x86-64_4of7.zip

p10404530_112030_Linux-x86-64_5of7.zip

p10404530_112030_Linux-x86-64_6of7.zip

p10404530_112030_Linux-x86-64_7of7.zip

 

Upgrading Oracle
Upgrading Oracle

 

Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle
Upgrading Oracle

 

 

Note: The new oracle_home should be updated in /home/oracle/.bash_profile file.