Upgrade solman 7.1 sp12 to solman 7.2 sp03 issue

[former_member241745]

Hello, experts!

During an upgrade i was facing the following issue:

In phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE error is:

ORA-02220: invalid MINEXTENTS storage option value.

And a DDL code for creation of tables like:

CREATE TABLE xxxx~

STORAGE(

INITIAL 0000000000 K NEXT 000000000000 MINEXTENTS 000000000000 MAXEXTENTS 000000000000 PCTINCREASE 00000000 FREELIST 001 FREELIST GROUPS 01)

I looked through notes:

1536104 - ORA-02220: invalid MINEXTENTS storage option value

1570366 - ORA-02220 during transport

and from 1570366 attached script i executed the following sql:

select * from SAPSR3.DDSTORAGE dds

where parname in ('MINEXTENTS','MAXEXTENTS','INITIAL','NEXT') and text = '0' and dbsysabbr = 'ORA'

order by tabname,posnr;

It returned over 500 rows

I executed:

update SAPSR3.DDSTORAGE set text = '1' where parname = 'MINEXTENTS' and text = '0' and dbsysabbr = 'ORA'

update SAPSR3.DDSTORAGE set text = 'UNLIMITED' where parname = 'MAXEXTENTS' and text = '0' and dbsysabbr = 'ORA'

:update SAPSR3.DDSTORAGE set text = '16' where parname = 'INITIAL' and text = '0' and dbsysabbr = 'ORA'

update SAPSR3.DDSTORAGE set text = '64' where parname = 'NEXT' and text = '0' and dbsysabbr = 'ORA'

commit;

And repeated the PHASE, but when the phase was repeating all values of mienxtents,maxextents, next, pctincrease returned to 000000000, and the PHASE failed again.

I use the latest kernel version and the latest version of SUM.

Who know, how to resolve these errors?

Thank you for your answers!

[manish_singh13 · Accepted solution]

Hi Ramil,

Can you please execute below query from SAP Note 1891719 and result matches the condition of note then try the solution

select tabname, prtext from  <SID>."TATAF~" where prtext = 'MINEXTENTS 0000000000' or prtext = 'MAXEXTENTS 0000000000' or prtext='NEXT 0000000000 K' or prtext='STORAGE (INITIAL 0000000000 K');

Thanks,

Manish

[former_member241745 · Accepted solution]

Hello!

select count(*) from sapsr3."TATAF~";

  COUNT(*)

----------

         0

[manish_singh13 · Accepted solution]

Hi Ramil,

As per all other posts and SAP Notes, solutions is to follow SAP Note 1570366 for this error.

1. Set _FIX_CONTROL = '8937971:ON' ( I belive you already set this in your system)

2. Execute Script note1570366_v1_sh.txt (As per your very first post it seems that you executed part of this script and not whole script. Please confirm).

Thanks,

Manish

[former_member241745 · Accepted solution]

Hello, Manish!

I am very grateful for your advice! I executed all sql and sh scripts from attached script from note 1570366, and these actions solved my problem!