Skip to Content
0
Former Member
Dec 03, 2011 at 09:10 PM

Severe error(s) occured in phase PREP_INTEGRATION/TABSPC_PREP!

127 Views

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