Additional Blogs by Members
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

I am handing on a update project of EHP6 SPS05 update.

The source release is:

        EHP6 for ERP 6.0 with NW 7.03 initial installation ABAP only

        EHP6 ERP central application SPS00

        NW7.03 ABAP SPS00

        SAP ERP 6.00 SPS019

  Target release:

        EHP6 for ERP 6.0 with NW 7.03 ABAP all comopent update to EHP6 SPS05:

        EHP6 ERP central application SPS05

        NW7.03 ABAP SPS05

        SAP ERP 6.06 SPS05 (HR 604, IS-* component to 606 )

Enviroment:Linux,Oracle 11.2.0.3

Now in step:5.5-Preprocessing

                    phase: MAIN_SHDRUN/ACT_UPG

1.This phase run a very long time, still in progress;

        SM37 check job staus still run: RDDMASGL

        it seems will run endless

2.No more log update with tail in sum during run.

3.check oracle archiveing log, new log produced, so should not hang in db:

before

####################################

-rw-r----- 1 oradev dba 33183744 Jan 23 11:43 DEVarch1_6262_775365559.dbf

-rw-r----- 1 oradev dba 36688896 Jan 23 11:45 DEVarch1_6263_775365559.dbf

-rw-r----- 1 oradev dba 32443392 Jan 23 11:47 DEVarch1_6264_775365559.dbf

-rw-r----- 1 oradev dba 27946496 Jan 23 12:07 DEVarch1_6265_775365559.dbf

-rw-r----- 1 oradev dba 29207552 Jan 23 12:33 DEVarch1_6266_775365559.dbf

#####################################

now:

asnlp01erpdev:oradev 145> ls -ltr

####################################

-rw-r----- 1 oradev dba 33183744 Jan 23 11:43 DEVarch1_6262_775365559.dbf

-rw-r----- 1 oradev dba 36688896 Jan 23 11:45 DEVarch1_6263_775365559.dbf

-rw-r----- 1 oradev dba 32443392 Jan 23 11:47 DEVarch1_6264_775365559.dbf

-rw-r----- 1 oradev dba 27946496 Jan 23 12:07 DEVarch1_6265_775365559.dbf

#####################################

4. check oracle session with sql plus:

SQL> select * from v$session;

there are 61 records hit

so not hung;

5.have read notes:

Note 556764 - Upgrade hangs in phase ACT_<REL>

   755029 - Mass activation program has long runtime

but they all for old release of oracle older than 11 g,

not fit my current oracle release 11.2.0.3

Note 556764 only for phase ACT_<REL>

mine is :ACT_UPG not fit

6.how can I fasten the phase running time;

   and there no parellel run option

   is there any parellel run option

   or other more optimizer solution to this phase

welcome suggestion and discussion about it.