you are a new oracle dba .you were asked to find out which versions of 10.2.0 can be upgraded to 11.2.0.Below information helps and you will also require a oracle metalink id to access any document ids mentioned below.
10.2.0.x.0 TO 11.2.0.2.0
1. Install 11.2.0.2.0 rdbms software
11.2.0.2 patch set is a full release. There is no need to install 11.2.0.1 software
The software can be downloaded from My Oracle support: patch 10098816
https://updates.oracle.com/download/10098816.html
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.2 client version
To install 11.2.0.2, you must download both p10098816_112020_<platform>_1of7.zip
and p10098816_112020_<platform>_2of7.zip
<platform> = your platform( ie for linux x86, download p10098816_112020_LINUX_1of7.zip and
p10098816_112020_LINUX_2of7.zip )
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
The minimum version required to upgrade to 11.2.0.X.X is 10.2.0.2
if your database version is 10.2.0.1 then
install 10.2.0.4 patch set ( patch 6810189)
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
Steps to Upgrade to 10.2.0.4.0 (Click here)
2. Upgrade the database to 11.2.0.2.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 837570.1 : Complete Checklist for Manual Upgrades to 11gR2
Note 870814.1 : Complete checklist to upgrade the database to 11gR2 using DBUA
REFERENCE:
Availability and Known issues for 11.2.0.2 Note:1179474.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.2 Patchset Note 1201253.1
