EHP4 Installation Error in phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE

[Former Member]

Dear All,

I am in the process of Upgrading our ECC6 EHP3 to EHP4/NW7.01. We are at Oracle 10.2.0.4 and Bundle Patch 44 was also applied before starting the upgrade using SAPEHPi 7 PAtch 84.

We are Windows 2003 x86 64 bit

Now my upgrade stopped in the phase as mentioned above:

phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE

It refers me to file : DBCLONE.ELG file under /usr/sap/EHPI/abap/log

Here is the extract from file:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

CLONING ERRORS and RETURN CODE in DBCLONE01.SE2

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

1EETGCLN ORA-01555: snapshot too old: rollback segment number with name "" too small

1EETGCLN DYNPSOURCE

1EETGCLN

How can resolve this.

Thanks for your help.

Regards,

M

[Former Member · Accepted solution]

Hi,

>> 1EETGCLN ORA-01555: snapshot too old: rollback segment number with name "" too small

It is not a big problem, my friend Check the note "185822 - ora-1555 - cause and action" and the note "3807 - Error messages regarding rollback and undo segments"

Check the items, below;

- The undo tablespace (PSAPUNDO) is large enough.

- You configured automatic undo management on your database. You can find the parameters and the further information regarding to AUM, in the note 830576

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

Thanks for your reply Dear Orkun ,

To resolve the issue I first tried to rerun the phase and I did not see that problem again.

Thanks for your helpful answer though.

Regards,

M

[Former Member · Accepted solution]

Hi DhillonM

Eventhough re run has solved your error.

You may face this error in future also . To avoid this error Oracle has came up with UNDO Tablespace from 9i.

And also for 10g Oracle recommends to use UNDO Tablespace instead of Rollback segments.

Regards,

Vivek S

[Former Member]

Extract from file DBCLONE01.<SID>

5 ETGCLN WSSOAPPROP_DARK done in 1 seconds

3 ETGCLN START WWWFUNC -> WWWFUNC~

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "WWWFUNC~" ("NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 STORAGE (INITIAL 0000000064 K NEXT 0000000064 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'WWWFUNC~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "WWWFUNC^0" ON "WWWFUNC~" ("NAME") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 STORAGE (INITIAL 0000000064 K NEXT 0000000064 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'WWWFUNC~' AND INDEXNAME = '0'

3 ETGCLN insert /*+ APPEND */ into "WWWFUNC~" ( "NAME" ) select "NAME" from "WWWFUNC"

3 ETGCLN Number of original rows: 0. Number of copied rows: 0.

5 ETGCLN WWWFUNC done in 0 seconds

3 ETGCLN START WWWPARAMS -> WWWPARAMS~

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "WWWPARAMS~" ("RELID" VARCHAR2 (000006) DEFAULT ' ' NOT NULL, "OBJID" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "NAME" VARCHAR2 (000150) DEFAULT ' ' NOT NULL, "VALUE" VARCHAR2 (000750) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 STORAGE (INITIAL 0000000760 K NEXT 0000000760 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'WWWPARAMS~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "WWWPARAMS^0" ON "WWWPARAMS~" ("RELID", "OBJID", "NAME") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 STORAGE (INITIAL 0000000776 K NEXT 0000000776 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'WWWPARAMS~' AND INDEXNAME = '0'

3 ETGCLN insert /*+ APPEND */ into "WWWPARAMS~" ( "RELID", "OBJID", "NAME", "VALUE" ) select "RELID", "OBJID", "NAME", "VALUE" from "WWWPARAMS"

3 ETGCLN Number of original rows: 12942. Number of copied rows: 12942.

5 ETGCLN WWWPARAMS done in 1 seconds

3 ETGCLN START YMUS -> YMUS~

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "YMUS~" ("TABNAME" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "VARKEY" VARCHAR2 (000330) DEFAULT ' ' NOT NULL, "DATALN" NUMBER (000005) DEFAULT 0 NOT NULL, "VARDATA" BLOB) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 STORAGE (INITIAL 0000000064 K NEXT 0000000064 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'YMUS~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "YMUS^0" ON "YMUS~" ("TABNAME", "VARKEY") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 STORAGE (INITIAL 0000000064 K NEXT 0000000064 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'YMUS~' AND INDEXNAME = '0'

3 ETGCLN ALTER TABLE "YMUS~" MODIFY LOB ("VARDATA") (CACHE)

3 ETGCLN insert /*+ APPEND */ into "YMUS~" ( "TABNAME", "VARKEY", "DATALN", "VARDATA" ) select "TABNAME", "VARKEY", "DATALN", "VARDATA" from "YMUS"

3 ETGCLN Number of original rows: 0. Number of copied rows: 0.

5 ETGCLN YMUS done in 0 seconds

9 ETGCLN CLONING TABLES FAILED

3 ETGCLN ***********(205158)***********

4 EPU202XEND OF SECTION BEING ANALYZED IN PHASE DBCLONE

[Former Member]

I want to add that I am in Preprocessing in the Upgrade process - Shadow System Installation

Please Guide.

Thanks,

M