Hi
We are facing an error "Severe error(s) occured in phase PREP_INTEGRATION/TABSPC_PREP!" while doing upgrade from SAP 4.6c to ECC 6.0 EHP4 (OS - Windows 64bit IA and Oracle 10g).
Could please help us to resolve this issue and please find the upgrade log.
Target SAP system is 'DV1'.
SAP instance number is '00'.
Type of database system is 'ORACLE'.
>> 2011/12/04 01:27:25 START OF PHASE PREP_INTEGRATION/TABSPC_PREP
determining table sizes ...
>>>> Repeat Phase <<<<
************************************
SAPup> Starting subprocess tp.exe with id 4120 at 20111204014529
EXECUTING I:\usr\sap\DV1\upg\abap\exe\tp.exe pf=I:\usr\sap\DV1\upg\abap\bin\TABSPC.TPP getdbobjsize DV1 -x GDBSSHD.SIZ
Environment: JAVA_HOME=C:\j2sdk1.4.2_32-x64\bin
Environment: NLS_LANG=AMERICAN_AMERICA.WE8DEC
Environment: ORACLE_HOME=H:\oracle\DV1\102
Environment: ORACLE_SID=DV1
Environment: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
Environment: Path=H:\oracle\DV1\102\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\The Open Group\WMI Mapper\bin;C:\Program Files\Hewlett-Packard\nParCommands\;C:\WINDOWS\syswow64;C:\j2sdk1.4.2_32-x64\bin;;I:\usr\sap\DV1\sys\exe\run;H:\oracle\DV1\102\bin
Environment: auth_shadow_upgrade=0
Environment: dbs_ora_schema=SAPR3
Environment: dbs_ora_tnsname=DV1
This is I:\usr\sap\DV1\upg\abap\exe\tp.exe version 376.03.38 (release 701, unicode enabled)
Warning: Parameter INTERRUPT is no longer used.
Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.
Warning: Parameter WITH_TACOB is no longer used.
Warning: Parameter IMPDP_BY_EVENT is no longer used.
Warning: Parameter INTERRUPT is no longer used.
Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.
Warning: Parameter WITH_TACOB is no longer used.
Warning: Parameter IMPDP_BY_EVENT is no longer used.
Warning: Parameter DBCONFPATH is no longer used.
TRACE-INFO: 1: [ dev trc,00000] Sun Dec 04 01:45:29 2011 4154 0.004154
TRACE-INFO: 2: [ dev trc,00000] DlLoadLib success: LoadLibrary("dboraslib.dll"), hdl 0, addr 0000000187950000
TRACE-INFO: 3: 46 0.004200
TRACE-INFO: 4: [ dev trc,00000] using "I:\usr\sap\DV1\upg\abap\exe\dboraslib.dll" 25 0.004225
TRACE-INFO: 5: [ dev trc,00000] CLIENT_ORACLE_HOME is not set as environment variable or 41310 0.045535
TRACE-INFO: 6: DIR_CLIENT_ORAHOME is not set as profile parameter.
TRACE-INFO: 7: assuming using instant client with unspecified location.
TRACE-INFO: 8: [ dev trc,00000] -->oci_init1 70 0.045605
TRACE-INFO: 9: [ dev trc,00000] Oracle Client Version: '10.2.0.2.0', (dbsl 701 170611, UNICODE[2]) 138952 0.184557
TRACE-INFO: 10: [ dev trc,00000] Default connection: tnsname ='DV1' 31 0.184588
TRACE-INFO: 11: [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', uc_ln=2) 7144 0.191732
TRACE-INFO: 12: [ dev trc,00000] Application info callback registered. 29 0.191761
TRACE-INFO: 13: [ dev trc,00000] ➖ OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle) 112996 0.304757
TRACE-INFO: 14: [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrHp=000000000B371680) 4593 0.309350
TRACE-INFO: 15: [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrBt=000000000B372E78) 39 0.309389
TRACE-INFO: 16: [ dev trc,00000] NLS env.: lang=41004D00450052004900430041004E00 12233 0.321622
TRACE-INFO: 17: [ dev trc,00000] terr=41004D0045005200490043004100 36 0.321658
TRACE-INFO: 18: [ dev trc,00000] char=55005400460031003600 32 0.321690
TRACE-INFO: 19: [ dev trc,00000] Client NLS setting (by OCINlsGetInfo): con=0, 'AMERICAN_AMERICA.UTF16' 34 0.321724
TRACE-INFO: 20: [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 31 0.321755
TRACE-INFO: 21: [ dev trc,00000] Logon as OPS$-user to get SAPR3's password 58 0.321813
TRACE-INFO: 22: [ dev trc,00000] Connecting as /@DV1 on connection 0 (nls 0) ... (dbsl 701 170611, UNICODE[2])
TRACE-INFO: 23: 46 0.321859
TRACE-INFO: 24: [ dev trc,00000] Allocating service context handle for con_hdl=0 313 0.322172
TRACE-INFO: 25: [ dev trc,00000] Allocating server context handle 36 0.322208
TRACE-INFO: 26: [ dev trc,00000] Attaching to DB Server DV1 (con_hdl=0,svchp=000000000B372D38,srvhp=000000000B3735E8)
TRACE-INFO: 27: 67 0.322275
TRACE-INFO: 28: [ dev trc,00000] Assigning server context 000000000B3735E8 to service context 000000000B372D38
TRACE-INFO: 29: 132824 0.455099
TRACE-INFO: 30: [ dev trc,00000] Allocating user session handle 3991 0.459090
TRACE-INFO: 31: [ dev trc,00000] Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=000000000B372D38, srvhp=000000000B3735E8, usrhp=000000000B371E98)
TRACE-INFO: 32: 73 0.459163
TRACE-INFO: 33: [ dev trc,00000] Assigning user session 000000000B371E98 to service context 000000000B372D38 99704 0.558867
TRACE-INFO: 34: [ dev trc,00000] -->oci_prepare_stmt(con_hdl=0, len=52, stmth_p=000000000B37CE18) 6099 0.564966
TRACE-INFO: 35: [ dev trc,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:A0,:A1);END;
TRACE-INFO: 36: 48 0.565014
TRACE-INFO: 37: [ dev trc,00000] - oci_bind ( 0: SQLT_STR, l=600, con_hdl=0, stmth_p=000000000B37CE18, vp=0000000187D4AA50,ip=0000000187AC5200,rlp=0000000000000000,rcp=0000000000000000)
TRACE-INFO: 38: 11757 0.576771
TRACE-INFO: 39: [ dev trc,00000] - oci_bind ( 1: SQLT_STR, l=600, con_hdl=0, stmth_p=000000000B37CE18, vp=0000000187D4CCF0,ip=0000000187AC5202,rlp=0000000000000000,rcp=0000000000000000)
TRACE-INFO: 40: 4670 0.581441
TRACE-INFO: 41: [ dev trc,00000] CbApplInfoGet() failed (ignored 1). 40 0.581481
TRACE-INFO: 42: [ dev trc,00000] -->oci_prepare_stmt(con_hdl=0, len=54, stmth_p=000000000B37DE70) 34 0.581515
TRACE-INFO: 43: [ dev trc,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO(:A0); END;
TRACE-INFO: 44: 48 0.581563
TRACE-INFO: 45: [ dev trc,00000] - oci_bind ( 0: SQLT_STR, l= 40, con_hdl=0, stmth_p=000000000B37DE70, vp=0000000187D48580,ip=0000000000000000,rlp=0000000000000000,rcp=0000000000000000)
TRACE-INFO: 46: 80 0.581643
TRACE-INFO: 47: [ dev trc,00000] -->oci_execute_stmt(con_hdl=0, stmth_p=000000000B37DE70, iters=1, rowoff=0, dml_batch_errors=0)
TRACE-INFO: 48: 5952 0.587595
TRACE-INFO: 49: [ dev trc,00000] <--oci_execute_stmt(rc=0, iters-errors = 1-0) [time 0,020s] 18037 0.605632
TRACE-INFO: 50: [ dev trc,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=000000000B37DE70) 56 0.605688
TRACE-INFO: 51: [ dev trc,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2
TRACE-INFO: 52: 47 0.605735
TRACE-INFO: 53: [ dev trc,00000] -->oci_define ( 0: SQLT_INT, l= 4, con_hdl=0, stmth_p=000000000B37DE70, vp=000000000202E194,ip=000000000202E190,rlp=0000000000000000,rcp=0000000000000000)
TRACE-INFO: 54: 79 0.605814
TRACE-INFO: 55: [ dev trc,00000] -->oci_execute_stmt(con_hdl=0, stmth_p=000000000B37DE70, iters=1, rowoff=0, dml_batch_errors=0)
TRACE-INFO: 56: 3888 0.609702
TRACE-INFO: 57: [ dev trc,00000] <--oci_execute_stmt(rc=0, iters-errors = 1-0) [time 0,000s] 5136 0.614838
TRACE-INFO: 58: [ dev trc,00000] Now '/@DV1' is connected: con_hdl=0, nls_hdl=0, session_id=37. 37 0.614875
TRACE-INFO: 59: [ dev trc,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=000000000B37DE70) 36 0.614911
TRACE-INFO: 60: [ dev trc,00000] ALTER SESSION SET NLS_SORT = BINARY
TRACE-INFO: 61: 48 0.614959
TRACE-INFO: 62: [ dev trc,00000] -->oci_execute_stmt(con_hdl=0, stmth_p=000000000B37DE70, iters=1, rowoff=0, dml_batch_errors=0)
TRACE-INFO: 63: 56 0.615015
TRACE-INFO: 64: [ dev trc,00000] <--oci_execute_stmt(rc=0, iters-errors = 1-0) [time 0,000s] 363 0.615378
TRACE-INFO: 65: [ dev trc,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=000000000B37DE70) 48 0.615426
TRACE-INFO: 66: [ dev trc,00000] SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0,:A1)
TRACE-INFO: 67: 49 0.615475
TRACE-INFO: 68: [ dev trc,00000] - oci_bind ( 0: SQLT_STR, l=256, con_hdl=0, stmth_p=000000000B37DE70, vp=0000000187DDBCB0,ip=0000000000000000,rlp=0000000000000000,rcp=0000000000000000)
TRACE-INFO: 69: 83 0.615558
TRACE-INFO: 70: [ dev trc,00000] - oci_bind ( 1: SQLT_STR, l=256, con_hdl=0, stmth_p=000000000B37DE70, vp=000000000202DE30,ip=0000000000000000,rlp=0000000000000000,rcp=0000000000000000)
TRACE-INFO: 71: 60 0.615618
TRACE-INFO: 72: [ dev trc,00000] -->oci_define ( 0: SQLT_STR, l=512, con_hdl=0, stmth_p=000000000B37DE70, vp=000000000202E230,ip=000000000202DBF4,rlp=0000000000000000,rcp=0000000000000000)
TRACE-INFO: 73: 59 0.615677
TRACE-INFO: 74: [ dev trc,00000] -->oci_define ( 1: SQLT_AFC, l=512, con_hdl=0, stmth_p=000000000B37DE70, vp=000000000202E030,ip=000000000202DBF6,rlp=0000000000000000,rcp=0000000000000000)
TRACE-INFO: 75: 61 0.615738
TRACE-INFO: 76: [ dev trc,00000] -->oci_execute_stmt(con_hdl=0, stmth_p=000000000B37DE70, iters=1, rowoff=0, dml_batch_errors=0)
TRACE-INFO: 77: 49 0.615787
TRACE-INFO: 78: [ dev trc,00000] <--oci_execute_stmt(rc=0, iters-errors = 1-0) [time 0,020s] 21051 0.636838
TRACE-INFO: 79: [ dev trc,00000] Sun Dec 04 01:45:30 2011 16009 0.652847
TRACE-INFO: 80: [ dbsloci.,00000] *** ERROR => Cannot decrypt password I got from table SAPUSER: rc = 16 29 0.652876
TRACE-INFO: 81: [ dev trc,00000] Disconnecting from connection 0 ... 47 0.652923
TRACE-INFO: 82: [ dev trc,00000] Rolling back transaction ... 63 0.652986
TRACE-INFO: 83: [ dev trc,00000] Closing user session (con_hdl=0,svchp=000000000B372D38,usrhp=000000000B371E98)
TRACE-INFO: 84: 2412 0.655398
TRACE-INFO: 85: [ dev trc,00000] Disconnected (con=0) from ORACLE. 661 0.656059
TRACE-INFO: 86: [ dev trc,00000] SAPUSER or connect error 18=DBSL_ERR_CONNECT, oerr=0. 33 0.656092
tp returncode summary:
TOOLS: Highest return code of single steps was: 0
ERRORS: Highest tp internal error was: 0232
tp finished with return code: 232
meaning:
connect failed
ERROR: Connect to DV1 failed (20111204014530, probably wrong environment).
Process with ID 14472 terminated with status 232