Support for Oracle 10 during upgrade to ERP 606

[Former Member]

Dears,

I'm approaching an upgrade project where the source release is 47 Ent, based on Basis 640 and Oracle 10204.

The target release should be ERP 606 on (based on Nw 731), so we are going to include during the upgrade the latest EHP available .

But from the PAM I see the EHP 6 is only supported with Oracle 11, and it's not planned to perform the oracle upgrade before the Sap upgrade  (the oracle upgrade to 11203 will be performed AFTER the upgrade, during the Unicode conversion that it's going to follow).

I need to know if it is allowed to use the Oracle 10 with just for the upgrade , whitout to go live whit this RDBMS release

Can I use the Oracle 10204 to perform the Sap upgrade to 606 , or the upgrate tool it's going to halt me during the prepare modules requiring the Oracle 11 upgrade before to ho ahead ?

regards

[former_member189725 · Accepted solution]

As per PAM you cannot go with EHP 6 without Oracle 11g.

Its best if you can write to SAP on this .

For a test run , you can go with Oracle 10.2.0.5 client and check if your plan works. SUM tool might just stop you at the very beginning . If it lets you ,then continue with the upgrade and see if it works.

But its always best to upgrade the Oracle before you upgrade.

Regards

Ratnajit

[Former Member · Accepted solution]

I think the problem is that R/3 4.7 isn't supported on Oracle 11, only oracle 10. I have the same problem with an R/3 to ERP6 upgrade I'll be starting in the next few months. I wasn't planning on going with EHP6, though, and EHP5 is supported on Oracle 10. My plan is therefore to upgrade on Oracle 10 and then to upgrade oracle during the unicode conversion.

I don't see a solution to your problem other than to do the main upgrade to EHP5 on oracle 10, and install EHP6 as a separate step. That would be a lot of extra work, though, I guess? I haven't investigated EHP6 so I don't actually know what's involved. It may be straightforward.

I would be nervous about trying EHP6 and Oracle 10 to see if it works. It may look like it works, but actually result in problems that you don't discover for a while. I wouldn't do this on a productive system unless SAP says it is OK...

[Former Member · Accepted solution]

Thanks for the feedback Steve , please are you sure the EHP5 is suported on Oracle 10 ?

From the PAM I see for it Oracle 11 only.

EHP5 is based on NW 702, and I think it's the matter; this version of netweaver run only over Oracle 11.

Yes, to put separately the EHP6 is anyway a second upgrade you have to do, and in my case it's not possible; I do not have so much time...

I'm opening an Oss message to clarify if in some way it's possible to use the oracle 10 to go to ERP 606.

I was planning to do first the Sap upgrade, starting on Monday for example , in order to leave the system open as much as possible. Then to use the weekend for the Downtime module and then for the export-import for the unicode conversion.

The problem is that the preparartion modules expecially the preprocessing, takes a huge amount of time.

regards

[Former Member · Accepted solution]

Maybe it varies by platform? As I read the PAM for my platform (Solaris/x64) EHP5 is supported on Oracle 10.2.0.2. If I'm misreading it, please put me right! My DEV upgrade is not for a month or so yet, so I've got more time to change my plans than you have, but I'm really hoping not to have to.

I'm almost certainly not going with EHP6 - too new. And if there are DB issues, that pretty much seals it for me!

[Former Member · Accepted solution]

I think I might have just found the source of the confusion. EHP 6 requires the 7.20 EXT kernel, which in turn requires Oracle 11.2. EHP 5 will run on the 7.20 kernel, which will run on Oracle 10.2 or 11.2.

At least, that's how I read the PAM.

[Former Member · Accepted solution]

Many thanks Steve,

I think you are in right.

Please I still have to check if R3 47 Ent 200 can be installed over Oracle 11; in your previous post you says it's not possible.

Please could you indicate me the source of this information ?

regards

[Former Member · Accepted solution]

Again this seems to be a kernel version issue. The 6.40 kernel supports only Oracle 9 and Oracle 10. The 6.40 EXT kernel supports Oracle 10 and Oracle 11. If you're not running the 6.40 kernel, I guess that means you can do a kernel upgrade and an Oracle upgrade, and then do the ERP upgrade straight to EHP6? If you absolutely have to get to EHP 6, and don't have time to do it separately, this seems like the only way to do it.

I'm not clear on the exact differences between the 6.40 and 6.40 EXT kernels, but I think this should be possible. I might just have to research this a bit myself, now, in case people here decide they want EHP6!

[nicholas_chang · Accepted solution]

to add on from what steve Rumsby, 640 is able to upgrade to kernel 640_EXT as kernel 640 no longer support, 640_EXT is still under maintenance support. And yes, minimun kernel  level to run oracle 11g is at least 640_EXT.

From Note 1398634 - Oracle database 11g: Integration in SAP environment

Oracle 11.2 for SAP Kernel 6.40_EX2, 7.x and higher

Oracle Version 11.2 is released for these SAP kernel versions. In these  kernel versions, basically only those SAP product versions that were still at least part of SAP Extended Maintenance in 2010 were released for Oracle 11.2.

Cheers,

Nicholas Chang

[Former Member · Accepted solution]

Thanks for the feedback Nicholas.

I'm going to adapt  my plan accordingly:

-first the unicode conversion, importing the R3 47 Ent UC environment over Oracle 11

-second the upgrade to EHP6

At least in this way if for whatever reason the upgrade gone bad, or too long, we will be able to reopen the source system allowing the businnes of the customer.

regards

[Former Member]

Hi,

If the Original question still needs to be answered, i can confirm that EHP6 requires oracle 11.

I've personally undertaken a EHP upgrade and the installer refuses to work unless oracle 11 is installed.

Regards

James