Oracle Upgrade from 10.2.0.2 to 11.2.0.3

[Former Member]

Dear Supports,

Any one share your experience oracle upgrade 10.2.0.2 to 11.2.0.3.

Step by step..where we need to start in SAP Server.

for pre-requisite, upgrade and post upgrade activities.

Known issues etc...

Please dont say read upgrade guide from service markplace.

Regards,

Vasu

[Former Member · Accepted solution]

Hi Vasan,

I have listed some basic steps to be followed. Still you need to go through the upgrade guide for sure.

This is just a overall idea about the upgrade plan.

Basic steps:

1) Check H/W and S/W requirement

2) download the oracle11g media

3) install oracle 11g sofware

4) patch to latest SBP/ opatch

5) upgrade oracle instance client to 11g

6) run pre-upgrade script

7) perform upgrade

😎 system verification and post upgrade steps.

Regards,

Raja. G

[Former Member]

HI

Please find attached the document in step by step. pls rename the file with ext .docx

Kindly request you to close thread by stating as answered.

BR,

Prabhakar

OracleUpgrade11203.txt.zip

[Former Member]

Dear Prabhakar,

Great Help.

Thank you.. I will start Upgrade.

My operation system is Windows.

Once completed my activities..i will give full points

Regards,

Vasan

[Reagan]

Any one share your experience oracle upgrade 10.2.0.2 to 11.2.0.3.
Step by step..where we need to start in SAP Server.

As there is no indication about the OS I cannot give you the exact details.

Most of the steps are present in the Oracle upgrade guide from SAP.

There are pre-requisites for 11G installation.

Make sure the OS supports 11G installation.

There are hardware and software requirements like patches, libraries pre-installed.

Installation of the Oracle 11G is an online activity.

You install Oracle 11G on a new file system named as /oracle/SID/11203

There are pre-upgrade steps - Refer to the upgrade guide.

Regards

RB

[karthikeyan_natarajan4]

Hi Vasan,

Please go through this thread closely, you find all the steps in general and download the upgrade document from SAP service marketplace.

http://scn.sap.com/message/14442439

good luck,

kartik

[Former Member]

Hi Vasan,

Make sure you set the environmental variables properly once you finish the DB upgrade.

I have faced issue while trying to start the SAP application.

Further go through the upgrade guide thoroughly as below ::

For UNIX:

Database Upgrade Guide Upgrade to Oracle Database 11g Release 2 (11.2): UNIX For Oracle Patch Set Re...

For Windows:

Database Upgrade Guide Upgrade to Oracle Database 11 Release 2 (11.2): Windows Based on Oracle Patch...

Regards

Ram

[former_member188883]

Hi Vasan,

The only best information is the upgrade guide on SAP service marketplace.

It has all the information you need.

Don't bother for any other document.

Regards,

Deepak Kori

[Former Member]

Dear Deepak,

Your answer is right. Without reading SAP guide we can't any SAP activities.

But am asking oracle upgrade steps, known issues, tips from Experts.

Please avoid to show the direction or link.