Upgrade ECC 6 SR2 - SHADOW_IMPORT_UPG1 needs AGES

[Former Member]

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

[Former Member · Accepted solution]

Hi Markus,

1. Have you paid attention to SAP note 830576 ? Especially values for event...

2. Consider SAP note 558197. It deals with a script that you must ideally execute before the upgrade: dba_ind_columns.sql. I performed upgrades to ECC 6 with execution of this script, and the SHADOW_IMPORT_UPG1 took less than 2 hours.

3. If none of these notes helps, look at the consuming Oracle statement and go to Oracle Metalink.

Hope this helps...

Christophe

[markus_doehr2 · Accepted solution]

Thanx very much for those hints.

The additional events and the "dba_ind_columns_sap.sql" made my day

--

Markus