solution manager 7.1 - Entering upgrade-phase "MAIN_SHDIMP/SUBMOD_SHDIMP/SHADOW_IMPORT_INC" taking long hours

[Former Member]

Hello,

phase "MAIN_SHDIMP/SUBMOD_SHDIMP/SHADOW_IMPORT_INC" looks like hanged. I tried restarting the SAP SUM and oracle but it get stopped at same stage. There is no log generating neither any change in tmp file for almost 10 hours.

Changed the Shadow system memory according to 1387739

set the Oracle initialization parameter " _use_zero_copy_io=false"

ULOG

### Phase MAIN_SHDIMP/SUBMOD_SHDIMP/SHADOW_IMPORT_INC:

soladm       20140511004744    : H:\usr\sap\SOL\SUM\abap\exe\tp.EXE pf=H:\usr\sap\SOL\SUM\abap\var\DEFAULT.TPP setstopmark buffer=SOL before SAPK-707BZINBICONT  (pid=584)

soladm       20140511004745    : H:\usr\sap\SOL\SUM\abap\exe\tp.EXE pf=H:\usr\sap\SOL\SUM\abap\var\SHDALLIMP.TPP put SOL -Dmainimp_proc=1 -Dparallel=3  (pid=1076)

SHDALLIMP

SHADOW IMPORT ERRORS and RETURN CODE in SAPKB70210.SOL

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

4 ETW000  [    dbtrtab ,00000]  ***LOG BY4=>sql error 3113   performing SEL on table TRBAT3                       

4 ETW000                                                                                                  65  28272.089379

4 ETW000  [    dbtrtab ,00000]  ***LOG BY0=>ORA-03113: end-of-file on communication channel               37  28272.089416

4 ETW000                        Process ID: 7936

4 ETW000                        Session ID: 239 Serial number: 47

2EETW000 sap_dext called with msgnr "1":

According toNote  1597414 I need to create TRBAT3 in source system , ie my main system. Is it ok to create now or do I need to restart  Phase after the creating or do I need to start the SUM from scratch ?

Regards,

Raghu

[Former Member]

Hi Vikram,

Sorry it was my mistake , I have set the parameter wrongly. Set it properly and it starts working.

Your note were relevant and useful. 

Thanks,

Raghu

[VJain]

Hi Raghu,

Glad issue resolved. You can mark this thread as solved then.

Thanks

Vikram

[VJain]

Hi Raghu,

Check:

1431798 - Oracle 11.2.0: Database Parameter Settings

Thanks

Vikram