- SAP Community
- Products and Technology
- Technology
- Technology Q&A
- disp+work.EXE Running but Dialog Queue standstill ...
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
disp+work.EXE Running but Dialog Queue standstill [ORACLE]
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 06-15-2017 9:11 AM
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]
- SAP Managed Tags:
- Oracle Database,
- SAP NetWeaver
Accepted Solutions (0)
Answers (4)
Answers (4)
Reagan
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
>>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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
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'
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi
Please go through below sap note
https://launchpad.support.sap.com/#/notes/2324841/E
Regards,
Prithviraj
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
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>
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Reagan
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
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
- Why is my SQL Server database log growing out of control risking system standstill? in Technology Blogs by SAP
- SAP HANA on Google Cloud + NetApp CVS: non-disruptive volume size and performance scaling to fit workload needs in Technology Blogs by Members
- Best Practice: Repairing a Failed SAP Instance (Part 1 – Restoring a Failed SAP Service) in Technology Blogs by SAP
- Advanced Log Space Management (ALSM) as of Db2 for LUW Version 11.5 in Technology Blogs by SAP
- Can I run an SAP system in different network subnets? in Technology Blogs by SAP
| User | Count |
|---|---|
| 93 | |
| 10 | |
| 10 | |
| 9 | |
| 9 | |
| 7 | |
| 6 | |
| 5 | |
| 5 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.