on 02-26-2013 12:02 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Deepak,
Thanks for your response !
I have downloaded the patchset from SMP and below patch I downloaded.
SAP10205P_1302-10010765.ZIP | SAP 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.
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
Hi Sankar,
Can i get the document for Step by step for Oracle 10.2.0.2 to 10.2.0.5
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.