Skip to Content
-1

disp+work.EXE Running but Dialog Queue standstill [ORACLE]

Jun 15, 2017 at 08:11 AM

159

avatar image

Dear Gurus,

We are using SRM system.
r3trans -d finished with 0000. But, Dialog Queue standstill.
Please help

1. r3trans -d

Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation.All rights reserved. C:\Users\seqadm>r3trans -d This is r3trans version 6.24 (release 721 - 19.10.16 - 20:16:07). unicode enabled version R3trans=>sapparam(1c): No Profile used. R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline r3trans finished (0000).

2. trans.log

4 ETW000 r3trans version 6.24 (release 721 - 19.10.16 - 20:16:07). 4 ETW000 unicode enabled version 4 ETW000 =============================================== 4 ETW000 4 ETW000 date&time: 15.06.2017 - 15:38:32 4 ETW000 control file: <no ctrlfile> 4 ETW000 R3trans was called as follows: r3trans -d 4 ETW000trace at level 1 opened for a given file pointer 4 ETW000[dev trc,00000]Thu Jun 15 15:38:32 2017 4 ETW000[dev trc,00000]Loading DB library 'dboraslib.dll' ... 4 ETW000[dev trc,00000]Library 'dboraslib.dll' loaded 4 ETW000[dev trc,00000]Version of 'dboraslib.dll' is "721.02", patchlevel (0.800) 4 ETW000[dev trc,00000]dbs/ora/stmt_cache_size = 250 4 ETW000[dev trc,00000]Register application info. 4 ETW000[dev trc,00000]Oracle client version: 11.2.0.3.0, (dbsl 721 290916, UNICODE[2]) 4 ETW000[dev trc,00000]Detailed Oracle client (patch) info not available. 4 ETW000[dev trc,00000]Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16' 4 ETW000[dev trc,00000]Logon as OPS$-user to get SAPSR3's password 4 ETW000[dev trc,00000]Connecting as /@SEQ on connection 0 (nls 0) ... (dbsl 721 290916, UNICODE[2]) 4 ETW000[dev trc,00000]OCIHandleAlloc(con=0): Service svc=03B70E20 created, rc=0 4 ETW000[dev trc,00000]Thu Jun 15 15:38:35 2017 4 ETW000[dev trc,00000]OCIServerAttach(con=0, svc=03B70E20): New server hdl. srv=03B71800 attached to 'SEQ' 4 ETW000[dev trc,00000]OCISessionBegin(con=0, svc=03B70E20, srv=03B71800='SEQ'): start session usr=03B84640='/', rc=0 4 ETW000[dev trc,00000]Now '/@SEQ' is connected: con=0, nls=0, session=160, time='2017-06-15 15:38:35' 4 ETW000[dev trc,00000]Got SAPSR3's password from OPS$-user 4 ETW000[dev trc,00000]Disconnecting con=0 4 ETW000[dev trc,00000]OCISessionEnd(con=0, svc=03B70E20, srv=03B71800='SEQ'): Close session usr=03B84640, rc=0 4 ETW000[dev trc,00000]Connecting as SAPSR3/<pwd>@SEQ on connection 0 (nls 0) ... (dbsl 721 290916, UNICODE[2]) 4 ETW000[dev trc,00000]Thu Jun 15 15:38:50 2017 4 ETW000[dev trc,00000]OCISessionBegin(con=0, svc=03B70E20, srv=03B71800='SEQ'): start session usr=03B84640='SAPSR3', rc=0 4 ETW000[dev trc,00000]Now 'SAPSR3/<pwd>@SEQ' is connected: con=0, nls=0, session=160, time='2017-06-15 15:38:50' 4 ETW000[dev trc,00000]DB instance SEQ is running on EXSAPDQAS with ORACLE version 11.2.0.3.0 since JUN 15, 2017, 14:31:35. 4 ETW000[dev trc,00000]con=0, V$NLS_PARAMETERS: NLS_LANG=AMERICAN_AMERICA.UTF8, NLS_NCHAR=UTF8 4 ETW000[dev trc,00000]# CharacterSetNCharSetenvhperrhper2hpbathp 4 ETW000[dev trc,00000]0 UTF16AL16UTF1603B611F003B6CF0803B6DF8803B6F008 4 ETW000[dev trc,00000]Connection 0 opened (DBSL handle 0) 4 ETW000[dev trc,00000]DbSlControl(DBSL_CMD_SAPRELEASE_SET,abap='700') 4 ETW000[dev trc,00000]NTAB: version is VERS_B, UNICODELG=2, SAP_UC_LN=2 4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = 'SEQ' --- SYSTEM = 'SEQ'. 4 ETW690 COMMIT "0" "0" 4 ETW000trace to file pointer closed 4 ETW000trace at level 1 opened for a given file pointer 4 ETW000 4 ETW000 ================== STEP 1 ===================== 4 ETW000 date&time: 15.06.2017 - 15:38:50 4 ETW000 function: CONNECT 4 ETW000 buffersync: YES 4 ETW000 clients: default 4 ETW000 l.s.m.: VECTOR 4 ETW000 commit: 100000 4 ETW000 table cache: dynamic 4 ETW000 4 ETW000[dev trc,00000]Disconnecting from ALL connections: 4 ETW000[dev trc,00000]dbcon[db_con_disconnect_all]: disconnecting from connection 0 ... 4 ETW000[dev trc,00000]Disconnecting con=0 4 ETW000[dev trc,00000]OCISessionEnd(con=0, svc=03B70E20, srv=03B71800='SEQ'): Close session usr=03B84640, rc=0 4 ETW000[dev trc,00000]OCIServerDetach(stale1 con=0, svc=03B70E20, srv=03B71800='SEQ') successfully detached 4 ETW000[dev trc,00000]OCIHandleFree(con=0, svc=03B70E20): Server handle srv=03B71800 freed 4 ETW000[dev trc,00000]OCIHandleFree(con=0): Service hdl. svc=03B70E20 freed. 4 ETW000[dev trc,00000]dbcon[db_con_disconnect_all]: disconnected from connection 0 4 ETW000[dev trc,00000]statistics db_con_commit (com_total=1, com_tx=1) 4 ETW000[dev trc,00000]statistics db_con_rollback (roll_total=0, roll_tx=0) 4 ETW000 Disconnected from database. 4 ETW000 End of Transport (0000). 4 ETW000 date&time: 15.06.2017 - 15:38:50

3. Database status

C:\Users\seqadm>sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Thu Jun 15 15:42:01 2017 Copyright (c) 1982, 2011, Oracle.All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select status from v$instance; STATUS ------------ OPEN SQL>

4. dev_w*

--------------------------------------------------- trc file: "dev_w1", trc level: 1, release: "721" --------------------------------------------------- * *ACTIVE TRACE LEVEL1 *ACTIVE TRACE COMPONENTSall, MJ * M sysno03 M sidSEQ M systemid562 (PC with Windows NT) M relno7210 M patchlevel 0 M patchno800 M intno20020600 M makemultithreaded, Unicode, 64 bit, optimized M profile\\EXSAPDQAS\sapmnt\SEQ\SYS\profile\SEQ_DVEBMGS03_EXSAPDQAS M pid14596 M Mkernel runs with dp version 150000(ext=125000) (@(#) DPLIB-INT-VERSION-150000-UC) Mlength of sys_adm_ext is 596 bytes M***LOG Q0Q=> tskh_init, WPStart (Workp. 1 14596) [dpxxdisp.c1380] IMtxInit: 1 0 0 MDpSysAdmExtCreate: ABAP is active MDpSysAdmExtCreate: VMC (JAVA VM in WP) is active MDpIPCInit2: read dp-profile-values from sys_adm_ext MDpShMCreate: sizeof(wp_adm)48800-2568 MDpShMCreate: sizeof(tm_adm)5824176-28976 MDpShMCreate: sizeof(wp_ca_adm)64000-64 MDpShMCreate: sizeof(appc_ca_adm)64000-64 MDpCommTableSize: max/headSize/ftSize/tableSize=500/16/1464064/1464080 MDpShMCreate: sizeof(comm_adm)1464080-2904 MDpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=512/48/163904/96560/260512 MDpShMCreate: sizeof(slock_adm)260512-296 MDpFileTableSize: max/headSize/ftSize/tableSize=3800/16/364864/364880 MDpShMCreate: sizeof(file_adm)364880-80 MDpShMCreate: sizeof(vmc_adm)41040-2160 MDpShMCreate: sizeof(wall_adm)(41664/42896/64/192) MDpShMCreate: sizeof(gw_adm)48 MDpShMCreate: sizeof(j2ee_adm)3952 MDpShMCreate: SHM_DP_ADM_KEY(addr: 00000000100D0050, size: 8234368) MDpShMCreate: allocated sys_adm at 00000000100D0060 MDpShMCreate: allocated wp_adm_list at 00000000100D30E0 MDpShMCreate: allocated wp_adm at 00000000100D32D0 MDpShMCreate: allocated tm_adm_list at 00000000100DF180 MDpShMCreate: allocated tm_adm at 00000000100DF1D0 MDpShMCreate: allocated wp_ca_adm at 000000001066D090 MDpShMCreate: allocated appc_ca_adm at 000000001067CAA0 MDpShMCreate: allocated comm_adm at 000000001068C4B0 MDpShMCreate: allocated slock_adm at 00000000107F1BD0 MDpShMCreate: allocated file_adm at 0000000010831580 MDpShMCreate: allocated vmc_adm_list at 000000001088A6E0 MDpShMCreate: allocated vmc_adm at 000000001088A790 MDpShMCreate: allocated gw_adm at 00000000108947F0 MDpShMCreate: allocated j2ee_adm at 0000000010894830 MDpShMCreate: allocated ca_info at 00000000108957B0 MDpShMCreate: allocated wall_adm at 0000000010895840 MDpCommAttachTable: attached comm table (header=000000001068C4B0/ft=000000001068C4C0) MDpSesCreateTable: attached session table at 0000000002E40050 (len=167472) MDpRqQInit: use protect_queue / slots_per_queue 0 / 2001 from sys_adm M M Thu Jun 15 15:19:08 2017 Mrdisp/queue_size_check_value :-> on,50,30,40,500,50,500,80 XEmInit: MmSetImplementation( 2 ). XMM global diagnostic options set: 0 X<ES> client 1 initializing .... X<ES> EsILock: use Mutex for locking XUsing implementation view X<EsNT> Using memory model view. M<EsNT> Memory Reset disabled as NT default XES initialized. Xmm.dump: set maximum dump mem to 192 MB Xmm.dump: set global maximum dump mem to 192 MB XEsRegisterEmCheck: Register EmGetEsHandles at 00000001408B1FF0 XEs2ResCreate: Changed resource parameters to XfilenamePrefix = XblockSizeKB= 1024 KB XinitialSizeMB= 240 MB XextendSizeMB= 120 MB XmaxSizeMB= 5640 MB MDpVmcSetActive: set vmc state DP_VMC_ENABLED MDpVmcSetActive: set vmc state DP_VMC_ACTIVE MDpVmcInit2: o.k. M M Thu Jun 15 15:19:09 2017 MThStart: taskhandler started MThTHPInit: thp initialized MThInit: initializing DIA work process W1 M M Thu Jun 15 15:19:10 2017 MThInit: running on host EXSAPDQAS IMtxInit: 1 0 0 M M Thu Jun 15 15:19:13 2017 Mcalling db_connect ... BLoading DB library 'G:\usr\sap\SEQ\DVEBMGS03\exe\dboraslib.dll' ... BLibrary 'G:\usr\sap\SEQ\DVEBMGS03\exe\dboraslib.dll' loaded BVersion of 'G:\usr\sap\SEQ\DVEBMGS03\exe\dboraslib.dll' is "721.02", patchlevel (0.800) Cdbs/ora/stmt_cache_size = 250 CPrepending G:\usr\sap\SEQ\DVEBMGS03\exe to Path. CRegister application info. COracle client version: 11.2.0.3.0, (dbsl 721 290916, UNICODE[2]) CDetailed Oracle client (patch) info not available. C C Thu Jun 15 15:19:14 2017 CClient NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16' CLogon as OPS$-user to get SAPSR3's password CConnecting as /@SEQ on connection 0 (nls 0) ... (dbsl 721 290916, UNICODE[2]) COCIHandleAlloc(con=0): Service svc=09AD8A90 created, rc=0 C C Thu Jun 15 15:19:25 2017 COCIServerAttach(con=0, svc=09AD8A90): New server hdl. srv=09AD9650 attached to 'SEQ' COCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: CORA-01017: invalid username/password; logon denied COCISessionBegin(con=0, svc=09AD8A90, srv=09AD9650='SEQ'): start session usr=09AE88E0='/', rc=1017 COCIHandleFree(con=0, svc=09AD8A90): Free session hdl usr=09AE88E0 COCIServerDetach(stale2 con=0, svc=09AD8A90, srv=09AD9650='SEQ') successfully detached COCIHandleFree(con=0, svc=09AD8A90): Server handle srv=09AD9650 freed COCIHandleFree(con=0): Service svc=09AD8A90 freed (i=0). Crc=1017 -> Trying to reattach to server 'SEQ' COCIHandleAlloc(con=0): Service svc=09AD8A90 created, rc=0 C C Thu Jun 15 15:20:04 2017 COCIServerAttach(con=0, svc=09AD8A90): New server hdl. srv=09AD9650 attached to 'SEQ' COCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: CORA-01017: invalid username/password; logon denied COCISessionBegin(con=0, svc=09AD8A90, srv=09AD9650='SEQ'): start session usr=09AE31D8='/', rc=1017 COCIHandleFree(con=0, svc=09AD8A90): Free session hdl usr=09AE31D8 COCIServerDetach(stale2 con=0, svc=09AD8A90, srv=09AD9650='SEQ') successfully detached COCIHandleFree(con=0, svc=09AD8A90): Server handle srv=09AD9650 freed COCIHandleFree(con=0): Service svc=09AD8A90 freed (i=1). C*** ERROR => CONNECT failed with SQL error '1017' [dbsloci.c16098] CInfo: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password. CConnecting as SAPSR3/<pwd>@SEQ on connection 0 (nls 0) ... (dbsl 721 290916, UNICODE[2]) COCIHandleAlloc(con=0): Service svc=09AD8A90 created, rc=0 C C Thu Jun 15 15:20:43 2017 COCIServerAttach(con=0, svc=09AD8A90): New server hdl. srv=09AD9650 attached to 'SEQ' C C Thu Jun 15 15:20:45 2017 COCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: CORA-01017: invalid username/password; logon denied COCISessionBegin(con=0, svc=09AD8A90, srv=09AD9650='SEQ'): start session usr=09AE31D8='SAPSR3', rc=1017 COCIHandleFree(con=0, svc=09AD8A90): Free session hdl usr=09AE31D8 COCIServerDetach(stale2 con=0, svc=09AD8A90, srv=09AD9650='SEQ') successfully detached COCIHandleFree(con=0, svc=09AD8A90): Server handle srv=09AD9650 freed COCIHandleFree(con=0): Service svc=09AD8A90 freed (i=0). Crc=1017 -> Trying to reattach to server 'SEQ' COCIHandleAlloc(con=0): Service svc=09AD8A90 created, rc=0 C C Thu Jun 15 15:21:22 2017 COCIServerAttach(con=0, svc=09AD8A90): New server hdl. srv=09AD9650 attached to 'SEQ' C C Thu Jun 15 15:22:58 2017 COCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: CORA-01017: invalid username/password; logon denied COCISessionBegin(con=0, svc=09AD8A90, srv=09AD9650='SEQ'): start session usr=09AE31D8='SAPSR3', rc=1017 COCIHandleFree(con=0, svc=09AD8A90): Free session hdl usr=09AE31D8 COCIServerDetach(stale2 con=0, svc=09AD8A90, srv=09AD9650='SEQ') successfully detached COCIHandleFree(con=0, svc=09AD8A90): Server handle srv=09AD9650 freed COCIHandleFree(con=0): Service svc=09AD8A90 freed (i=1). C*** ERROR => CONNECT failed with SQL error '1017' [dbsloci.c16098] B***LOG BY2=> sql error 1017performing CON [dbsh1246] B***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh1246] B***LOG BY2=> sql error 1017performing CON [dblink544] B***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink544] M***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c1559] Min_ThErrHandle: 1 M*** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c11698] M MInfo for wp 1 M Mpid = 14596 Mseverity = 0 Mstatus = 0 Mstat = WP_NEW Mwaiting_for = NO_WAITING Mreqtype = DP_RQ_DIAWP Mact_reqtype = NO_REQTYPE Mreq.req_info = Mreq.tid = -1 Mreq.uid = 4294967295 Mreq.mode = 255 Mreq.len = 0 Mreq.rq_id = 65535 Mreq.rq_source = Mreq.vm = no VM Mlast_tid = 0 Mlast_uid = 0 Mlast_mode = 0 Mlocked semaphores (), locking () Mact_cs_count = 1 McsTrack = 0 McsTrackRwExcl = 0 McsTrackRwShrd = 0 Mmode_cleaned_counter = 0 Mcontrol_flag = 0 Mint_checked_resource(RFC) = 0 Mext_checked_resource(RFC) = 0 Mint_checked_resource(HTTP) = 0 Mext_checked_resource(HTTP) = 0 Mreport = >< Maction = 0 Mtab_name = >< MattachedVm = no VM M MThIErrHandle: current request: M M-IN-- sender_id ?tid-1wp_ca_blk-1wp_id -1 M-IN-- action-uid-1appc_ca_blk -1type- M-IN-- new_statNO_CHANGEmode 255len0rq_id -1 M M***************************************************************************** M* M*LOCATIONSAP-Server EXSAPDQAS_SEQ_03 on host EXSAPDQAS (wp 1) M*ERRORThInit: db_connect M* M*TIMEThu Jun 15 15:22:58 2017 M*RELEASE721 M*COMPONENTTaskhandler M*VERSION1 M*RC13 M*MODULEthxxhead.c M*LINE11979 M*COUNTER1 M* M***************************************************************************** M MPfStatDisconnect: disconnect statistics MEntering TH_CALLHOOKS MThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP MThCallHooks: hook >ThrBtcCallLgCl< o.k. MThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP M*** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c870] M*** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c302] MThIErrHandle: entering ThSetStatError MThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0) MEntering ThReadDetachMode Mcall ThrShutDown (1)... Bdbtbxbuf: Buffer TBX_SINGLE not available M***LOG Q02=> wp_halt, WPStop (Workp. 1 14596) [dpnttool.c340] --------------------------------------------------- trc file: "dev_w1", trc level: 1, release: "721" --------------------------------------------------- * *ACTIVE TRACE LEVEL1 *ACTIVE TRACE COMPONENTSall, MJ * M sysno03 M sidSEQ M systemid562 (PC with Windows NT) M relno7210 M patchlevel 0 M patchno800 M intno20020600 M makemultithreaded, Unicode, 64 bit, optimized M profile\\EXSAPDQAS\sapmnt\SEQ\SYS\profile\SEQ_DVEBMGS03_EXSAPDQAS M pid8676 M Mkernel runs with dp version 150000(ext=125000) (@(#) DPLIB-INT-VERSION-150000-UC) Mlength of sys_adm_ext is 596 bytes M***LOG Q0Q=> tskh_init, WPStart (Workp. 1 8676) [dpxxdisp.c1380] IMtxInit: 1 0 0 MDpSysAdmExtCreate: ABAP is active MDpSysAdmExtCreate: VMC (JAVA VM in WP) is active MDpIPCInit2: read dp-profile-values from sys_adm_ext MDpShMCreate: sizeof(wp_adm)48800-2568 MDpShMCreate: sizeof(tm_adm)5824176-28976 MDpShMCreate: sizeof(wp_ca_adm)64000-64 MDpShMCreate: sizeof(appc_ca_adm)64000-64 MDpCommTableSize: max/headSize/ftSize/tableSize=500/16/1464064/1464080 MDpShMCreate: sizeof(comm_adm)1464080-2904 MDpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=512/48/163904/96560/260512 MDpShMCreate: sizeof(slock_adm)260512-296 MDpFileTableSize: max/headSize/ftSize/tableSize=3800/16/364864/364880 MDpShMCreate: sizeof(file_adm)364880-80 MDpShMCreate: sizeof(vmc_adm)41040-2160 MDpShMCreate: sizeof(wall_adm)(41664/42896/64/192) MDpShMCreate: sizeof(gw_adm)48 MDpShMCreate: sizeof(j2ee_adm)3952 MDpShMCreate: SHM_DP_ADM_KEY(addr: 0000000010220050, size: 8234368) MDpShMCreate: allocated sys_adm at 0000000010220060 MDpShMCreate: allocated wp_adm_list at 00000000102230E0 MDpShMCreate: allocated wp_adm at 00000000102232D0 MDpShMCreate: allocated tm_adm_list at 000000001022F180 MDpShMCreate: allocated tm_adm at 000000001022F1D0 MDpShMCreate: allocated wp_ca_adm at 00000000107BD090 MDpShMCreate: allocated appc_ca_adm at 00000000107CCAA0 MDpShMCreate: allocated comm_adm at 00000000107DC4B0 MDpShMCreate: allocated slock_adm at 0000000010941BD0 MDpShMCreate: allocated file_adm at 0000000010981580 MDpShMCreate: allocated vmc_adm_list at 00000000109DA6E0 MDpShMCreate: allocated vmc_adm at 00000000109DA790 MDpShMCreate: allocated gw_adm at 00000000109E47F0 MDpShMCreate: allocated j2ee_adm at 00000000109E4830 MDpShMCreate: allocated ca_info at 00000000109E57B0 MDpShMCreate: allocated wall_adm at 00000000109E5840 MDpCommAttachTable: attached comm table (header=00000000107DC4B0/ft=00000000107DC4C0) MDpSesCreateTable: attached session table at 00000000025B0050 (len=167472) MDpRqQInit: use protect_queue / slots_per_queue 0 / 2001 from sys_adm M M Thu Jun 15 15:24:29 2017 Mrdisp/queue_size_check_value :-> on,50,30,40,500,50,500,80 XEmInit: MmSetImplementation( 2 ). XMM global diagnostic options set: 0 X<ES> client 1 initializing .... X<ES> EsILock: use Mutex for locking XUsing implementation view X<EsNT> Using memory model view. M<EsNT> Memory Reset disabled as NT default XES initialized. Xmm.dump: set maximum dump mem to 192 MB Xmm.dump: set global maximum dump mem to 192 MB XEsRegisterEmCheck: Register EmGetEsHandles at 00000001408B1FF0 XEs2ResCreate: Changed resource parameters to XfilenamePrefix = XblockSizeKB= 1024 KB XinitialSizeMB= 240 MB XextendSizeMB= 120 MB XmaxSizeMB= 5640 MB MDpVmcSetActive: set vmc state DP_VMC_ENABLED MDpVmcSetActive: set vmc state DP_VMC_ACTIVE MDpVmcInit2: o.k. MThStart: taskhandler started MThTHPInit: thp initialized MThInit: initializing DIA work process W1 M M Thu Jun 15 15:24:33 2017 MThInit: running on host EXSAPDQAS IMtxInit: 1 0 0 Mcalling db_connect ... BLoading DB library 'G:\usr\sap\SEQ\DVEBMGS03\exe\dboraslib.dll' ... BLibrary 'G:\usr\sap\SEQ\DVEBMGS03\exe\dboraslib.dll' loaded BVersion of 'G:\usr\sap\SEQ\DVEBMGS03\exe\dboraslib.dll' is "721.02", patchlevel (0.800) Cdbs/ora/stmt_cache_size = 250 CPrepending G:\usr\sap\SEQ\DVEBMGS03\exe to Path. CRegister application info. COracle client version: 11.2.0.3.0, (dbsl 721 290916, UNICODE[2]) CDetailed Oracle client (patch) info not available. CClient NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16' CLogon as OPS$-user to get SAPSR3's password CConnecting as /@SEQ on connection 0 (nls 0) ... (dbsl 721 290916, UNICODE[2]) COCIHandleAlloc(con=0): Service svc=09C08DD0 created, rc=0 C C Thu Jun 15 15:24:58 2017 COCIServerAttach(con=0, svc=09C08DD0): New server hdl. srv=09C09720 attached to 'SEQ' COCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: CORA-01017: invalid username/password; logon denied COCISessionBegin(con=0, svc=09C08DD0, srv=09C09720='SEQ'): start session usr=09C189B0='/', rc=1017 COCIHandleFree(con=0, svc=09C08DD0): Free session hdl usr=09C189B0 COCIServerDetach(stale2 con=0, svc=09C08DD0, srv=09C09720='SEQ') successfully detached COCIHandleFree(con=0, svc=09C08DD0): Server handle srv=09C09720 freed COCIHandleFree(con=0): Service svc=09C08DD0 freed (i=0). Crc=1017 -> Trying to reattach to server 'SEQ' COCIHandleAlloc(con=0): Service svc=09C08DD0 created, rc=0 C C Thu Jun 15 15:25:33 2017 COCIServerAttach(con=0, svc=09C08DD0): New server hdl. srv=09C09720 attached to 'SEQ' COCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: CORA-01017: invalid username/password; logon denied COCISessionBegin(con=0, svc=09C08DD0, srv=09C09720='SEQ'): start session usr=09C132A8='/', rc=1017 COCIHandleFree(con=0, svc=09C08DD0): Free session hdl usr=09C132A8 COCIServerDetach(stale2 con=0, svc=09C08DD0, srv=09C09720='SEQ') successfully detached COCIHandleFree(con=0, svc=09C08DD0): Server handle srv=09C09720 freed COCIHandleFree(con=0): Service svc=09C08DD0 freed (i=1). C*** ERROR => CONNECT failed with SQL error '1017' [dbsloci.c16098] CInfo: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password. CConnecting as SAPSR3/<pwd>@SEQ on connection 0 (nls 0) ... (dbsl 721 290916, UNICODE[2]) COCIHandleAlloc(con=0): Service svc=09C08DD0 created, rc=0 C C Thu Jun 15 15:26:07 2017 COCIServerAttach(con=0, svc=09C08DD0): New server hdl. srv=09C09720 attached to 'SEQ' C C Thu Jun 15 15:26:29 2017 COCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: CORA-01017: invalid username/password; logon denied COCISessionBegin(con=0, svc=09C08DD0, srv=09C09720='SEQ'): start session usr=09C132A8='SAPSR3', rc=1017 COCIHandleFree(con=0, svc=09C08DD0): Free session hdl usr=09C132A8 COCIServerDetach(stale2 con=0, svc=09C08DD0, srv=09C09720='SEQ') successfully detached COCIHandleFree(con=0, svc=09C08DD0): Server handle srv=09C09720 freed COCIHandleFree(con=0): Service svc=09C08DD0 freed (i=0). Crc=1017 -> Trying to reattach to server 'SEQ' COCIHandleAlloc(con=0): Service svc=09C08DD0 created, rc=0 C C Thu Jun 15 15:26:42 2017 COCIServerAttach(con=0, svc=09C08DD0): New server hdl. srv=09C09720 attached to 'SEQ' C C Thu Jun 15 15:28:28 2017 COCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: CORA-01017: invalid username/password; logon denied COCISessionBegin(con=0, svc=09C08DD0, srv=09C09720='SEQ'): start session usr=09C132A8='SAPSR3', rc=1017 COCIHandleFree(con=0, svc=09C08DD0): Free session hdl usr=09C132A8 COCIServerDetach(stale2 con=0, svc=09C08DD0, srv=09C09720='SEQ') successfully detached COCIHandleFree(con=0, svc=09C08DD0): Server handle srv=09C09720 freed COCIHandleFree(con=0): Service svc=09C08DD0 freed (i=1). C*** ERROR => CONNECT failed with SQL error '1017' [dbsloci.c16098] B***LOG BY2=> sql error 1017performing CON [dbsh1246] B***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh1246] B***LOG BY2=> sql error 1017performing CON [dblink544] B***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink544] M***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c1559] Min_ThErrHandle: 1 M*** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c11698] M MInfo for wp 1 M Mpid = 8676 Mseverity = 0 Mstatus = 0 Mstat = WP_NEW Mwaiting_for = NO_WAITING Mreqtype = DP_RQ_DIAWP Mact_reqtype = NO_REQTYPE Mreq.req_info = Mreq.tid = -1 Mreq.uid = 4294967295 Mreq.mode = 255 Mreq.len = 0 Mreq.rq_id = 65535 Mreq.rq_source = Mreq.vm = no VM Mlast_tid = 0 Mlast_uid = 0 Mlast_mode = 0 Mlocked semaphores (), locking () Mact_cs_count = 1 McsTrack = 0 McsTrackRwExcl = 0 McsTrackRwShrd = 0 Mmode_cleaned_counter = 0 Mcontrol_flag = 0 Mint_checked_resource(RFC) = 0 Mext_checked_resource(RFC) = 0 Mint_checked_resource(HTTP) = 0 Mext_checked_resource(HTTP) = 0 Mreport = >< Maction = 0 Mtab_name = >< MattachedVm = no VM M MThIErrHandle: current request: M M-IN-- sender_id ?tid-1wp_ca_blk-1wp_id -1 M-IN-- action-uid-1appc_ca_blk -1type- M-IN-- new_statNO_CHANGEmode 255len0rq_id -1 M M***************************************************************************** M* M*LOCATIONSAP-Server EXSAPDQAS_SEQ_03 on host EXSAPDQAS (wp 1) M*ERRORThInit: db_connect M* M*TIMEThu Jun 15 15:28:28 2017 M*RELEASE721 M*COMPONENTTaskhandler M*VERSION1 M*RC13 M*MODULEthxxhead.c M*LINE11979 M*COUNTER1 M* M***************************************************************************** M MPfStatDisconnect: disconnect statistics MEntering TH_CALLHOOKS MThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP MThCallHooks: hook >ThrBtcCallLgCl< o.k. MThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP M*** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c870] M*** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c302] MThIErrHandle: entering ThSetStatError MThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0) MEntering ThReadDetachMode Mcall ThrShutDown (1)... Bdbtbxbuf: Buffer TBX_SINGLE not available M***LOG Q02=> wp_halt, WPStop (Workp. 1 8676) [dpnttool.c340] --------------------------------------------------- trc file: "dev_w1", trc level: 1, release: "721" --------------------------------------------------- * *ACTIVE TRACE LEVEL1 *ACTIVE TRACE COMPONENTSall, MJ * M sysno03 M sidSEQ M systemid562 (PC with Windows NT) M relno7210 M patchlevel 0 M patchno800 M intno20020600 M makemultithreaded, Unicode, 64 bit, optimized M profile\\EXSAPDQAS\sapmnt\SEQ\SYS\profile\SEQ_DVEBMGS03_EXSAPDQAS M pid6152 M Mkernel runs with dp version 150000(ext=125000) (@(#) DPLIB-INT-VERSION-150000-UC) Mlength of sys_adm_ext is 596 bytes M***LOG Q0Q=> tskh_init, WPStart (Workp. 1 6152) [dpxxdisp.c1380] IMtxInit: 1 0 0 MDpSysAdmExtCreate: ABAP is active MDpSysAdmExtCreate: VMC (JAVA VM in WP) is active MDpIPCInit2: read dp-profile-values from sys_adm_ext MDpShMCreate: sizeof(wp_adm)48800-2568 MDpShMCreate: sizeof(tm_adm)5824176-28976 MDpShMCreate: sizeof(wp_ca_adm)64000-64 MDpShMCreate: sizeof(appc_ca_adm)64000-64 MDpCommTableSize: max/headSize/ftSize/tableSize=500/16/1464064/1464080 MDpShMCreate: sizeof(comm_adm)1464080-2904 MDpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=512/48/163904/96560/260512 MDpShMCreate: sizeof(slock_adm)260512-296 MDpFileTableSize: max/headSize/ftSize/tableSize=3800/16/364864/364880 MDpShMCreate: sizeof(file_adm)364880-80 MDpShMCreate: sizeof(vmc_adm)41040-2160 MDpShMCreate: sizeof(wall_adm)(41664/42896/64/192) MDpShMCreate: sizeof(gw_adm)48 MDpShMCreate: sizeof(j2ee_adm)3952 MDpShMCreate: SHM_DP_ADM_KEY(addr: 0000000010040050, size: 8234368) MDpShMCreate: allocated sys_adm at 0000000010040060 MDpShMCreate: allocated wp_adm_list at 00000000100430E0 MDpShMCreate: allocated wp_adm at 00000000100432D0 MDpShMCreate: allocated tm_adm_list at 000000001004F180 MDpShMCreate: allocated tm_adm at 000000001004F1D0 MDpShMCreate: allocated wp_ca_adm at 00000000105DD090 MDpShMCreate: allocated appc_ca_adm at 00000000105ECAA0 MDpShMCreate: allocated comm_adm at 00000000105FC4B0 MDpShMCreate: allocated slock_adm at 0000000010761BD0 MDpShMCreate: allocated file_adm at 00000000107A1580 MDpShMCreate: allocated vmc_adm_list at 00000000107FA6E0 MDpShMCreate: allocated vmc_adm at 00000000107FA790 MDpShMCreate: allocated gw_adm at 00000000108047F0 MDpShMCreate: allocated j2ee_adm at 0000000010804830 MDpShMCreate: allocated ca_info at 00000000108057B0 MDpShMCreate: allocated wall_adm at 0000000010805840 MDpCommAttachTable: attached comm table (header=00000000105FC4B0/ft=00000000105FC4C0) MDpSesCreateTable: attached session table at 0000000002EB0050 (len=167472) MDpRqQInit: use protect_queue / slots_per_queue 0 / 2001 from sys_adm Mrdisp/queue_size_check_value :-> on,50,30,40,500,50,500,80 XEmInit: MmSetImplementation( 2 ). XMM global diagnostic options set: 0 X<ES> client 1 initializing .... X<ES> EsILock: use Mutex for locking XUsing implementation view X<EsNT> Using memory model view. M<EsNT> Memory Reset disabled as NT default XES initialized. Xmm.dump: set maximum dump mem to 192 MB Xmm.dump: set global maximum dump mem to 192 MB XEsRegisterEmCheck: Register EmGetEsHandles at 00000001408B1FF0 XEs2ResCreate: Changed resource parameters to XfilenamePrefix = XblockSizeKB= 1024 KB XinitialSizeMB= 240 MB XextendSizeMB= 120 MB XmaxSizeMB= 5640 MB MDpVmcSetActive: set vmc state DP_VMC_ENABLED MDpVmcSetActive: set vmc state DP_VMC_ACTIVE MDpVmcInit2: o.k. M M Thu Jun 15 15:29:29 2017 MThStart: taskhandler started MThTHPInit: thp initialized MThInit: initializing DIA work process W1 M M Thu Jun 15 15:29:30 2017 MThInit: running on host EXSAPDQAS IMtxInit: 1 0 0 M M Thu Jun 15 15:29:33 2017 Mcalling db_connect ... BLoading DB library 'G:\usr\sap\SEQ\DVEBMGS03\exe\dboraslib.dll' ... BLibrary 'G:\usr\sap\SEQ\DVEBMGS03\exe\dboraslib.dll' loaded BVersion of 'G:\usr\sap\SEQ\DVEBMGS03\exe\dboraslib.dll' is "721.02", patchlevel (0.800) Cdbs/ora/stmt_cache_size = 250 CPrepending G:\usr\sap\SEQ\DVEBMGS03\exe to Path. CRegister application info. COracle client version: 11.2.0.3.0, (dbsl 721 290916, UNICODE[2]) CDetailed Oracle client (patch) info not available. CClient NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16' CLogon as OPS$-user to get SAPSR3's password CConnecting as /@SEQ on connection 0 (nls 0) ... (dbsl 721 290916, UNICODE[2]) COCIHandleAlloc(con=0): Service svc=09B38DD0 created, rc=0 C C Thu Jun 15 15:29:40 2017 COCIServerAttach(con=0, svc=09B38DD0): New server hdl. srv=09B39720 attached to 'SEQ' COCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: CORA-01017: invalid username/password; logon denied COCISessionBegin(con=0, svc=09B38DD0, srv=09B39720='SEQ'): start session usr=09B489B0='/', rc=1017 COCIHandleFree(con=0, svc=09B38DD0): Free session hdl usr=09B489B0 COCIServerDetach(stale2 con=0, svc=09B38DD0, srv=09B39720='SEQ') successfully detached COCIHandleFree(con=0, svc=09B38DD0): Server handle srv=09B39720 freed COCIHandleFree(con=0): Service svc=09B38DD0 freed (i=0). Crc=1017 -> Trying to reattach to server 'SEQ' COCIHandleAlloc(con=0): Service svc=09B38DD0 created, rc=0 C C Thu Jun 15 15:30:17 2017 COCIServerAttach(con=0, svc=09B38DD0): New server hdl. srv=09B39720 attached to 'SEQ' COCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: CORA-01017: invalid username/password; logon denied COCISessionBegin(con=0, svc=09B38DD0, srv=09B39720='SEQ'): start session usr=09B432A8='/', rc=1017 COCIHandleFree(con=0, svc=09B38DD0): Free session hdl usr=09B432A8 COCIServerDetach(stale2 con=0, svc=09B38DD0, srv=09B39720='SEQ') successfully detached COCIHandleFree(con=0, svc=09B38DD0): Server handle srv=09B39720 freed COCIHandleFree(con=0): Service svc=09B38DD0 freed (i=1). C*** ERROR => CONNECT failed with SQL error '1017' [dbsloci.c16098] CInfo: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password. CConnecting as SAPSR3/<pwd>@SEQ on connection 0 (nls 0) ... (dbsl 721 290916, UNICODE[2]) COCIHandleAlloc(con=0): Service svc=09B38DD0 created, rc=0 C C Thu Jun 15 15:30:54 2017 COCIServerAttach(con=0, svc=09B38DD0): New server hdl. srv=09B39720 attached to 'SEQ' C C Thu Jun 15 15:31:19 2017 COCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: CORA-01017: invalid username/password; logon denied COCISessionBegin(con=0, svc=09B38DD0, srv=09B39720='SEQ'): start session usr=09B432A8='SAPSR3', rc=1017 COCIHandleFree(con=0, svc=09B38DD0): Free session hdl usr=09B432A8 COCIServerDetach(stale2 con=0, svc=09B38DD0, srv=09B39720='SEQ') successfully detached COCIHandleFree(con=0, svc=09B38DD0): Server handle srv=09B39720 freed COCIHandleFree(con=0): Service svc=09B38DD0 freed (i=0). Crc=1017 -> Trying to reattach to server 'SEQ' COCIHandleAlloc(con=0): Service svc=09B38DD0 created, rc=0 C C Thu Jun 15 15:31:31 2017 COCIServerAttach(con=0, svc=09B38DD0): New server hdl. srv=09B39720 attached to 'SEQ' C C Thu Jun 15 15:33:32 2017 COCISessionBegin(OCI_DEFAULT) failed with SQL error 3113: CORA-03113: end-of-file on communication channel COCISessionBegin(con=0, svc=09B38DD0, srv=09B39720='SEQ'): start session usr=09B432A8='SAPSR3', rc=3113 COCIHandleFree(con=0, svc=09B38DD0): Free session hdl usr=09B432A8 COCIServerDetach(stale2 con=0, svc=09B38DD0, srv=09B39720='SEQ') successfully detached COCIHandleFree(con=0, svc=09B38DD0): Server handle srv=09B39720 freed COCIHandleFree(con=0): Service svc=09B38DD0 freed (i=1). C*** ERROR => CONNECT failed with SQL error '3113' [dbsloci.c16098] B***LOG BV3=> severe db error 3113; work process is stopped [dbsh1241] B***LOG BY2=> sql error 3113performing CON [dblink544] B***LOG BY0=> ORA-03113: end-of-file on communication channel [dblink544] M***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c1559] Min_ThErrHandle: 1 M*** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c11698] M MInfo for wp 1 M Mpid = 6152 Mseverity = 0 Mstatus = 0 Mstat = WP_NEW Mwaiting_for = NO_WAITING Mreqtype = DP_RQ_DIAWP Mact_reqtype = NO_REQTYPE Mreq.req_info = Mreq.tid = -1 Mreq.uid = 4294967295 Mreq.mode = 255 Mreq.len = 0 Mreq.rq_id = 65535 Mreq.rq_source = Mreq.vm = no VM Mlast_tid = 0 Mlast_uid = 0 Mlast_mode = 0 Mlocked semaphores (), locking () Mact_cs_count = 1 McsTrack = 0 McsTrackRwExcl = 0 McsTrackRwShrd = 0 Mmode_cleaned_counter = 0 Mcontrol_flag = 0 Mint_checked_resource(RFC) = 0 Mext_checked_resource(RFC) = 0 Mint_checked_resource(HTTP) = 0 Mext_checked_resource(HTTP) = 0 Mreport = >< Maction = 0 Mtab_name = >< MattachedVm = no VM M MThIErrHandle: current request: M M-IN-- sender_id ?tid-1wp_ca_blk-1wp_id -1 M-IN-- action-uid-1appc_ca_blk -1type- M-IN-- new_statNO_CHANGEmode 255len0rq_id -1 M M***************************************************************************** M* M*LOCATIONSAP-Server EXSAPDQAS_SEQ_03 on host EXSAPDQAS (wp 1) M*ERRORThInit: db_connect M* M*TIMEThu Jun 15 15:33:32 2017 M*RELEASE721 M*COMPONENTTaskhandler M*VERSION1 M*RC13 M*MODULEthxxhead.c M*LINE11979 M*COUNTER1 M* M***************************************************************************** M MPfStatDisconnect: disconnect statistics MEntering TH_CALLHOOKS MThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP MThCallHooks: hook >ThrBtcCallLgCl< o.k. MThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP M*** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c870] M*** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c302] MThIErrHandle: entering ThSetStatError MThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0) MEntering ThReadDetachMode Mcall ThrShutDown (1)... Bdbtbxbuf: Buffer TBX_SINGLE not available M***LOG Q02=> wp_halt, WPStop (Workp. 1 6152) [dpnttool.c340] --------------------------------------------------- trc file: "dev_w1", trc level: 1, release: "721" --------------------------------------------------- * *ACTIVE TRACE LEVEL1 *ACTIVE TRACE COMPONENTSall, MJ * M sysno03 M sidSEQ M systemid562 (PC with Windows NT) M relno7210 M patchlevel 0 M patchno800 M intno20020600 M makemultithreaded, Unicode, 64 bit, optimized M profile\\EXSAPDQAS\sapmnt\SEQ\SYS\profile\SEQ_DVEBMGS03_EXSAPDQAS M pid11584 M Mkernel runs with dp version 150000(ext=125000) (@(#) DPLIB-INT-VERSION-150000-UC) Mlength of sys_adm_ext is 596 bytes M***LOG Q0Q=> tskh_init, WPStart (Workp. 1 11584) [dpxxdisp.c1380] IMtxInit: 1 0 0 MDpSysAdmExtCreate: ABAP is active MDpSysAdmExtCreate: VMC (JAVA VM in WP) is active MDpIPCInit2: read dp-profile-values from sys_adm_ext MDpShMCreate: sizeof(wp_adm)48800-2568 MDpShMCreate: sizeof(tm_adm)5824176-28976 MDpShMCreate: sizeof(wp_ca_adm)64000-64 MDpShMCreate: sizeof(appc_ca_adm)64000-64 MDpCommTableSize: max/headSize/ftSize/tableSize=500/16/1464064/1464080 MDpShMCreate: sizeof(comm_adm)1464080-2904 MDpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=512/48/163904/96560/260512 MDpShMCreate: sizeof(slock_adm)260512-296 MDpFileTableSize: max/headSize/ftSize/tableSize=3800/16/364864/364880 MDpShMCreate: sizeof(file_adm)364880-80 MDpShMCreate: sizeof(vmc_adm)41040-2160 MDpShMCreate: sizeof(wall_adm)(41664/42896/64/192) MDpShMCreate: sizeof(gw_adm)48 MDpShMCreate: sizeof(j2ee_adm)3952 MDpShMCreate: SHM_DP_ADM_KEY(addr: 000000000FFA0050, size: 8234368) MDpShMCreate: allocated sys_adm at 000000000FFA0060 MDpShMCreate: allocated wp_adm_list at 000000000FFA30E0 MDpShMCreate: allocated wp_adm at 000000000FFA32D0 MDpShMCreate: allocated tm_adm_list at 000000000FFAF180 MDpShMCreate: allocated tm_adm at 000000000FFAF1D0 MDpShMCreate: allocated wp_ca_adm at 000000001053D090 MDpShMCreate: allocated appc_ca_adm at 000000001054CAA0 MDpShMCreate: allocated comm_adm at 000000001055C4B0 MDpShMCreate: allocated slock_adm at 00000000106C1BD0 MDpShMCreate: allocated file_adm at 0000000010701580 MDpShMCreate: allocated vmc_adm_list at 000000001075A6E0 MDpShMCreate: allocated vmc_adm at 000000001075A790 MDpShMCreate: allocated gw_adm at 00000000107647F0 MDpShMCreate: allocated j2ee_adm at 0000000010764830 MDpShMCreate: allocated ca_info at 00000000107657B0 MDpShMCreate: allocated wall_adm at 0000000010765840 MDpCommAttachTable: attached comm table (header=000000001055C4B0/ft=000000001055C4C0) MDpSesCreateTable: attached session table at 00000000025B0050 (len=167472) MDpRqQInit: use protect_queue / slots_per_queue 0 / 2001 from sys_adm Mrdisp/queue_size_check_value :-> on,50,30,40,500,50,500,80 XEmInit: MmSetImplementation( 2 ). XMM global diagnostic options set: 0 X<ES> client 1 initializing .... X<ES> EsILock: use Mutex for locking XUsing implementation view X<EsNT> Using memory model view. M<EsNT> Memory Reset disabled as NT default XES initialized. Xmm.dump: set maximum dump mem to 192 MB Xmm.dump: set global maximum dump mem to 192 MB XEsRegisterEmCheck: Register EmGetEsHandles at 00000001408B1FF0 XEs2ResCreate: Changed resource parameters to XfilenamePrefix = XblockSizeKB= 1024 KB XinitialSizeMB= 240 MB XextendSizeMB= 120 MB XmaxSizeMB= 5640 MB MDpVmcSetActive: set vmc state DP_VMC_ENABLED MDpVmcSetActive: set vmc state DP_VMC_ACTIVE MDpVmcInit2: o.k. MThStart: taskhandler started MThTHPInit: thp initialized MThInit: initializing DIA work process W1 M M Thu Jun 15 15:34:32 2017 MThInit: running on host EXSAPDQAS IMtxInit: 1 0 0 M M Thu Jun 15 15:34:33 2017 Mcalling db_connect ... BLoading DB library 'G:\usr\sap\SEQ\DVEBMGS03\exe\dboraslib.dll' ... BLibrary 'G:\usr\sap\SEQ\DVEBMGS03\exe\dboraslib.dll' loaded BVersion of 'G:\usr\sap\SEQ\DVEBMGS03\exe\dboraslib.dll' is "721.02", patchlevel (0.800) Cdbs/ora/stmt_cache_size = 250 CPrepending G:\usr\sap\SEQ\DVEBMGS03\exe to Path. CRegister application info. COracle client version: 11.2.0.3.0, (dbsl 721 290916, UNICODE[2]) CDetailed Oracle client (patch) info not available. CClient NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16' CLogon as OPS$-user to get SAPSR3's password CConnecting as /@SEQ on connection 0 (nls 0) ... (dbsl 721 290916, UNICODE[2]) COCIHandleAlloc(con=0): Service svc=09B08DD0 created, rc=0 C C Thu Jun 15 15:34:49 2017 COCIServerAttach(con=0, svc=09B08DD0): New server hdl. srv=09B09720 attached to 'SEQ' COCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: CORA-01017: invalid username/password; logon denied COCISessionBegin(con=0, svc=09B08DD0, srv=09B09720='SEQ'): start session usr=09B189B0='/', rc=1017 COCIHandleFree(con=0, svc=09B08DD0): Free session hdl usr=09B189B0 COCIServerDetach(stale2 con=0, svc=09B08DD0, srv=09B09720='SEQ') successfully detached COCIHandleFree(con=0, svc=09B08DD0): Server handle srv=09B09720 freed COCIHandleFree(con=0): Service svc=09B08DD0 freed (i=0). Crc=1017 -> Trying to reattach to server 'SEQ' COCIHandleAlloc(con=0): Service svc=09B08DD0 created, rc=0 C C Thu Jun 15 15:35:07 2017 COCIServerAttach(con=0, svc=09B08DD0): New server hdl. srv=09B09720 attached to 'SEQ' COCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: CORA-01017: invalid username/password; logon denied COCISessionBegin(con=0, svc=09B08DD0, srv=09B09720='SEQ'): start session usr=09B132A8='/', rc=1017 COCIHandleFree(con=0, svc=09B08DD0): Free session hdl usr=09B132A8 COCIServerDetach(stale2 con=0, svc=09B08DD0, srv=09B09720='SEQ') successfully detached COCIHandleFree(con=0, svc=09B08DD0): Server handle srv=09B09720 freed COCIHandleFree(con=0): Service svc=09B08DD0 freed (i=1). C*** ERROR => CONNECT failed with SQL error '1017' [dbsloci.c16098] CInfo: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password. CConnecting as SAPSR3/<pwd>@SEQ on connection 0 (nls 0) ... (dbsl 721 290916, UNICODE[2]) COCIHandleAlloc(con=0): Service svc=09B08DD0 created, rc=0 C C Thu Jun 15 15:35:26 2017 COCIServerAttach(con=0, svc=09B08DD0): New server hdl. srv=09B09720 attached to 'SEQ' C C Thu Jun 15 15:37:20 2017 COCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: CORA-01017: invalid username/password; logon denied COCISessionBegin(con=0, svc=09B08DD0, srv=09B09720='SEQ'): start session usr=09B132A8='SAPSR3', rc=1017 COCIHandleFree(con=0, svc=09B08DD0): Free session hdl usr=09B132A8 COCIServerDetach(stale2 con=0, svc=09B08DD0, srv=09B09720='SEQ') successfully detached COCIHandleFree(con=0, svc=09B08DD0): Server handle srv=09B09720 freed COCIHandleFree(con=0): Service svc=09B08DD0 freed (i=0). Crc=1017 -> Trying to reattach to server 'SEQ' COCIHandleAlloc(con=0): Service svc=09B08DD0 created, rc=0 C C Thu Jun 15 15:37:22 2017 COCIServerAttach(con=0, svc=09B08DD0): New server hdl. srv=09B09720 attached to 'SEQ' C C Thu Jun 15 15:38:50 2017 COCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: CORA-01017: invalid username/password; logon denied COCISessionBegin(con=0, svc=09B08DD0, srv=09B09720='SEQ'): start session usr=09B132A8='SAPSR3', rc=1017 COCIHandleFree(con=0, svc=09B08DD0): Free session hdl usr=09B132A8 COCIServerDetach(stale2 con=0, svc=09B08DD0, srv=09B09720='SEQ') successfully detached COCIHandleFree(con=0, svc=09B08DD0): Server handle srv=09B09720 freed COCIHandleFree(con=0): Service svc=09B08DD0 freed (i=1). C*** ERROR => CONNECT failed with SQL error '1017' [dbsloci.c16098] B***LOG BY2=> sql error 1017performing CON [dbsh1246] B***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh1246] B***LOG BY2=> sql error 1017performing CON [dblink544] B***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink544] M***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c1559] Min_ThErrHandle: 1 M*** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c11698] M MInfo for wp 1 M Mpid = 11584 Mseverity = 0 Mstatus = 0 Mstat = WP_NEW Mwaiting_for = NO_WAITING Mreqtype = DP_RQ_DIAWP Mact_reqtype = NO_REQTYPE Mreq.req_info = Mreq.tid = -1 Mreq.uid = 4294967295 Mreq.mode = 255 Mreq.len = 0 Mreq.rq_id = 65535 Mreq.rq_source = Mreq.vm = no VM Mlast_tid = 0 Mlast_uid = 0 Mlast_mode = 0 Mlocked semaphores (), locking () Mact_cs_count = 1 McsTrack = 0 McsTrackRwExcl = 0 McsTrackRwShrd = 0 Mmode_cleaned_counter = 0 Mcontrol_flag = 0 Mint_checked_resource(RFC) = 0 Mext_checked_resource(RFC) = 0 Mint_checked_resource(HTTP) = 0 Mext_checked_resource(HTTP) = 0 Mreport = >< Maction = 0 Mtab_name = >< MattachedVm = no VM M MThIErrHandle: current request: M M-IN-- sender_id ?tid-1wp_ca_blk-1wp_id -1 M-IN-- action-uid-1appc_ca_blk -1type- M-IN-- new_statNO_CHANGEmode 255len0rq_id -1 M M***************************************************************************** M* M*LOCATIONSAP-Server EXSAPDQAS_SEQ_03 on host EXSAPDQAS (wp 1) M*ERRORThInit: db_connect M* M*TIMEThu Jun 15 15:38:50 2017 M*RELEASE721 M*COMPONENTTaskhandler M*VERSION1 M*RC13 M*MODULEthxxhead.c M*LINE11979 M*COUNTER1 M* M***************************************************************************** M MPfStatDisconnect: disconnect statistics MEntering TH_CALLHOOKS MThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP MThCallHooks: hook >ThrBtcCallLgCl< o.k. MThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP M*** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c870] M*** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c302] MThIErrHandle: entering ThSetStatError MThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0) MEntering ThReadDetachMode Mcall ThrShutDown (1)... Bdbtbxbuf: Buffer TBX_SINGLE not available M***LOG Q02=> wp_halt, WPStop (Workp. 1 11584) [dpnttool.c340]

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Bartosz Jarkowski Jun 15, 2017 at 08:16 AM
1

Did you recently change the password to your SAPSR3 user?

*** ERROR => CONNECT failed with SQL error '1017' [dbsloci.c16098] CInfo: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password. CConnecting as SAPSR3/<pwd>@SEQ on connection 0 (nls 0) ... (dbsl 721 290916, UNICODE[2]) COCIHandleAlloc(con=0): Service svc=09AD8A90 created, rc=0 C C Thu Jun 15 15:20:43 2017 COCIServerAttach(con=0, svc=09AD8A90): New server hdl. srv=09AD9650 attached to 'SEQ' C C Thu Jun 15 15:20:45 2017 COCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: CORA-01017: invalid username/password;

Best regards

Bartosz

Share
10 |10000 characters needed characters left characters exceeded
Reagan Benjamin
Jun 16, 2017 at 12:33 PM
1

>>C*** ERROR => CONNECT failed with SQL error '1017' [dbsloci.c16098] CInfo: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password. CConnecting as SAPSR3/<pwd>@SEQ on connection 0 (nls 0)<<

Update the password for the SAPSR3 user using BR*Tools.

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Benjamin,

I have updated the SAPSR3 password:

C:\Users\seqadm>brconnect -c -p initSEQ.sap -l E -f chpass -o SAPSR3 -password E
xim123
BR0801I BRCONNECT 7.20 (42)

BR0280I BRCONNECT time stamp: 2017-08-09 14.54.14
BR0828I Changing password for database user SAPSR3 ...

BR0280I BRCONNECT time stamp: 2017-08-09 14.54.15
BR0829I Password changed successfully in database for user SAPSR3
BR0830I Password changed successfully in table EXIM-APPS.COM.MY\SEPADM.SAPUSER f
or user SAPSR3
BR0830I Password changed successfully in table OPS$EXSAPDQAS\SEQADM.SAPUSER for
user SAPSR3
BR0830I Password changed successfully in table OPS$EXSAPSRM\SEPADM.SAPUSER for u
ser SAPSR3
BR0830I Password changed successfully in table OPS$SAPEP\SEPADM.SAPUSER for user
SAPSR3

BR0280I BRCONNECT time stamp: 2017-08-09 14.54.15
BR0802I BRCONNECT completed successfully

But, the system still down.

dev_w* trace:


---------------------------------------------------
trc file: "dev_w12", trc level: 1, release: "721"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, MJ
*
M sysno 03
M sid SEQ
M systemid 562 (PC with Windows NT)
M relno 7210
M patchlevel 0
M patchno 800
M intno 20020600
M make multithreaded, Unicode, 64 bit, optimized
M profile \\EXSAPDQAS\sapmnt\SEQ\SYS\profile\SEQ_DVEBMGS03_EXSAPDQAS
M pid 8064
M
M kernel runs with dp version 150000(ext=125000) (@(#) DPLIB-INT-VERSION-150000-UC)
M length of sys_adm_ext is 596 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workp. 12 8064) [dpxxdisp.c 1380]
I MtxInit: 12 0 0
M DpSysAdmExtCreate: ABAP is active
M DpSysAdmExtCreate: VMC (JAVA VM in WP) is active
M
M Wed Aug 09 14:54:57 2017
M DpIPCInit2: read dp-profile-values from sys_adm_ext
M DpShMCreate: sizeof(wp_adm) 48800 (2568)
M DpShMCreate: sizeof(tm_adm) 5824176 (28976)
M DpShMCreate: sizeof(wp_ca_adm) 64000 (64)
M DpShMCreate: sizeof(appc_ca_adm) 64000 (64)
M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/1464064/1464080
M DpShMCreate: sizeof(comm_adm) 1464080 (2904)
M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=512/48/163904/96560/260512
M DpShMCreate: sizeof(slock_adm) 260512 (296)
M DpFileTableSize: max/headSize/ftSize/tableSize=3800/16/364864/364880
M DpShMCreate: sizeof(file_adm) 364880 (80)
M DpShMCreate: sizeof(vmc_adm) 41040 (2160)
M DpShMCreate: sizeof(wall_adm) (41664/42896/64/192)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: sizeof(j2ee_adm) 3952
M DpShMCreate: SHM_DP_ADM_KEY (addr: 00000000102B0050, size: 8234368)
M DpShMCreate: allocated sys_adm at 00000000102B0060
M DpShMCreate: allocated wp_adm_list at 00000000102B30E0
M DpShMCreate: allocated wp_adm at 00000000102B32D0
M DpShMCreate: allocated tm_adm_list at 00000000102BF180
M DpShMCreate: allocated tm_adm at 00000000102BF1D0
M DpShMCreate: allocated wp_ca_adm at 000000001084D090
M DpShMCreate: allocated appc_ca_adm at 000000001085CAA0
M DpShMCreate: allocated comm_adm at 000000001086C4B0
M DpShMCreate: allocated slock_adm at 00000000109D1BD0
M DpShMCreate: allocated file_adm at 0000000010A11580
M DpShMCreate: allocated vmc_adm_list at 0000000010A6A6E0
M DpShMCreate: allocated vmc_adm at 0000000010A6A790
M DpShMCreate: allocated gw_adm at 0000000010A747F0
M DpShMCreate: allocated j2ee_adm at 0000000010A74830
M DpShMCreate: allocated ca_info at 0000000010A757B0
M DpShMCreate: allocated wall_adm at 0000000010A75840
M DpCommAttachTable: attached comm table (header=000000001086C4B0/ft=000000001086C4C0)
M DpSesCreateTable: attached session table at 0000000003040050 (len=167472)
M DpRqQInit: use protect_queue / slots_per_queue 0 / 2001 from sys_adm
M rdisp/queue_size_check_value : -> on,50,30,40,500,50,500,80
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 12 initializing ....
X <ES> EsILock: use Mutex for locking
X Using implementation view
X <EsNT> Using memory model view.
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
X mm.dump: set maximum dump mem to 192 MB
X mm.dump: set global maximum dump mem to 192 MB
X EsRegisterEmCheck: Register EmGetEsHandles at 0000000140BE1FF0
X Es2ResCreate: Changed resource parameters to
X filenamePrefix =
X blockSizeKB = 1024 KB
X initialSizeMB = 240 MB
X extendSizeMB = 120 MB
X maxSizeMB = 5640 MB
M DpVmcSetActive: set vmc state DP_VMC_ENABLED
M DpVmcSetActive: set vmc state DP_VMC_ACTIVE
M DpVmcInit2: o.k.
M ThStart: taskhandler started
M ThTHPInit: thp initialized
M ThInit: initializing BTC work process W12
M
M Wed Aug 09 14:55:01 2017
M ThInit: running on host EXSAPDQAS
I MtxInit: 12 0 0
M
M Wed Aug 09 14:55:04 2017
M calling db_connect ...
B Loading DB library 'G:\usr\sap\SEQ\DVEBMGS03\exe\dboraslib.dll' ...
B Library 'G:\usr\sap\SEQ\DVEBMGS03\exe\dboraslib.dll' loaded
B Version of 'G:\usr\sap\SEQ\DVEBMGS03\exe\dboraslib.dll' is "721.02", patchlevel (0.800)
C dbs/ora/stmt_cache_size = 250
C Prepending G:\usr\sap\SEQ\DVEBMGS03\exe to Path.
C Register application info.
C Oracle client version: 11.2.0.3.0, (dbsl 721 290916, UNICODE[2])
C Detailed Oracle client (patch) info not available.
C
C Wed Aug 09 14:55:06 2017
C Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
C Logon as OPS$-user to get SAPSR3's password
C Connecting as /@SEQ on connection 0 (nls 0) ... (dbsl 721 290916, UNICODE[2])
C OCIHandleAlloc(con=0): Service svc=09CB8DD0 created, rc=0
C
C Wed Aug 09 14:55:41 2017
C OCIServerAttach(con=0, svc=09CB8DD0): New server hdl. srv=09CB9720 attached to 'SEQ'
C OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:
C ORA-01017: invalid username/password; logon denied
C OCISessionBegin(con=0, svc=09CB8DD0, srv=09CB9720='SEQ'): start session usr=09CC89B0='/', rc=1017
C OCIHandleFree(con=0, svc=09CB8DD0): Free session hdl usr=09CC89B0
C OCIServerDetach(stale2 con=0, svc=09CB8DD0, srv=09CB9720='SEQ') successfully detached
C OCIHandleFree(con=0, svc=09CB8DD0): Server handle srv=09CB9720 freed
C OCIHandleFree(con=0): Service svc=09CB8DD0 freed (i=0).
C rc=1017 -> Trying to reattach to server 'SEQ'
C OCIHandleAlloc(con=0): Service svc=09CB8DD0 created, rc=0
C
C Wed Aug 09 14:56:20 2017
C OCIServerAttach(con=0, svc=09CB8DD0): New server hdl. srv=09CB9720 attached to 'SEQ'
C OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:
C ORA-01017: invalid username/password; logon denied
C OCISessionBegin(con=0, svc=09CB8DD0, srv=09CB9720='SEQ'): start session usr=09CC32A8='/', rc=1017
C OCIHandleFree(con=0, svc=09CB8DD0): Free session hdl usr=09CC32A8
C OCIServerDetach(stale2 con=0, svc=09CB8DD0, srv=09CB9720='SEQ') successfully detached
C OCIHandleFree(con=0, svc=09CB8DD0): Server handle srv=09CB9720 freed
C OCIHandleFree(con=0): Service svc=09CB8DD0 freed (i=1).
C *** ERROR => CONNECT failed with SQL error '1017'
[dbsloci.c 16098]
C Info: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password.
C Connecting as SAPSR3/<pwd>@SEQ on connection 0 (nls 0) ... (dbsl 721 290916, UNICODE[2])
C OCIHandleAlloc(con=0): Service svc=09CB8DD0 created, rc=0
C
C Wed Aug 09 14:56:59 2017
C OCIServerAttach(con=0, svc=09CB8DD0): New server hdl. srv=09CB9720 attached to 'SEQ'
C
C Wed Aug 09 14:58:26 2017
C OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:
C ORA-01017: invalid username/password; logon denied
C OCISessionBegin(con=0, svc=09CB8DD0, srv=09CB9720='SEQ'): start session usr=09CC32A8='SAPSR3', rc=1017
C OCIHandleFree(con=0, svc=09CB8DD0): Free session hdl usr=09CC32A8
C OCIServerDetach(stale2 con=0, svc=09CB8DD0, srv=09CB9720='SEQ') successfully detached
C OCIHandleFree(con=0, svc=09CB8DD0): Server handle srv=09CB9720 freed
C OCIHandleFree(con=0): Service svc=09CB8DD0 freed (i=0).
C rc=1017 -> Trying to reattach to server 'SEQ'
C OCIHandleAlloc(con=0): Service svc=09CB8DD0 created, rc=0
C
C Wed Aug 09 14:58:28 2017
C OCIServerAttach(con=0, svc=09CB8DD0): New server hdl. srv=09CB9720 attached to 'SEQ'

0

Hi

Please go through below sap note

https://launchpad.support.sap.com/#/notes/2324841/E

Regards,

Prithviraj

0

SAPSR3 user also is not lock:


SQL> select username, account_status from dba_users;

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SAPSR4DB OPEN
OPS$EXSAPSRM\SAPSERVICEJEP OPEN
OPS$EXSAPSRM\JEPADM OPEN
OPS$EXSAPDQAS\JEQADM OPEN
OPS$EXSAPDQAS\SAPSERVICEJEQ OPEN
SAPSR3DB OPEN
OPS$EXSAPDQAS\SAPSERVICESEQ OPEN
SAPSR3 OPEN
OPS$EXSAPSRM\SAPSERVICESEP OPEN
OPS$EXSAPDQAS\SEQADM OPEN
OPS$EXSAPSRM\SEPADM OPEN

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
DBSNMP LOCKED
APPQOSSYS EXPIRED & LOCKED
EXIM-APPS.COM.MY\SAPSERVICESEP OPEN
OPS$NT AUTHORITY\SYSTEM OPEN
OPS$SAPEP\SAPSERVICESR3 OPEN
OPS$SAPEP\SAPSERVICESEP OPEN
EXIM-APPS.COM.MY\SEPADM OPEN
OPS$SAPEP\SEPADM OPEN
SYS OPEN
SYSTEM OPEN
DIP EXPIRED

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
OUTLN LOCKED
ORACLE_OCM EXPIRED & LOCKED

24 rows selected.

SQL>

0
Zulfadzly Iqbal Mohmad Zulkafli Jun 16, 2017 at 02:42 AM
0

Hi Jarkowski,

This is my customer system and it has a long of history.
So, I am not sure whether they have changed SAPSR3 user before.
Anyway, how can I fix this issue?

Thanks,
Fadzly Iqbal

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Fadzly Iqbal,

In order for Bartosz to be notified of your reply, you need to submit it as a comment directly on his answer, i.e. click Comment on this answer at the bottom of his answer, not in the Your answer box.

In any case, it appears that Reagan has given you a pointer for how to proceed. Have you resolved this situation? If so, please come back and accept the correct answer, or provide your own solution if it was something different, and then close the question.

Cheers,
Matt

0
Reagan Benjamin
Aug 10, 2017 at 10:00 AM
0

I believe you did a system copy from SEP to SEQ. Drop the OPS$ users from the instance SEP. The table SAPUSER should be owned by the OPS$SEQADM user and not the user from the SEP system. Check note 400241 - Problems with ops$ or sapr3 connect to Oracle and 50088 - Creating OPS$ users on Windows NT/Oracle to create the SAPUSER table correctly. You should set up the system to use SSFS and not OPS$ mechanism.

Share
10 |10000 characters needed characters left characters exceeded