cancel
Showing results for 
Search instead for 
Did you mean: 

Step by step for Oracle 10.2.0.2 to 10.2.0.5

Former Member
0 Kudos

Hi Basis Guys,

Currently I am working on Oracle 11G upgrade, for upgrade we need to upgrade current version from 10.2.0.2 to 10.2.0.5. OS is AIX and Db is oracle

I downloaded the guide for AIX with Oracle guide from SMP portal. But I could not find exact steps for upgrade from 10.2.0.2 to 10.2.0.5 That guide explains about only 11G upgrade only.

Can some one explain and share the Step by step procedure? Please help me

Thanks,

Sankar


Accepted Solutions (1)

Accepted Solutions (1)

former_member188883
Active Contributor
0 Kudos

Hi Sankar,

Please download the 10.2.0.5 patch set from SAP service marketplace. Then execute the runInstaller from the patchset folder.  This will update the ORacle version to 10.2.0.5.

Post this you may apply latest SAP bundle patches available for 10.2.0.5

Regards,

Deepak Kori

Former Member
0 Kudos

Hi Deepak,

Thanks for your response !

I have downloaded the patchset from SMP and below patch I downloaded.


SAP10205P_1302-10010765.ZIPSAP Bundle Patch 10.2.0.5.10 - 201302

the same above is enough to change version from 10.2.0.2 to 10.2.0.5 ?

I have downloaded the Mopatch and Opatch also for 10.2.0.5 when shall I run those? I am confused with order and steps ..

As per my understanding the patches needed

SAPBUDLE PATCHES FOR 10.2.0.5 - 1

Mopatch and Opatch to be installed -2

Oracle 11 g Software and client - 3

Br tools with latest version -4

But where I will get the runinstaller from SMP? please check and confirm my order is correct or I missed something here?

Please help me.

Former Member
0 Kudos

Sankar,

Your steps are almost fine

But first you need to upgrade oracle from version 10.2.0.2 to 10.2.0.5  (Stop the sap system and all oracle processes before begining the upgrade and backup the  /oracle/SID/version/bin folder and take a proper database and oracle file system backup

Download the patchset from the below link

service.sap.com/oracle

Oracle - Database - ORACLE  ??-BIT" ORACLE 10.2 ??-BIT ,choose your operating system and download the media for  ORACLE RDBMS Patch 10.2.0.5.

Once you have downloaded this and unzipped the media ,then you will find the runinstaller or setup file and upgrade to 10.2.0.5

After that you can follow the following steps .

SAPBUDLE PATCHES FOR 10.2.0.5 - 1

Mopatch and Opatch to be installed -2

Oracle 11 g Software and client - 3

Br tools with latest version -4

For Opatch and Mopatch go through the notes thoroughly

Note 839182 - Installing patches using OPatch

Note 1027012 - MOPatch - Install Multiple Oracle Patches in One Run

Follow the upgrade guide for oracle 11g from there on.

All the best.

Regards

Amit

former_member188883
Active Contributor
0 Kudos

Hi Sankar,

Once you download the patchset as mentioned by Amit and extract it you may locate the runInstaller in that folder. You need to set DISPLAY environment for orasid user and then excecute ./runInstaller.

Regards,

Deepak Kori

Former Member
0 Kudos

Deepak Thanks for your reply. I have successfully installed 10.2.0.5. Thanks for your support.

Former Member
0 Kudos

Deepak Thanks for your reply. I have successfully installed 10.2.0.5. Thanks for your support.

former_member188883
Active Contributor
0 Kudos

Hi,

Sankar good to know that you were able to install 10.2.0.5.  You may close this thread now.

Regards,

Deepak Kori

Former Member
0 Kudos

Thanks a lot all the Guys input and help on this.

former_member188883
Active Contributor
0 Kudos

Hi Sankar,

You may close the thread.

Regards,

Deepak Kori

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

Hi Sankar,

Can i get the document for Step by step for Oracle 10.2.0.2 to 10.2.0.5

Answers (2)

Answers (2)

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

Thanks for your info.

former_member226354
Discoverer
0 Kudos

Hello Basis experts,

Our ECC Oracle database version is 11.2.0.3.0 and OSS is HP-UX on IA64 64bit. We are going to upgrade our database version with latest patch. We have already searched on SMP to find the required version and found the SAP Bundle Patch 11.2.0.4.8-201511

Actually we want to know, If we upgrade this one(11.2.0.4.8 -201511)component hence any more component need to apply or not.

Regards//

Emran

Former Member
0 Kudos

Hi Sankar,before going to upgrade shutdown database and all services of db.i am giving step by step on windows its similar to aix

1.run setup and install the product

2after finished startup db

3.>startup migrate;

4.run catupgrd.sql