Need to upgrade from 10.2.0.2 to 11.2.0.3

[Former Member]

Dear All,

I want to upgrade our current oracle database (10.2.0.2) to latest (11.2.0.2/3).

I read in upgrade document that first we need to upgrade the DB from 10.2.0.2 to 10.2.0.4 or 10.2.0.5 and applying patches through MOPatch supports from Opatch release 10.2.0.4. Now I want to know the following things:

1) Where to download the 10.2.0.5 patches (I went to the path: https://service.sap.com/swdc > Databases and Database Patches> Oracle> Oracle 10.2 Software (64 bit)> Installation> HP-UX> ORACLE Database> 51040681_2 ORACLE RDBMS Patch 10.2.0.5 HP-UX IA64 64bit)

Is the above file is enough for applying from 10.2.0.2 to 10.2.0.5

2) Is this possible to apply the patches from 10.2.0.2 to 10.2.0.5 through MOPatch (our Opatch release is:10.2.0.2)?

If not, please provide me the ready-reference documents on applying patches through Opatch.

Thanks and Regards

KLNR

[ashish_vikas · Accepted solution]

you can refer for Step by step details :  http://scn.sap.com/thread/3314461

best regards

ashish

[marcosmata]

This is how i did the upgrade from Windows 2003 Oracle 10.2.0.2 to Windows R2 Oracle 11.2.0.3:

1 - Java home     

2 - System Copy SAP

     2.1 - Ejecutar SAPINST

     2.2 - Instalar ORACLE cuando SAPINST lo pida

     2.3 - Aplicar patch oracle a 10.2.0.2

     2.4 - Reiniciar Servidor

     2.5 - Instalacion SAP

     2.6 - Post Installation

3 - Actualizacion a Oracle 10.2.0.5

     3.1 - Instalar RDMBS Oracle 10.2.0.5

     3.1 - Upgrade Base de datos

     3.2 - Bundle patch 10.2.0.5

4 - Actualizacion a Oracle 11.2

     4.1 - Instalar RDMBS Oracle 11.2 en Otro OraHome

     4.2 - Instalar Bundle Patch 11.2.0.3

     4.3 - Upgrade de Base de Datos

     4.4 - Borrar Oracle 10.2

5 - Export de SAP

6 - Actualizar Windows 2003 -> 2008 R2

     6.1 - Formatear Servidor con Windows 2008 R2

     6.2 - System Copy SAP

     6.2.1 - Ejecutar SAPINST

     6.2.2 - Instalar ORACLE cuando SAPINST lo pida

     6.2.3 - Instalar Bundle Patch Oracle 11.2.0.3

     6.2.4 - Instalar Gneric Patches Oracle

     6.2.5 - Instalacion SAP

     6.2.6 - Post Installation

7 - Actualizar Kernel SAP a 7.20

[Reagan]

Hello

You cannot upgrade to 10.2.0.5 using OPatch or MOpatch like suggested above.

You need to follow this.

You need to install the 10.2.0.5 Oracle server software using the RUNINSTALLER and then upgrade the database using DBUA.

Once the database has been patched to 10.2.0.5 you need to download the 11G software and install it to a new file system called /oralce/SID/11203

Then you upgrade the database from 10G to 11G using DBUA

Follow this path for the installation media for 10.2.0.5

http://service.sap.com/swdc

Database and Database Patches (from other vendors) - Oracle - Oracle 10.2 Software (64-bit) - Installation - HP-UX - ORACLE Database

Also you need to download the latest SBP (Bundle Patches) for 10G and apply it using MOpatch

Follow this path for the installation media for 11.2.0.3

http://service.sap.com/swdc

http://service.sap.com/swdcDatabase and Database Patches (from other vendors) - Oracle - Oracle 11.2 Software (64-bit) - Installation - HP-UX - ORACLE Database

Once the DB has been upgraded to 11G you need to download the latest SBP (Bundle Patches) for 10G and apply it using MOpatch

Regards

RB

[karthikeyan_natarajan4]

Hi K,

Yes, you have the correct place to download the 10.2.0.5 patch,

Use Opatch to apply 0.5 patch and then upgrade your database to 11.2..0.1.X and again use Opatch to apply 11.2.0.2 or 11.2.0.3

For detailled information about OPatch see SAP note 839182 and 1631931 Oracle Database Patches for 11.2.0.3 for SAP (all about bundle patches)

regards

kartik

[former_member264034]

Hi,

Please follow the recommendations from the notes below in order to
perform this actions and you should be fine:

  871735 - Current patch set for Oracle 10.2.0
1431752 - Oracle 10.2.0: Patches/Patch Collections for 10.2.0.5

Regards,

Aidan