SAP Knowledge Base Article - Preview

3102954 - SAPup Unlockshd Fail

Symptom

When trying to unlock the shadow, it fails as below:

 

X:\<SUM_Directory>\bin\> .\SAPup unlockshd

4 ETQ399 Set database connect to shadow.
4 ETQ399 Set environment for shadow connect:
4 ETQ399 Set RFC variables for shadow connect:
4 ETQ399 System-nr = '01', GwService = 'sapgw01' Client = '000'
4 ETQ380 computing toolpath for request "TP_SHADOW_CONNECT"
4 ETQ381 request "TP_SHADOW_CONNECT" means "tp needs to connect to shadow syste
"
4 ETQ382 translates to group "R3UP_TOOL_GROUP_NEW"
4 ETQ399 Requirement for tp maps to 'exe'
4 ETQ383 translates to path "X:\<SUM_Directory>\abap\exe"
4 ETQ399 Set tool parameters for shadow connect with TPPARAM 'SHADOW.TPP'.
4 ETQ380 computing toolpath for request "TP_SHADOW_CONNECT"
4 ETQ381 request "TP_SHADOW_CONNECT" means "tp needs to connect to shadow syste
"
4 ETQ382 translates to group "R3UP_TOOL_GROUP_NEW"
4 ETQ399 Requirement for tp maps to 'exe'
4 ETQ383 translates to path "X:\<SUM_Directory>\abap\exe"
2 ETQ399 Distribute 16 parallel processes to 2 tp and 8 R3trans.
3 ETQ120 20210920160709: PID <pid> execute '~\exe\tp "pf=~\var\SHADOW.TPP" unloc
sys S01', output written to 'X:\<SUM_Directory>\abap\log\TP.ECO'.
3WETQ123 20210920160709: PID <pid> exited with status 232 (time    0.00 real)FATAL ERROR: Calling 'X:\<SUM_Directory>\abap\exe/tp' failed with return code 232
check X:\<SUM_Directory>\abap\log\TP.ECO for details

In TP.ECO, the following is displayed:

TRACE-INFO: 53:  [     dev trc,00000]  oci_logon(con=0, uid='SAPNP1SHD', pwd, tns='<SID>') -> 12154
TRACE-INFO: 54:  [dbsloci.c   ,00000]  *** ERROR => CONNECT failed with SQL error '12154'
TRACE-INFO: 55:  [     dev trc,00000]  -->oci_get_errmsg (con=0, rc=12154)
TRACE-INFO: 56:  [     dev trc,00000]     OCIErrorGet() -> SQL error code: 12154; buflen=66
TRACE-INFO: 57:  [     dev trc,00000]  OCIErrorGet(): error text ->
TRACE-INFO: 58:  [     dev trc,00000]  ORA-12154: TNS:could not resolve the connect identifier specified                                                                
TRACE-INFO: 59:  [     dev trc,00000]  ocica() -> SQL error code 12154,12154
TRACE-INFO: 60:  [     dev trc,00000]     DbSlConnect(con=0) -> orc=12154, rc=99=DBSL_ERR_DB
TRACE-INFO: 61:  [dbsloci.c   ,00000]  *** ERROR =>    DbSlConnect() failed with 99=DBSL_ERR_DB
TRACE-INFO: 62:  [    dblink  ,00000]  ***LOG BY2=>sql error 12154  performing CON
TRACE-INFO: 63:  [    dblink  ,00000]  ***LOG BY0=>ORA-12154: TNS:could not resolve the connect identifier specified


Read more...

Environment

  • Oracle Database not restricted to any version
  • SAP Netweaver not restricted to any version
  • SUM with latest patch as of September 2021
  • Windows platform

Product

SAP NetWeaver all versions

Keywords

EHP upgrade oracle failing unlocking locked remove  , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.