Error in prepare phase MAIN_SHDINST/SCEXEC_ALIAS NW 7.0 EPH1 Upgrade

[former_member728115]

Greetings,

During the prepare phase my upgrade has stopped at MAIN_SHDINST/SCEXEC_ALIAS and produces the following error:

CURRENTPHASE MAIN_SHDINST/SCEXEC_ALIAS

...started at 20100408132545

1. Reading Parameter File "/usr/sap/EBP/upg/abap/bin/PTALDC.LLT" at 20100408132545

2. Reading Parameter File "/usr/sap/EBP/upg/abap/bin/PTALDC.LLT" at 20100408132553

3. Error message set: 'Cannot open '/usr/sap/EBP/upg/abap/log/PTALDC00.LOG': No such file or directory'

...begin dialogue at 20100408132553

Upon review of log SCEXEC_A.EC7, I have found the following issues:

EXECUTING /usr/sap/EBP/upg/abap/exenew/tp (/usr/sap/EBP/upg/abap/exenew/tp) pf=/usr/sap/EBP/upg/abap/bin/EXDBNEW.TPP execdbscript EBP

-x PTALDC07.XQL DBEXECNONT DBEXECNOCHECK

This is /usr/sap/EBP/upg/abap/exenew/tp version 372.04.71 (release 701, unicode enabled)

ERROR: Connect to EBP failed (20100408110441, probably wrong environment).

TRACE-INFO: 40: [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2

TRACE-INFO: 41: 29 0.065518

TRACE-INFO: 42: [dev trc ,00000] Connected to session 111. 733 0.066251

TRACE-INFO: 43: [dev trc ,00000] Now '/@EBP' is connected: con_hdl=0, nls_hdl=0, session_id=111. 15 0.066266

TRACE-INFO: 44: [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0xf22fc68) 26 0.066292

TRACE-INFO: 45: [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

TRACE-INFO: 46: 16 0.066308

TRACE-INFO: 47: [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0xf22fc68) 358 0.066666

TRACE-INFO: 48: [dev trc ,00000] SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0,:A1)

TRACE-INFO: 49: 26 0.066692

TRACE-INFO: 50: [dev trc ,00000] - oci_bind ( 0: SQLT_STR, l=256, con_hdl=0, stmth_p=0xf22fc68, vp=0x2b3bd06ead56,ip=(nil),rlp=(nil),rcp=(nil))

TRACE-INFO: 51: 48 0.066740

TRACE-INFO: 52: [dev trc ,00000] - oci_bind ( 1: SQLT_STR, l=256, con_hdl=0, stmth_p=0xf22fc68, vp=0x7fffdbd11040,ip=(nil),rlp=(nil),rcp=(nil))

TRACE-INFO: 53: 33 0.066773

TRACE-INFO: 54: [dev trc ,00000] OCIStmtExecute() completed, rc=100=OCI_NO_DATA, no further data 618 0.067391

TRACE-INFO: 55: [dev trc ,00000] -> rc=1403=OCI_ERR_NOT_FOUND 15 0.067406

TRACE-INFO: 56: [dbsloci. ,00000] *** ERROR => ORA-1403 when accessing table SAPUSER 26 0.067432

TRACE-INFO: 57: [dev trc ,00000] set_ocica() -> SQL code 1403 18 0.067450

TRACE-INFO: 58: [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1403) 21 0.067471

TRACE-INFO: 59: [dev trc ,00000] OCIErrorGet -> SQL error code: 1403 101 0.067572

TRACE-INFO: 60: [dev trc ,00000] ORA-01403: no data found

TRACE-INFO: 61: 16 0.067588

TRACE-INFO: 62: [dev trc ,00000] Disconnecting from connection 0 ... 16 0.067604

TRACE-INFO: 63: [dev trc ,00000] Rolling back transaction ... 24 0.067628

TRACE-INFO: 64: [dev trc ,00000] Closing user session (con_hdl=0,svchp=0xf2217e0,usrhp=0xf25e2d8) 205 0.067833

TRACE-INFO: 65: [dev trc ,00000] Now I'm disconnected from ORACLE 828 0.068661

TRACE-INFO: 66: [dev trc ,00000] Try to connect with default password 20 0.068681

TRACE-INFO: 67: [dev trc ,00000] Connecting as SAPEBPSHD/<pwd>@EBP on connection 0 (nls_hdl 0) ... (dbsl 701 220409)

TRACE-INFO: 68: 21 0.068702

TRACE-INFO: 69: [dev trc ,00000] Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

TRACE-INFO: 70: 19 0.068721

TRACE-INFO: 71: [dev trc ,00000] 0 UTF8 0xf209478 0xf210f48 0xf2218b0

TRACE-INFO: 72: 16 0.068737

TRACE-INFO: 73: [dev trc ,00000] Assigning username to user session: con_hdl=0, usrhp=0xf25e2d8 13 0.068750

TRACE-INFO: 74: [dev trc ,00000] Assigning password to user session: con_hdl=0, usrhp=0xf25e2d8 35 0.068785

TRACE-INFO: 75: [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr=SAPEBPSHD/<pwd>, svchp=0xf2217e0, srvhp=0xf225000, usrhp=0xf25e2d8)

TRACE-INFO: 76: 309 0.069094

TRACE-INFO: 77: [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 2358 0.071452

TRACE-INFO: 78: [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 70 0.071522

TRACE-INFO: 79: [dev trc ,00000] ORA-01017: invalid username/password; logon denied

TRACE-INFO: 80: 19 0.071541

TRACE-INFO: 81: [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017' 18 0.071559

TRACE-INFO: 82: [dev trc ,00000] set_ocica() -> SQL error code 1017 10 0.071569

TRACE-INFO: 83: [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1017) 11 0.071580

TRACE-INFO: 84: [dev trc ,00000] OCIErrorGet -> SQL error code: 1017 49 0.071629

TRACE-INFO: 85: [dev trc ,00000] ORA-01017: invalid username/password; logon denied

TRACE-INFO: 86: 16 0.071645

TRACE-INFO: 87: [dblink ,00433] ***LOG BY2=>sql error 1017 performing CON [dblink#4 @ 433] 55 0.071700

TRACE-INFO: 88: [dblink ,00433] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#4 @ 433]

TRACE-INFO: 89: 18 0.071718

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

I have opened an OSS message with SAP, with no response yet.

I was hoping that someone on the forum has seen this before and has a recommended corrective action.

Thanks in advance,

Mike

[Former Member · Accepted solution]

Looks like your shadow user SAPEBPSHD password is not right or got changed.

Please have a look at this thread [Error during creating the shadow system |;. It might be helpful.

Hope this helps.

Thanks,

Naveed

[Former Member]

Hi,

the exact syntax to change password :

brconnect -u system/manager -f chpass -o <schmaID>shd -p SAP

for examlpe

brconnect -u system/manager -f chpass -o sapr3shd -p SAP

Regards,

Faris

[Former Member]

Just an info .... Refer SAP Note 562863 , point number 7

[former_member728115]

Thanks Naveed,

By resetting the SAP<SID>SHD user back to the default password of SAP corrected the problem.

I used brconnect to reset the password:

brconnect -u system/<password> -f chpass -o sap<SID>shd -p SAP

Thanks,

Mike