Oracle upgrade from 9i

[Former Member]

Dear all,

Currently we are using SAP R/3 4.7 on HP-UX with RDBMS oracle 9i. As we know, oracle 9i is out of support so now we want to upgarde it. Can u suggest me some questions relarted to this...

1. How much down time it will require for successfull upgardation from 9i to 10g or 11g?

2. We should go for 10g or 11g?

3. Will the oracle software chargeable from SAP service marketplace site as we already have license for R/3 and oracle 9i from SAP?

Thanks in advance.

Regards,

Ankit Gupta

[stefan_koehler · Accepted solution]

Hello Ankit,

> 1. How much down time it will require for successfull upgardation from 9i to 10g or 11g?

It will depend on problems, your skill and the hardware. In normal i would suggest to estimate round about 2 hours, if you have already prepared some things.

> 2. We should go for 10g or 11g?

You could only go for Oracle 10gR2. Oracle 11g is not supported yet and as far as i know from the oracle development update - the first release that will be supported will be Oracle 11gR2.

> 3. Will the oracle software chargeable from SAP service marketplace site as we already have license for R/3 and oracle 9i from SAP?

Yes

Please also check the PAM, if your kernel supports Oracle 10g.

Regards

Stefan

[Former Member · Accepted solution]

Hi

Recently we have done an upgrade from Oracle 9i R2 to Oracle 10g rel2 ( patch 10.2.04 )

Answering to your questions :

1. For the planning , please perform the same in the Sandboxes first. The process will be that you bring down SAP, perfrm a database upgrade , and then bring SAP up again.

For the DB upgrade , please go though the documented process and have all the requirements ready before doing the same in the Production System as it involves lots of Unix intervention.

In the sandbox , it took us a lot of time , however the expertise developed helped us in doing the Production upgrade in about 2-3 hours.

2. No , please upgrade to 10gr2 only now. it is well supported by Oracle and SAP

3. There will no extra charge for upgrading to oracle 10gr2 if you are having Licensed Oracle 9i software. U can get the CD's through Metalink SR .

Let me know if u need more information

Rishi

[Former Member · Accepted solution]

hi all,

what are the advantages of upgrading oracle 9i to 10 g in From SAP Perspective ?

can anybody suggest the steps involved in the same?

[Former Member · Accepted solution]

hello,

You can find adventages of Oracle 10G in Note 828268..

Regards

Anju

[Former Member]

1. How much down time it will require for successfull upgardation from 9i to 10g or 11g?

Downtime mainly depends upon on the many constraints like server performance, database condition, your knowledge on oracle. It has2 steps

1. Pre upgrade procedures

2. Database upgrade

3. Post upgrade procedures

In pre upgrade procedures,we will be executing some SQL scripts and store thes results. Once the upgrade is completed, in the post upgrade procedures we will execute the same SQL scripts and compare both the results.

2. We should go for 10g or 11g?

SAP Recommends to user Oracel 10G Release 2, there no SAP release available for Oracle 11G.

3. Will the oracle software chargeable from SAP service marketplace site as we already have license for R/3 and oracle 9i from SAP?

I dont think so, can check with account manager.

Hope it helps

Regards

KT

[Former Member]

This message was moderated.

[former_member204746]

you are not allowed to post your email address here.

upgrade document is available on the Oracle 10g upgrade disk. I beleive it is called README.HTML

[Former Member]

Thanks to u all & sorry for voilation rules of forum.

Plz send me the path where i can download the oracle 10g upgrade disks.

Ankit Gupta

[former_member204746]

service.sap.com/installations

Entry by Application Group

SAP NetWeaver

SAP NETWEAVER

SAP NETWEAVER 7.0

Installation and Upgrade

<choose your OS>

ORACLE

check in bottom section.

for Oracle on Windows, you need:

ORACLE RDBMS 10.2 Windows 1 of 5

ORACLE RDBMS 10.2 Windows 2 of 5

ORACLE RDBMS 10.2 Windows 3 of 5

ORACLE RDBMS 10.2 Windows 4 of 5

ORACLE RDBMS 10.2 Windows 5 of 5

you will also need Oracle patches from http://service.sap.com/swcenter-3pmain