Oracle upgrade in Solution Manager 10g to 11g

[Former Member]

Dear Expert team ,

Our Solution Manager is running  in Windows 2003  with oracle 10g .

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod

PL/SQL Release 10.2.0.2.0 - Production

CORE    10.2.0.2.0      Production

TNS for 32-bit Windows: Version 10.2.0.2.0 - Production

NLSRTL Version 10.2.0.2.0 - Production

SQL>

Now I want to upgrade my Solution Manager 10 g to 11g .

what oracle component  should I download  and how to upgrade 10.2.0.2.0  to  11.2.0.3.0.

Please suggest.

Regards

Pooja

[ACE-SAP]

Hi

The upgrade is possible as stated in the here under note.

Previous version (v15) of that note was even a bit more clear it is possible but version 10.2.0.4 is preferred.

Direct upgrade from 10.2.0.2 should not be a problem, as it is even possible to have a direct upgrade from 9.2.0.8 to 11.2.0.4.

1431793 - Oracle 11.2.0: Upgrade Scripts

A database < 9.2.0.8 must be upgraded to 9.2.0.8 before it can be upgraded directly to 11.2.0.4.

You should consider jumping directly to 11.2.0.4 that is the latest 11g version and the only one that will have a long term support.

Regards

1431797 - Oracle 11.2.0: Troubleshooting the Database Upgrade

• For a database upgrade from 10.2. to 11.2 the minimum release is 10.2.0.2. This release is not supported any more.

1431797 - Oracle 11.2.0: Troubleshooting the Database Upgrade v15

We strongly recommend a minimum release 10.2.0.4 for the following reasons:

a) All SAP internal database upgrade tests have been performed with

release 10.2.0.4. This upgrade path has been very well tested and

is documented in the SAP Database Upgrade Guide for Oracle Release

11.2.

b) Oracle Database Release 10.2.0.2 is not supported any more.

[Former Member]

Yes Yves,

Upgrade is technically possible from any of the versions, but it was not tested in internal databases hence SAP doesn't recommend/support these type of upgrades. Entire responsibility of issues/bugs should be owned by customer only.

We strongly recommend a minimum release 10.2.0.4 for the following reasons:
a) All SAP internal database upgrade tests have been performed with
release 10.2.0.4. This upgrade path has been very well tested and
is documented in the SAP Database Upgrade Guide for Oracle Release
11.2.

Seems my words are misleading! I just mentioned not possible because it is not recommended.

Regards,

Nick Loy

[former_member188883]

Hi Pooja,

For upgrading to 10.2.0.2 -> 11.2.0.3 , it will be 2 step upgrade

Step1:

Upgrade from 10.2.0.2 -> 10.2.0.5

Step 2:

Upgrade from 10.2.0.5 -> 11.2.0.3

Refer upgrade guide for detailed steps , DVDs required and other pre-requisites.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi,

As far I remember direct upgrade from 10.2.0.2 to11gR2 is not possible, you should bring you database at least up to 10.2.0.4 or 10.2.0.5.

Go through the standard upgrade guide which tells you the minimum requirements and procedure.

Good luck!

Regards,

Nick Loy

[Reagan]

Now I want to upgrade my Solution Manager 10 g to 11g .
what oracle component  should I download  and how to upgrade 10.2.0.2.0  to  11.2.0.3.0.

Download the upgrade guide and read it.

https://websmp208.sap-ag.de/~sapdownload/011000358700000608442010E/win_ora_upgrade.pdf

It has all the information you need.

Regards

RB