Friday, 21 December 2012

Error in 4.7-EHP6 Upgrade Downtime Phase( MAIN_SWITCH/PARMVNT_XCNV

SQL-error "2220-ORA-02220: invalid MINEXTENTS storage option: When Upgrade

We are doing upgrade from R3 4.7 to ECC EHP6 with SUM tool. We are facing
error during downtime phase(Activating name tabs) MAIN_SWITCH/PARMVNT_XCNV as mentioned below:


3 ETP399
2WETP000 08:53:27: Retcode 1: error in DDL statement for "GVD_SPPARAMETER " - repeat
2EETP345 08:53:39: Retcode 1: SQL-error "2220-ORA-02220: invalid MINEXTENTS storage option value" i
2EETP345 n DDL statement for "GVD_SPPARAMETER "
2 ETP399 --------------- DB-ROLLBACK() ---------------
2EETP334 08:53:39: error in DDL, nametab for "GVD_SPPARAMETER" not activated
2 ETP301 ----------------------------------------------------------------
3 ETP361 "0" Shadow-Nametabs activated, DDL executed
2 ETP362 "1" Shadow-Nametab activations failed
2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2012/12/07 08:53:27")2 ETP363 End : Act. of Shadow-Nametabs with DDL ("2012/12/07 08:53:39")


Solution:

This is caused because of you see MINEXTENTS 0000000000   AND MAXEXTENTS 000000000 on above screen shot,

you need to update the temperory table TATAF for MINIEXTENTS and MAXEXTENTS as below, this will fix the issue

update SAPDS1.TATAF set prtext = 'MAXEXTENTS 2147483645'
where prtext = 'MAXEXTENTS 0000000000' and tabname='GVD_SPPARAMETER';

update SAPDS1.TATAF set prtext = 'MINEXTENTS 0000000001'
where prtext = 'MINEXTENTS 0000000000' and
tabname='GVD_SPPARAMETER';

update SAPDS1.TATAF set prtext = 'STORAGE (INITIAL 65536'
where prtext = 'STORAGE (INITIAL 0000000000 K' and
tabname='GVD_SPPARAMETER';

update SAPDS1.TATAF set prtext = 'NEXT 1048576'
where prtext = 'NEXT 0000000000 K' and tabname='GVD_SPPARAMETER';

 

Note: To Avoid this issue Please make sure that is _FIX_CONTROL = '8937971:ON' set as per note 1570366


 

No comments:

Post a Comment