cancel
Showing results for 
Search instead for 
Did you mean: 

ORACLE Database upgrade

Former Member
0 Kudos

Dear all,

Our organization is planning to upgrade sap database

Our current database version is Oracle 10.2.0.2 & we are planning to upgrade it to ORACLE 11g

Activity will start in next month till the time i need to study whole procedure

please suggest your ideas about how to do it.

Thanks in advance.

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Addition to above replies - First you have to plan your DB patching before going with version upgrade.

Download the latest upgrade guide for more information on this.

If you are upgrading from Oracle 10.2 to Oracle Database 11g Release 2 (11.2) in manual modeu02C6F¼^ÓÞ
If the source database runs Oracle 10.2.0.2, you need to first update the source database to at least patch set 10.2.0.4 or 10.2.0.5. You can then perform the upgrade from 10.2.0.4 or 10.2.0.5 to 11.2.0.2, as described in this guide.

Regards,

Nick Loy

Former Member
0 Kudos

Hi,

Please follow the upgrade guide given the support portal based on your database.

https://websmp208.sap-ag.de/support

Guide will be available in Release & Upgrade info -> Installation and Upgrade guides -> Select Database upgrade in the left pane

Regards

D.Mukunthan

Former Member
0 Kudos

plan an upgrade to 10.2.0.4 (or 10.2.0.5) before.

The upgrade to 11 is pretty simple, the important task is the preupgrade_status.sql and check all the warnings

former_member188883
Active Contributor
0 Kudos

Hi Amol,

In addition to the SAP notes mentioned, download Oracle upgrade guide from SAP service market place and go through the same.

It will help you planning your upgrade optimally.

Hope this is useful.

Regards,

Deepak Kori

nicholas_chang
Active Contributor
0 Kudos

Hi Amol,

Download oracle upgrade guide from oracle site.

Important notes for oracle 11g:

Note 1431800 - Oracle 11.2.0: Central Technical Note

Note 1431793 - Oracle 11.2.0: Upgrade Scripts

Note 1431797 - Oracle 11.2.0: Troubleshooting the Database Upgrade

Note 1431798 - Oracle 11.2.0: Database Parameter Settings

Note 1430669 - BR*Tools support for Oracle 11g

Note 1431794 - Oracle 11.2.0: Instant Client

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.

Hope it helps.

Cheers,

Nicholas Chang