Skip to Content
avatar image
Former Member

TP connect error - after instance copy

Hi all,

Our client has so far one PAS (D01) and AAS (D02). I was told to configure another AAS as the copy of D02. Client make a copy D02 and install it on the third server. I've change configuration of /etc/hosts, changed destination /usr/sap/<SID>/D02 to /usr/sap/<SID>/D03 and when I start D03 everything is working fine. You can log in D03 and run any dialog|background process.

Unfortunately when the D03 is online client is not able to import any transports. TMS: check transport tool failed on the step DB connect: link to database failed:

This is tp version 340.16.54 (release 640) Warning: Parameter DBLIBPATH is no longer used. Warning: Parameter DBSWPATH is no longer used. ERROR: Connect to <SID> failed (20171228154048, probably wrong environment). TRACE-INFO: 1: [dev trc ,00000] Thu Dec 28 15:40:48 2017 TRACE-INFO: 2: [dev trc ,00000] DlLoadLib() success: dlopen("/usr/sap/<SID>/SYS/exe/r TRACE-INFO: 3: TRACE-INFO: 4: [dev trc ,00000] Got ORACLE_HOME=/oracle/<SID>/920_32 from environment TRACE-INFO: 5: [dev trc ,00000] >oci_initialize (con_hdl=0) TRACE-INFO: 6: [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environ TRACE-INFO: 7: [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC TRACE-INFO: 8: [dev trc ,00000] Logon as OPS$-user to get SAP<SID>'s password TRACE-INFO: 9: [dev trc ,00000] Connecting as /@<SID> on connection 0 (nls_hdl 0) ... TRACE-INFO: 10: TRACE-INFO: 11: [dev trc ,00000] Nls CharacterSet NationalCharSet ErrHpBatch TRACE-INFO: 12: TRACE-INFO: 13: [dev trc ,00000] 0 WE8DEC 0x8c9f4f0 TRACE-INFO: 14: TRACE-INFO: 15: [dev trc ,00000] Allocating service context handle for con_hdl=0 TRACE-INFO: 16: [dev trc ,00000] Allocating server context handle TRACE-INFO: 17: [dev trc ,00000] Attaching to DB Server <SID> (con_hdl=0,svchp=0x8c9f TRACE-INFO: 18: TRACE-INFO: 19: [dev trc ,00000] Assigning server context 0x8ca1ec4 to service cont TRACE-INFO: 20: TRACE-INFO: 21: [dev trc ,00000] Allocating user session handle TRACE-INFO: 22: [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x8c9f47c,s TRACE-INFO: 23: TRACE-INFO: 24: [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc TRACE-INFO: 25: [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x8ca1ec4) TRACE-INFO: 26: [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x8c9f47 TRACE-INFO: 27: TRACE-INFO: 28: [dev trc ,00000] Deallocating server context handle 0x8ca1ec4 TRACE-INFO: 29: [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '20' TRACE-INFO: 30: [dev trc ,00000] set_ocica() -> OCI or SQL return code 20 TRACE-INFO: 31: [dev trc ,00000] Try to connect with default password TRACE-INFO: 32: [dev trc ,00000] Connecting as SAP<SID>/<pwd>@<SID> on connection 0 (nl TRACE-INFO: 33: TRACE-INFO: 34: [dev trc ,00000] Nls CharacterSet NationalCharSet ErrHpBatch TRACE-INFO: 35: TRACE-INFO: 36: [dev trc ,00000] 0 WE8DEC 0x8c9f4f0 TRACE-INFO: 37: TRACE-INFO: 38: [dev trc ,00000] Allocating server context handle TRACE-INFO: 39: [dev trc ,00000] Attaching to DB Server <SID> (con_hdl=0,svchp=0x8c9f TRACE-INFO: 40: TRACE-INFO: 41: [dev trc ,00000] Assigning server context 0x8ca1ec4 to service cont TRACE-INFO: 42: TRACE-INFO: 43: [dev trc ,00000] Assigning username to user session 0x8caab90 TRACE-INFO: 44: [dev trc ,00000] Assigning password to user session 0x8caab90 TRACE-INFO: 45: [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x8c9f47c,s TRACE-INFO: 46: TRACE-INFO: 47: [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc TRACE-INFO: 48: [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x8ca1ec4) TRACE-INFO: 49: [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x8c9f47 TRACE-INFO: 50: TRACE-INFO: 51: [dev trc ,00000] Deallocating server context handle 0x8ca1ec4 TRACE-INFO: 52: [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '20' TRACE-INFO: 53: [dev trc ,00000] set_ocica() -> OCI or SQL return code 20 TRACE-INFO: 54: [dblink ,00430] ***LOG BY2=>sql error 20 performing CON [dblin TRACE-INFO: 55: TRACE-INFO: 56: [dblink ,00430] ***LOG BY0=>ORA-00020: maximum number of processes TRACE-INFO: 57:

On the OS level also R3trans -d is not able to connect to database:

[<sid>adm@server ~]$ R3trans -d This is R3trans version 6.13 (release 640 - 10.07.07 - 13:48:00). 2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'UHP'" R3trans finished (0012).

When I stop D03 everything works:-)

All system environments are the same as in D02 despite HOST, HOSTNAME and REMOTEHOST.

Could you please help me what else should be changed after the instance copy?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer