Skip to Content
-1

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

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]

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jun 15, 2017 at 08:16 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 16, 2017 at 12:33 PM

    >>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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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>

  • Jun 16, 2017 at 02:42 AM

    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

    Add comment
    10|10000 characters needed 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

  • Aug 10, 2017 at 10:00 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded