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.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
select * from v$version ; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit PL/SQL Release 10.2.0.5.0 - Production CORE 10.2.0.5.0 Production TNS for Linux: Version 10.2.0.5.0 - Production NLSRTL Version 10.2.0.5.0 - Production |
As can be seen, the database is currently on version 10.2.0.5.0.
1 2 3 |
shutdown immediate #reboot |
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

1 |
sh runInstaller -- this command starts the installation process |


















Note: The new oracle_home should be updated in /home/oracle/.bash_profile file.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0 - Production CORE 11.2.0.3.0 Production TNS for Linux: Version 11.2.0.3.0 - Production NLSRTL Version 11.2.0.3.0 - Production |
Automatic Storage Management...
12 March 2019