cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade ECC 6 SR2 - SHADOW_IMPORT_UPG1 needs AGES

Former Member
0 Kudos

I'm doing a sandbox upgrade from 4.72 to ECC 6 SR2 with the most current support packages (ABA/BASIS 12, EA* 7 et al) and 12 languages (Unicode).

I did this upgrade on a different box already (almost same configuration) despite the difference, that I now use Oracle 10 (as opposed to MaxDB earlier).

SHADOW_IMPORT_UPG1 needed ~ 2.5 hours on MaxDB and is now running for > 6 hours on Oracle. The phase is clearly CPU bound, I can see very few I/O but I see the Oracle shadow processes consume all CPU time. The former box was also a 4 way system as this is.

The statistics were updated before the upgrade but neverless, the upgrade is working on the shadow instance where all statistics get updated by/after EU_IMPORTx.

I also see progress in /usr/sap/put/tmp but I'm just wondering, if this runtime is common and expected or if I do have a problem here. I assume, that the last four hours only language dependent data is applied because logfiles in /usr/sap/put/tmp are

SAPKL<LANG>17.TAD

SAPKL<LANG>18.TAD

etc.

I'm running 10.2.0.2 with the latest patches:

soraya:oratad 3% $ORACLE_HOME/OPatch/opatch lsinventory | grep Patch

Invoking OPatch 10.2.0.2.2

Oracle interim Patch Installer version 10.2.0.2.2

OPatch version : 10.2.0.2.2

Oracle Database 10g Release 2 Patch Set 1 10.2.0.2.0

Patch 4952782 : applied on Sun Jun 10 20:09:57 CEST 2007

Patch 5345999 : applied on Sun Jun 10 20:09:15 CEST 2007

Patch 6055783 : applied on Sun Jun 10 20:08:45 CEST 2007

Patch 5618049 : applied on Sun Jun 10 20:08:01 CEST 2007

Patch 5530958 : applied on Sun Jun 10 20:07:32 CEST 2007

Patch 5915774 : applied on Sun Jun 10 20:06:34 CEST 2007

Patch 4883635 : applied on Sun Jun 10 20:06:11 CEST 2007

Patch 5636728 : applied on Sun Jun 10 20:05:39 CEST 2007

Patch 4899479 : applied on Sun Jun 10 20:04:59 CEST 2007

Patch 5635254 : applied on Sun Jun 10 20:04:14 CEST 2007

Patch 5063279 : applied on Sun Jun 10 20:03:26 CEST 2007

Patch 6033289 : applied on Sun Jun 10 20:02:47 CEST 2007

Patch 5984705 : applied on Sun Jun 10 20:01:49 CEST 2007

Patch 5369855 : applied on Sun Jun 10 20:00:19 CEST 2007

Patch 5103126 : applied on Sun Jun 10 19:59:36 CEST 2007

Patch 4638550 : applied on Sun Jun 10 19:58:53 CEST 2007

Patch 4770693 : applied on Sun Jun 10 19:58:03 CEST 2007

Patch 4864648 : applied on Sun Jun 10 19:57:05 CEST 2007

Patch 5253303 : applied on Sun Jun 10 19:56:24 CEST 2007

Patch 5253307 : applied on Sun Jun 10 19:55:16 CEST 2007

OPatch succeeded.

Anyone any experiences in this area, especially with more than 5 languages? This upgrade is not time critical at all, I just wonder...

--

Markus

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Markus,

I made a upgrade from 4.6 to ECC6 but not Unicode.

I can't explain you if your situation is normal for Unicode, but, for a upgrade without Unicode, the times you get from the phases help of the DVD are not real.

There are many phases that the time of the help is marked for a time and the real time is 3 or 4 times upper.

If you see that the server is working all must be correct.

Regards.

markus_doehr2
Active Contributor
0 Kudos

I have done many upgrades of many systems in the past and I was just wondering, if those runtimes are expected for ORACLE since other databases are much faster

--

Markus

Former Member
0 Kudos

Hi Markus,

jeje...yes, it's amazing the runtimes of the upgrade with a Oracle db.....I suppose all is dependent of the database size.

But the times on the help files never are the corrects.

Regards,

Albert

former_member204746
Active Contributor
0 Kudos

In some SAP notes, it recommends to delete database statistics to improve runtimes. I am unsure if this step can be enhanced with such as trick.

markus_doehr2
Active Contributor
0 Kudos

The problem here ist, that those tables have been just created and imported during the former phases (EU_IMPORT*) and now are activated. The original database tables are not touched since that whole process takes place in the shadow instance/schema

--

Markus

markus_doehr2
Active Contributor
0 Kudos

The "size" of that phase is almost identical on each system because

- EU_IMPORT1 - EU_IMPORT7 imports the data into the shadow instance

- SHADOW_IMPORT_UPG1 activates all objects in the shadow instance

the original instance is not touched.

The only difference what I can imagine is the number of languages used during the upgrade because the language itself and the language dependent data from the supportpackages bound to the upgrade must be imported (as far as I understand the concept).

--

Markus

Answers (0)