1901463 - How to unlock the SAP system to perform correction(s) during an upgrade.

former_member597396 · ‎2018 Dec 03

Hi Gurus,

Our environment, SAP/DB/OS : NW 740/Oracle 12.1.0.2.0 /Windows Server 12 R2

We are applying and ADDON on our current ABAP NW740 system with BPC 10.1. Currently in PREPROCESSING step, phase MAIN_SHDRUN/PARDIST_SHD. Due to some issues we need to unlock the shadow instance and need to apply the note correction.

But while unlocking the shadow instance getting the below error, tp is unable to connect to the database.

----------------------------------------------------------------------------------------------------------------------------

F:\usr\sap\PBD\SUM\abap\bin>.\SAPup unlockshd PBD

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 = '02', GwService = 'sapgw02' Client = '000'

4 ETQ380 computing toolpath for request "TP_SHADOW_CONNECT"

4 ETQ381 request "TP_SHADOW_CONNECT" means "tp needs to connect to shadow system"

4 ETQ382 translates to group "R3UP_TOOL_GROUP_NEW"

4 ETQ399 Requirement for tp maps to 'exe'

4 ETQ383 translates to path "F:\usr\sap\PBD\SUM\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 system"

4 ETQ382 translates to group "R3UP_TOOL_GROUP_NEW"

4 ETQ399 Requirement for tp maps to 'exe'

4 ETQ383 translates to path "F:\usr\sap\PBD\SUM\abap\exe" 2 ETQ399 Distribute 6 parallel processes to 2 tp and 3 R3trans. 3 ETQ120 20181203100656: PID 4192 execute '~\exe\tp "pf=~\var\SHADOW.TPP" unlocksys PBD', output written to 'F:\usr\sap\PBD\SUM\abap\log\TP.ECO'.

3WETQ123 20181203100657: PID 4192 exited with status 232 (time 0.00 real) FATAL ERROR: Calling 'F:\usr\sap\PBD\SUM\abap\exe/tp' failed with return code 232, check F:\usr\sap\PBD\SUM\abap\log\TP.ECO for details tp used shadow connect

-----------------------------------------------------------------------------------------------------------------------------------

Below is the TP.ECO log

SAPup> Starting subprocess at 20181203100656

ENV: DBMS_TYPE=ora

ENV: NLS_LANG=AMERICAN_AMERICA.UTF8

ENV: ORACLE_HOME=G:\oracle\PBD\12102

ENV: ORACLE_SID=PBD

ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

ENV:PATH=F:\usr\sap\PBD\SUM\abap\exe;G:\oracle\PBD\12102\bin;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\IBM\ITM\bin;C:\IBM\ITM\TMAITM6;C:\IBM\ITM\InstallITM;G:\oracle\PBD\12102\perl\bin;G:\oracle\PBD\12102;F:\usr\sap\PBD\SYS\exe\uc\NTAMD64;G:\oracle\PBD\12102;G:\oracle\PBD\12102\perl\bin

ENV: RSEC_SSFS_DATAPATH=\\ppldrdvbisr01\sapmnt\PBD\SYS\global\security\rsecssfs\data

ENV: RSEC_SSFS_KEYPATH=\\ppldrdvbisr01\sapmnt\PBD\SYS\global\security\rsecssfs\key

ENV: SAPDATA_HOME=L:\oracle\PBD ENV: SAPSYSTEMNAME=PBD

*DBENV: auth_shadow_upgrade=1

*DBENV: dbs_ora_schema=SAPSR3 ENV: dbs_ora_tnsname=PBD

ENV: rsdb_ssfs_connect=1

PWD: F:\usr\sap\PBD\SUM\abap\bin EXECUTING

F:\usr\sap\PBD\SUM\abap\exe\tp.EXE "pf=F:\usr\sap\PBD\SUM\abap\var\SHADOW.TPP" unlocksys PBD

This is F:\usr\sap\PBD\SUM\abap\exe\tp.EXE version 381.20.90 (release 753, unicode enabled)

TRACE-INFO: 1: [ dev trc,00000] Mon Dec 03 10:06:56 2018

TRACE-INFO: 2: [ dev trc,00000] DlLoadLib success: LoadLibrary("dboraslib.dll"), hdl 0, count 1, addr 00007FFF15C60000

TRACE-INFO: 3: [ dev trc,00000] using "F:\usr\sap\PBD\SUM\abap\exe\dboraslib.dll"

TRACE-INFO: 4: [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1

TRACE-INFO: 5: [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK)

TRACE-INFO: 6: [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET)

TRACE-INFO: 7: [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) TRACE-INFO: 8: [ dev trc,00000] -->DbSlControl(con=-1,cmd=74=DBSL_CMD_CON_INFO_EXT_SUPPORT) -> rc=0=DBSL_ERR_OK, vers=0

TRACE-INFO: 9: [ dev trc,00000] -->DbSlControl(con=-1,cmd=79=DBSL_CMD_CON_INFO_EXT_SUPPORT_FOR_UPGRADE) -> rc=0=DBSL_ERR_OK, vers=0

TRACE-INFO: 10: [ dev trc,00000] Mon Dec 03 10:06:57 2018 TRACE-INFO: 11: [ dev trc,00000] -->DbSlConnect(ci=D7A1E3ED80, vers=0->0, type=0, env='', usr='SAPSR3SHD', dbsl='753')

TRACE-INFO: 12: [ dev trc,00000] Statement Cache (size=250) created

TRACE-INFO: 13: [ dev trc,00000] DIR_CLIENT_ORAHOME is not set as profile nor env. parameter.

TRACE-INFO: 14: [ dev trc,00000] Oracle client version: 12.1.0.2.0, (dbsl 753 240818, UNICODE[2], LE)

TRACE-INFO: 15: [ dev trc,00000] Detailed Oracle client (patch) info not available.

TRACE-INFO: 16: [ dev trc,00000] Default connection: tnsname ='PBD'

TRACE-INFO: 17: [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchr='AL16UTF16', nls=0), uc_ln=2, local=1, fan=0

TRACE-INFO: 18: [ dev trc,00000] (-) OCIEnvCreate(mode=16384=OCI_UTF16) -> rc=0

TRACE-INFO: 19: [ dev trc,00000] New environment handle env=D7A51F00C0 for nls=0, con=0 created

TRACE-INFO: 20: [ dev trc,00000] nls CharacterSet (Env) NCharSet envhp errhp er2hp bathp

TRACE-INFO: 21: [ dev trc,00000] 0 UTF16 AL16UTF16 D7A51F00C0 D7A51FB6C0 D7A51FC780 D7A51FD840 TRACE-INFO: 22: [ dev trc,00000] NLS env. settings: lang=41004D00450052004900430041004E00

TRACE-INFO: 23: [ dev trc,00000] terr=41004D0045005200490043004100

TRACE-INFO: 24: [ dev trc,00000] char=55005400460031003600

TRACE-INFO: 25: [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16' TRACE-INFO: 26: [ dev trc,00000] charset='UTF16', nchrset='AL16UTF16', UNI_ASC=FALSE

TRACE-INFO: 27: [ dev trc,00000] Got env NLS_LANG="AMERICAN_AMERICA.UTF8"

TRACE-INFO: 28: [ dev trc,00000] local client OS environment: NLS_LANG = 'AMERICAN_AMERICA.UTF8' TRACE-INFO: 29: [ dev trc,00000] NLS_NCHAR not set

TRACE-INFO: 30: [ dev trc,00000] Connecting as SAPSR3SHD/<pwd>@PBD on connection 0 (nls 0) ... (dbsl 753 240818, UNICODE[2], LE)

TRACE-INFO: 31: [ dev trc,00000] OCIHandleAlloc(con=0, env=D7A51F00C0): New service svc=D7A5201AA8 created, rc=0 TRACE-INFO: 32: [ dev trc,00000] server_attach(con=0,svc=D7A5201AA8,nls=0,dbn='PBD'): i=0, stale=0, nls=0, srv=NULL, dbname=''

TRACE-INFO: 33: [ dev trc,00000] OCIHandleAlloc(con=0,env=D7A51F00C0,nls=0): New server hdl. srv=D7A5201C90 at 'PBD' for svc=D7A5201AA8 created, rc=0

TRACE-INFO: 34: [ dev trc,00000] OCIServerAttach(con=0,svc=D7A5201AA8,dbname='PBD'): stale=0, nls=0, srv=D7A5201C90

TRACE-INFO: 35: [ dev trc,00000] c: OCIServerAttach(OCI_DEFAULT) failed with -1=OCI_ERROR, SQL error 12154:

TRACE-INFO: 36: [ dev trc,00000] ORA-12154: TNS:could not resolve the connect identifier specified

TRACE-INFO: 37: [ dev trc,00000] OCIServerAttach(con=0, svc=D7A5201AA8): Error 12154 attaching new srv=D7A5201C90

TRACE-INFO: 38: [ dev trc,00000] to 'PBD', ln=6 TRACE-INFO: 39: [ dev trc,00000] OCIHandleFree(con=0): Server handle srv=D7A5201C90 freed.

TRACE-INFO: 40: [ dev trc,00000] server_detach(con=0, svc=D7A5201AA8; srv=NULL='', stale=2) TRACE-INFO: 41: [ dev trc,00000] 0: OCIHandleFree(con=0): Service svc=D7A5201AA8 freed.

TRACE-INFO: 42: [ dev trc,00000] orc=12154 -> Trying to reattach to server 'PBD' with new svc

TRACE-INFO: 43: [ dev trc,00000] OCIHandleAlloc(con=0, env=D7A51F00C0): New service svc=D7A5201AA8 created, rc=0

TRACE-INFO: 44: [ dev trc,00000] server_attach(con=0,svc=D7A5201AA8,nls=0,dbn='PBD'): i=0, stale=0, nls=0, srv=NULL, dbname=''

TRACE-INFO: 45: [ dev trc,00000] OCIHandleAlloc(con=0,env=D7A51F00C0,nls=0): New server hdl. srv=D7A5201C90 at 'PBD' for svc=D7A5201AA8 created, rc=0

TRACE-INFO: 46: [ dev trc,00000] OCIServerAttach(con=0,svc=D7A5201AA8,dbname='PBD'): stale=0, nls=0, srv=D7A5201C90

TRACE-INFO: 47: [ dev trc,00000] c: OCIServerAttach(OCI_DEFAULT) failed with -1=OCI_ERROR, SQL error 12154:

TRACE-INFO: 48: [ dev trc,00000] ORA-12154: TNS:could not resolve the connect identifier specified TRACE-INFO: 49: [ dev trc,00000] OCIServerAttach(con=0, svc=D7A5201AA8): Error 12154 attaching new srv=D7A5201C90 TRACE-INFO: 50: [ dev trc,00000] to 'PBD', ln=6

TRACE-INFO: 51: [ dev trc,00000] OCIHandleFree(con=0): Server handle srv=D7A5201C90 freed.

TRACE-INFO: 52: [ dev trc,00000] server_detach(con=0, svc=D7A5201AA8; srv=NULL='', stale=2)

TRACE-INFO: 53: [ dev trc,00000] 1: OCIHandleFree(con=0): Service svc=D7A5201AA8 freed.

TRACE-INFO: 54: [ dev trc,00000] oci_logon(con=0, uid='SAPSR3SHD', pwd, tns='PBD') -> 12154

TRACE-INFO: 55: [dbsloci.c ,00000] *** ERROR => CONNECT failed with SQL error '12154'

TRACE-INFO: 56: [ dev trc,00000] -->oci_get_errmsg (con=0, rc=12154) TRACE-INFO: 57: [ dev trc,00000] OCIErrorGet() -> SQL error code: 12154; buflen=66

TRACE-INFO: 58: [ dev trc,00000] OCIErrorGet(): error text ->

TRACE-INFO: 59: [ dev trc,00000] ORA-12154: TNS:could not resolve the connect identifier specified TRACE-INFO: 60: [ dev trc,00000] ocica() -> SQL error code 12154,12154

TRACE-INFO: 61: [ dev trc,00000] DbSlConnect(con=0) -> orc=12154, rc=99=DBSL_ERR_DB

TRACE-INFO: 62: [dbsloci.c ,00000] *** ERROR => DbSlConnect() failed with 99=DBSL_ERR_DB

TRACE-INFO: 63: [ dblink ,00000] ***LOG BY2=>sql error 12154 performing CON

TRACE-INFO: 64: [ dblink ,00000] ***LOG BY0=>ORA-12154: TNS:could not resolve the connect identifier specified

warm regards,

Saravanan Nadar

former_member597396 · ‎2018 Dec 03

Hi Imtiaz,

Thanks for your response. Though we have gone through this note. If you see my question, i have mentioned this command executed from upgrade directory and the error output with the TP log.

Issue seems to be with the tp parameter or with the environment variable, we have tried setting different env variables like :

PATH=G:\oracle\PBD\12102\bin;F:\usr\sap\PBD\SUM\abap\exe;G:\oracle\PBD\12102\bin;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\IBM\ITM\bin;C:\IBM\ITM\TMAITM6;C:\IBM\ITM\InstallITM;G:\oracle\PBD\12102\perl\bin;G:\oracle\PBD\12102;F:\usr\sap\PBD\SYS\exe\uc\NTAMD64;G:\oracle\PBD\12102;G:\oracle\PBD\12102\perl\bin

dbs_ora_schema = SAPSR3 --> also SAPSR3SHD

dbs_ora_tnsname = PBD

Also have validated entries of env variable TNS_ADMIN path and its tnsnames.ora and sqlnet.ora file entries.

tnsnames.ora

PBD.WORLD= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = ppldrdvbisr01) (PORT = 1521) ) ) (CONNECT_DATA = (SERVICE_NAME = PBD) (SID = PBD) (GLOBAL_NAME = PBD.WORLD) ) )

sqlnet.ora

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

NAMES.DEFAULT_DOMAIN = WORLD

#NAMES.DIRECTORY_PATH = (TNSNAMES)

# 05.01.06 unsorported parameter now

#NAME.DEFAULT_ZONE = WORLD

# 05.01.06 set the default to 10

SQLNET.EXPIRE_TIME = 10

#SQLNET.AUTHENTICATION_SERVICES = (NTS)

SQLNET.AUTHENTICATION_SERVICES = (NONE)

# 05.01.06 set to default

TCP.NODELAY=NO

# 05.01.06 set to 32768 DEFAULT_SDU_SIZE=32768

#SQLNET.INBOUND_CONNECT_TIMEOUT=120

SQLNET.SEND_TIMEOUT=600

SQLNET.RECV_TIMEOUT=60000

Warm regards,

Saravanan Nadar

ImtiazKaredia · ‎2018 Dec 03

Follow SAP Note

1901463 - How to unlock the SAP system to perform correction(s) during an upgrade.

Unable to unlock shadow instance

Know the answer?

Need more details?

Accepted Solutions (0)

Answers (2)

Answers (2)

1901463 - How to unlock the SAP system to perform correction(s) during an upgrade.