on 05-16-2007 9:11 PM
Hello all,
I am new to SAP, so please bear with me.
I have a ABAPJAVA test system, with the central instance and a dialog instance installed in the domain and the central service instance installed as a local installation. Before, all three instances were running perfectly. There has been some DNS problems in the network lately, and after I have corrected them, the dispwork process of the central and the dialog instances stop running (even as the central service instance still runs). Here is the trace log for the disp+work.exe for the central instance:
-
trc file: "dev_disp", trc level: 1, release: "640"
-
Wed May 16 15:59:59 2007
kernel runs with dp version 128(ext=102) (@(#) DPLIB-INT-VERSION-128)
length of sys_adm_ext is 312 bytes
systemid 560 (PC with Windows NT)
relno 6400
patchlevel 0
patchno 43
intno 20020600
make: multithreaded, ASCII
pid 2976
***LOG Q00=> DpSapEnvInit, DPStart (10 2976) [dpxxdisp.c 1100]
shared lib "dw_xml.dll" version 43 successfully loaded
shared lib "dw_xtc.dll" version 43 successfully loaded
shared lib "dw_stl.dll" version 43 successfully loaded
shared lib "dw_gui.dll" version 43 successfully loaded
Wed May 16 16:00:05 2007
WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds
***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 3886]
MtxInit: -2 0 0
DpSysAdmExtInit: ABAP is active
DpSysAdmExtInit: JAVA is not active
DpShMCreate: sizeof(wp_adm) 14080 (828)
DpShMCreate: sizeof(tm_adm) 2219848 (11044)
DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
DpShMCreate: sizeof(comm_adm) 192000 (384)
DpShMCreate: sizeof(vmc_adm) 0 (320)
DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)
DpShMCreate: SHM_DP_ADM_KEY (addr: 04A10040, size: 2512872)
DpShMCreate: allocated sys_adm at 04A10040
DpShMCreate: allocated wp_adm at 04A117A8
DpShMCreate: allocated tm_adm_list at 04A14EA8
DpShMCreate: allocated tm_adm at 04A14ED0
DpShMCreate: allocated wp_ca_adm at 04C32E18
DpShMCreate: allocated appc_ca_adm at 04C37468
DpShMCreate: allocated comm_adm_list at 04C38BD8
DpShMCreate: allocated comm_adm at 04C38BF0
DpShMCreate: allocated vmc_adm_list at 04C679F0
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated ca_info at 04C67A18
DpShMCreate: allocated wall_adm at 04C67A20
MBUF state OFF
EmInit: MmSetImplementation( 2 ).
<ES> client 0 initializing ....
<ES> InitFreeList
<ES> block size is 1024 kByte.
Using implementation flat
<EsNT> Memory Reset disabled as NT default
<ES> 1999 blocks reserved for free list.
ES initialized.
J2EE server info
start = TRUE
state = STARTED
pid = 4148
argv[0] = C:\usr\sap\T10\DVEBMGS10/j2ee/os_libs/jcontrol.exe
argv[1] = C:\usr\sap\T10\DVEBMGS10/j2ee/os_libs/jcontrol.exe
argv[2] = pf=C:\usr\sap\T10\SYS\profile\T10_DVEBMGS10_saptest11
argv[3] = -DSAPSTART=1
argv[4] = -DCONNECT_PORT=1357
argv[5] = -DLISTEN_PORT=1358
argv[6] = -DSAPSYSTEM=10
argv[7] = -DSAPSYSTEMNAME=T10
argv[8] = -DSAPMYNAME=saptest11_T10_10
argv[9] = -DSAPPROFILE=C:\usr\sap\T10\SYS\profile\T10_DVEBMGS10_saptest11
argv[10] = -DFRFC_FALLBACK=ON
argv[11] = -DFRFC_FALLBACK_HOST=localhost
start_lazy = 0
start_control = SAP J2EE startup framework
DpJ2eeStart: j2ee state = STARTED
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG Q0K=> DpMsAttach, mscon ( saptest11) [dpxxdisp.c 9736]
CCMS: Initalizing shared memory of size 40000000 for monitoring segment.
CCMS: start to initalize 3.X shared alert area (first segment).
DpMsgAdmin: Set release to 6400, patchlevel 0
DpJ2eeLogin: j2ee state = CONNECTED
MBUF state PREPARED
MBUF component UP
DpMBufHwIdSet: set Hardware-ID
***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1025]
DpMsgAdmin: Set patchno for this platform to 43
Release check o.K.
Wed May 16 16:00:45 2007
ERROR => W0 (pid 376) died [dpxxdisp.c 12187]
ERROR => W1 (pid 4280) died [dpxxdisp.c 12187]
ERROR => W2 (pid 4104) died [dpxxdisp.c 12187]
ERROR => W3 (pid 3544) died [dpxxdisp.c 12187]
ERROR => W4 (pid 3208) died [dpxxdisp.c 12187]
ERROR => W5 (pid 4120) died [dpxxdisp.c 12187]
ERROR => W6 (pid 3084) died [dpxxdisp.c 12187]
ERROR => W7 (pid 4160) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0xbf --> 0xbe
ERROR => W8 (pid 4224) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0xbe --> 0xbc
ERROR => W9 (pid 5388) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0xbc --> 0xb8
ERROR => W10 (pid 5596) died [dpxxdisp.c 12187]
ERROR => W11 (pid 4248) died [dpxxdisp.c 12187]
ERROR => W12 (pid 4328) died [dpxxdisp.c 12187]
ERROR => W13 (pid 4344) died [dpxxdisp.c 12187]
ERROR => W14 (pid 5564) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0xb8 --> 0xb0
ERROR => W15 (pid 4132) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0xb0 --> 0xa0
ERROR => W16 (pid 4144) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0xa0 --> 0x80
DP_FATAL_ERROR => DpWPCheck: no more work processes
DISPATCHER EMERGENCY SHUTDOWN ***
increase tracelevel of WPs
killing W0-376 (SIGUSR2)
ERROR => DpWpKill(376, SIGUSR2) failed [dpxxtool.c 2468]
killing W1-4280 (SIGUSR2)
ERROR => DpWpKill(4280, SIGUSR2) failed [dpxxtool.c 2468]
killing W2-4104 (SIGUSR2)
ERROR => DpWpKill(4104, SIGUSR2) failed [dpxxtool.c 2468]
killing W3-3544 (SIGUSR2)
ERROR => DpWpKill(3544, SIGUSR2) failed [dpxxtool.c 2468]
killing W4-3208 (SIGUSR2)
ERROR => DpWpKill(3208, SIGUSR2) failed [dpxxtool.c 2468]
killing W5-4120 (SIGUSR2)
ERROR => DpWpKill(4120, SIGUSR2) failed [dpxxtool.c 2468]
killing W6-3084 (SIGUSR2)
ERROR => DpWpKill(3084, SIGUSR2) failed [dpxxtool.c 2468]
killing W7-4160 (SIGUSR2)
ERROR => DpWpKill(4160, SIGUSR2) failed [dpxxtool.c 2468]
killing W8-4224 (SIGUSR2)
ERROR => DpWpKill(4224, SIGUSR2) failed [dpxxtool.c 2468]
killing W9-5388 (SIGUSR2)
ERROR => DpWpKill(5388, SIGUSR2) failed [dpxxtool.c 2468]
killing W10-5596 (SIGUSR2)
ERROR => DpWpKill(5596, SIGUSR2) failed [dpxxtool.c 2468]
killing W11-4248 (SIGUSR2)
ERROR => DpWpKill(4248, SIGUSR2) failed [dpxxtool.c 2468]
killing W12-4328 (SIGUSR2)
ERROR => DpWpKill(4328, SIGUSR2) failed [dpxxtool.c 2468]
killing W13-4344 (SIGUSR2)
ERROR => DpWpKill(4344, SIGUSR2) failed [dpxxtool.c 2468]
killing W14-5564 (SIGUSR2)
ERROR => DpWpKill(5564, SIGUSR2) failed [dpxxtool.c 2468]
killing W15-4132 (SIGUSR2)
ERROR => DpWpKill(4132, SIGUSR2) failed [dpxxtool.c 2468]
killing W16-4144 (SIGUSR2)
ERROR => DpWpKill(4144, SIGUSR2) failed [dpxxtool.c 2468]
NiWait: sleep (10000 msecs) ...
NiISelect: timeout 10000 ms
NiISelect: maximum fd=1565
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed May 16 16:00:55 2007
NiISelect: TIMEOUT occured (10000 ms)
dump system status
Workprocess Table (long) Wed May 16 20:00:55 2007
========================
No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table
-
0 DIA 376 Ended no 1 0 0
1 DIA 4280 Ended no 1 0 0
2 DIA 4104 Ended no 1 0 0
3 DIA 3544 Ended no 1 0 0
4 DIA 3208 Ended no 1 0 0
5 DIA 4120 Ended no 1 0 0
6 DIA 3084 Ended no 1 0 0
7 DIA 4160 Ended no 1 0 0
8 UPD 4224 Ended no 1 0 0
9 ENQ 5388 Ended no 1 0 0
10 BTC 5596 Ended no 1 0 0
11 BTC 4248 Ended no 1 0 0
12 BTC 4328 Ended no 1 0 0
13 BTC 4344 Ended no 1 0 0
14 BTC 5564 Ended no 1 0 0
15 SPO 4132 Ended no 1 0 0
16 UP2 4144 Ended no 1 0 0
Dispatcher Queue Statistics Wed May 16 20:00:55 2007
===========================
--------
+
Typ | now | high | max | writes | reads |
--------
+
NOWP | 0 | 3 | 2000 | 9 | 9 |
--------
+
DIA | 5 | 5 | 2000 | 5 | 0 |
--------
+
UPD | 0 | 0 | 2000 | 0 | 0 |
--------
+
ENQ | 0 | 0 | 2000 | 0 | 0 |
--------
+
BTC | 0 | 0 | 2000 | 0 | 0 |
--------
+
SPO | 0 | 0 | 2000 | 0 | 0 |
--------
+
UP2 | 0 | 0 | 2000 | 0 | 0 |
--------
+
max_rq_id 13
wake_evt_udp_now 0
wake events total 9, udp 7 ( 77%), shm 2 ( 22%)
since last update total 9, udp 7 ( 77%), shm 2 ( 22%)
Dump of tm_adm structure: Wed May 16 20:00:55 2007
=========================
Term uid man user term lastop mod wp ta a/i (modes)
Workprocess Comm. Area Blocks Wed May 16 20:00:55 2007
=============================
Slots: 300, Used: 1, Max: 0
--------
+
id | owner | pid | eyecatcher |
--------
+
0 | DISPATCHER | -1 | WPCAAD000 |
NiWait: sleep (5000 msecs) ...
NiISelect: timeout 5000 ms
NiISelect: maximum fd=1565
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed May 16 16:01:00 2007
NiISelect: TIMEOUT occured (5000 ms)
Shutdown server ...
DpJ2eeDisableRestart
DpIJ2eeShutdown: send SIGINT to SAP J2EE startup framework (pid=4148)
killing process (4148) (SOFT_KILL)
DpIJ2eeShutdown: j2ee state = SHUTDOWN
NiSelClear: removed hdl 7 from selectset
DpDelSocketInfo: del info for socket 7 (type=8)
NiBufClose: clear extensions for hdl 7
NiBufSetStat: bufstat of hdl 7 changed from OK to OFF
NiICloseHandle: shutdown and close hdl 7 / socket 1324
NiSelClear: removed hdl 4 from selectset
DpDelSocketInfo: del info for socket 4 (type=9)
NiBufClose: clear extensions for hdl 4
NiBufSetStat: bufstat of hdl 4 changed from OK to OFF
NiICloseHandle: shutdown and close hdl 4 / socket 1520
DpModState: buffer in state MBUF_PREPARED
NiBufSend starting
NiIWrite: write 110, 1 packs, MESG_IO, hdl 5, data complete
MsINiWrite: sent 110 bytes
MsIModState: change state to SHUTDOWN
DpModState: change server state from STARTING to SHUTDOWN
Switch off Shared memory profiling
ShmProtect( 57, 3 )
ShmProtect(SHM_PROFILE, SHM_PROT_RW
ShmProtect( 57, 1 )
ShmProtect(SHM_PROFILE, SHM_PROT_RD
DpWakeUpWps: wake up all wp's
Stop work processes...
Stop gateway
killing process (4340) (SOFT_KILL)
Stop icman
killing process (4388) (SOFT_KILL)
Terminate gui connections
[DpProcDied] Process lives (PID:4340 HANDLE:1536)
waiting for termination of gateway
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=1565
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed May 16 16:01:01 2007
NiISelect: TIMEOUT occured (1000 ms)
[DpProcDied] Process died (PID:4340 HANDLE:1536)
[DpProcDied] Process died (PID:4388 HANDLE:1528)
DpHalt: cancel all lcom connections
MPI CancelAll 2 -> 0
MPI DeleteAll 2 -> 0
[DpProcDied] Process died (PID:4148 HANDLE:1504)
NiIMyHostName: hostname = 'saptest11'
AdGetSelfIdentRecord: > <
AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0
AdCvtRecToExt: opcode 4 (AD_STARTSTOP), ser 0, ex 0, errno 0
DpConvertRequest: net size = 163 bytes
NiBufSend starting
NiIWrite: write 562, 1 packs, MESG_IO, hdl 5, data complete
MsINiWrite: sent 562 bytes
send msg (len 110+452) to name -, type 4, key -
detach from message server
***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 9962]
NiBufSend starting
NiIWrite: write 110, 1 packs, MESG_IO, hdl 5, data complete
MsINiWrite: sent 110 bytes
MsIDetach: send logout to msg_server
MsIDetach: call exit function
DpMsShutdownHook called
NiSelClear: removed hdl 5 from selectset
MBUF state OFF
AdGetSelfIdentRecord: > <
AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0
AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0
AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0
blks_in_queue/wp_ca_blk_no/wp_max_no = 1/300/17
LOCK WP ca_blk 1
make DISP owner of wp_ca_blk 1
DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 19)
MBUF component DOWN
NiBufClose: clear extensions for hdl 5
NiBufSetStat: bufstat of hdl 5 changed from OK to OFF
NiICloseHandle: shutdown and close hdl 5 / socket 1512
MsIDetach: detach MS-system
EsCleanup ....
***LOG Q05=> DpHalt, DPStop ( 2976) [dpxxdisp.c 8495]
Good Bye .....
Any help is appreciated.. points guaranteed for those who can help
Hello Charles,
Looks like network issue.
Check the host files on all the instances.Check if the IP details/hostname are correctly mentioned. Also check if the database is up and running.
Regards.
Ruchit.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have tried logging on to SAP via SAP Longon, here is the error dialog resulted:
partner not reached (host 192.168.1.104, service sapdp10)
Time Wed May 16 16:32:45 2007
Component NI (network interface)
Release 640
Version 37
Module nixxi_r.cpp
Line 8672
Method NiPConnect2
Return Code -10
System Call SiPeekPendConn
Error No 10061
Error Text WSAECONNREFUSED: Connection refused
Counter 1
I have two LAN connection, thus, my host is identified by two ip addr: 192.168.1.104 and 192.168.1.201
I've checked that the database is up and running.
hmm.. where are the host files and the IP details of the instances located? (sorry I am a student, and a SAP newbie)
Thanks for your help !
I have checked the dev_rfc.trc.log in the C:\usr\sap\<SAPID>\<instance #>\work and I discovered some lines such as:
T:628 ======> CPIC-CALL: 'SAP_CMACCPTP'
ERROR internal error
TIME Tue May 15 12:43:19 2007
RELEASE 640
COMPONENT NI (network interface)
VERSION 37
RC -1
COUNTER 5
T:628 ======> CPIC-CALL: 'SAP_CMACCPTP'
ERROR illegal parameter value ( function=SAP_CMACCPTP /
parameter=handle / value=256 )
TIME Tue May 15 12:43:19 2007
RELEASE 640
COMPONENT CPIC (TCP/IP)
VERSION 3
RC 769
MODULE r3cpic.c
LINE 9069
COUNTER 7
T:628 Error RFCIO_ERROR_MESSAGE in abrfcio.c : 1584
T:628 <* RfcGetNameEx [8] : returns 1:RFC_FAILURE
T:628 Error RFCIO_ERROR_NOHANDLE in abrfcio.c : 3086
>TS> Tue May 15 12:44:26 2007
hmm.. everything looks fine...
saptest11 is mapped to one of the addr of the host (192.168.104), and the ipconfig looks ok. Here is the dev_w7 file.. maybe someone could help me see what the problem is? Thanks!
-
trc file: "dev_w7", trc level: 1, release: "640"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M
*
B
B Thu May 17 09:37:59 2007
B create_con (con_name=R/3)
B *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library
[dbcon.c 4442]
M systemid 560 (PC with Windows NT)
M relno 6400
M patchlevel 0
M patchno 43
M intno 20020600
M make: multithreaded, ASCII
M pid 2024
M
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 7 2024) [dpxxdisp.c 1160]
I MtxInit: -2 0 0
M DpSysAdmExtCreate: ABAP is active
M DpSysAdmExtCreate: JAVA is not active
M DpShMCreate: sizeof(wp_adm) 14080 (828)
M DpShMCreate: sizeof(tm_adm) 2219848 (11044)
M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
M DpShMCreate: sizeof(comm_adm) 192000 (384)
M DpShMCreate: sizeof(vmc_adm) 0 (320)
M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)
M DpShMCreate: SHM_DP_ADM_KEY (addr: 05210040, size: 2512872)
M DpShMCreate: allocated sys_adm at 05210040
M DpShMCreate: allocated wp_adm at 052117A8
M DpShMCreate: allocated tm_adm_list at 05214EA8
M DpShMCreate: allocated tm_adm at 05214ED0
M DpShMCreate: allocated wp_ca_adm at 05432E18
M DpShMCreate: allocated appc_ca_adm at 05437468
M DpShMCreate: allocated comm_adm_list at 05438BD8
M DpShMCreate: allocated comm_adm at 05438BF0
M DpShMCreate: allocated vmc_adm_list at 054679F0
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 05467A18
M DpShMCreate: allocated wall_adm at 05467A20
X EmInit: MmSetImplementation( 2 ).
X <ES> client 7 initializing ....
X Using implementation flat
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
M
M Thu May 17 09:38:00 2007
M calling db_connect ...
B create_con (con_name=R/3)
B *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library
[dbcon.c 4442]
M ***LOG R19=> tskh_init, db_connect ( DB-Connect 008192) [thxxhead.c 1269]
M in_ThErrHandle: 1
M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 9413]
M
M Info for wp 7
M
M stat = 4
M reqtype = 1
M act_reqtype = -1
M rq_info = 0
M tid = -1
M mode = 255
M len = -1
M rq_id = 65535
M rq_source = 255
M last_tid = 0
M last_mode = 0
M int_checked_resource(RFC) = 0
M ext_checked_resource(RFC) = 0
M int_checked_resource(HTTP) = 0
M ext_checked_resource(HTTP) = 0
M report = > <
M action = 0
M tab_name = > <
M
M *****************************************************************************
M *
M * LOCATION SAP-Server saptest11_T10_10 on host saptest11 (wp 7)
M * ERROR tskh_init: db_connect
M *
M * TIME Thu May 17 09:38:00 2007
M * RELEASE 640
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 9589
M * COUNTER 1
M *
M *****************************************************************************
M
M PfStatDisconnect: disconnect statistics
M Entering TH_CALLHOOKS
M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 730]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 252]
M Entering ThSetStatError
M Entering ThReadDetachMode
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workproc 7 2024) [dpnttool.c 357]
Hi Charles,
<b>*** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library</b>
Check parameter dbms/type in the default profile or in the enviromental variables... the value should depend on the DB your using, ORA for oracle, MSS for MSSQL, DB2, DB6, etc...
Also check that the kernel installed is for the right Database
Regards
Juan
Please reward with pointd if helpful
Thanks for your help: Now I connected to the DB, and new errors crop up:
-
trc file: "dev_w0", trc level: 1, release: "640"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M
*
B
B Thu May 17 14:09:22 2007
B create_con (con_name=R/3)
B Loading DB library 'C:\usr\sap\T10\SYS\exe\run\dboraslib.dll' ...
B Library 'C:\usr\sap\T10\SYS\exe\run\dboraslib.dll' loaded
B Version of 'C:\usr\sap\T10\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.39)
B New connection 0 created
M systemid 560 (PC with Windows NT)
M relno 6400
M patchlevel 0
M patchno 43
M intno 20020600
M make: multithreaded, ASCII
M pid 7872
M
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 7872) [dpxxdisp.c 1160]
I MtxInit: -2 0 0
M DpSysAdmExtCreate: ABAP is active
M DpSysAdmExtCreate: JAVA is not active
M
M Thu May 17 14:09:23 2007
M DpShMCreate: sizeof(wp_adm) 14080 (828)
M DpShMCreate: sizeof(tm_adm) 2219848 (11044)
M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
M DpShMCreate: sizeof(comm_adm) 192000 (384)
M DpShMCreate: sizeof(vmc_adm) 0 (320)
M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)
M DpShMCreate: SHM_DP_ADM_KEY (addr: 052B0040, size: 2512872)
M DpShMCreate: allocated sys_adm at 052B0040
M DpShMCreate: allocated wp_adm at 052B17A8
M DpShMCreate: allocated tm_adm_list at 052B4EA8
M DpShMCreate: allocated tm_adm at 052B4ED0
M DpShMCreate: allocated wp_ca_adm at 054D2E18
M DpShMCreate: allocated appc_ca_adm at 054D7468
M DpShMCreate: allocated comm_adm_list at 054D8BD8
M DpShMCreate: allocated comm_adm at 054D8BF0
M DpShMCreate: allocated vmc_adm_list at 055079F0
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 05507A18
M DpShMCreate: allocated wall_adm at 05507A20
X EmInit: MmSetImplementation( 2 ).
X <ES> client 0 initializing ....
X Using implementation flat
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
M
M Thu May 17 14:09:24 2007
M calling db_connect ...
C Got ORACLE_HOME=C:\oracle\C11\920 from environment
C Client NLS settings: AMERICAN_AMERICA.WE8MSWIN1252
C Logon as OPS$-user to get SAPR3's password
C Connecting as /@C11 on connection 0 ...
C Attaching to DB Server C11 (con_hdl=0,svchp=06FD4ADC,svrhp=039136C4)
C Starting user session (con_hdl=0,svchp=06FD4ADC,srvhp=039136C4,usrhp=0391BE9C)
C Now I'm connected to ORACLE
C *** ERROR => ORA-1403 when accessing table SAPUSER
[dbsloci.c 10114]
C Disconnecting from connection 0 ...
C Closing user session (con_hdl=0,svchp=06FD4ADC,usrhp=0391BE9C)
C Now I'm disconnected from ORACLE
C Try to connect with default password
C Connecting as SAPR3/<pwd>@C11 on connection 0 ...
C Starting user session (con_hdl=0,svchp=06FD4ADC,srvhp=039136C4,usrhp=0391BE9C)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
[dboci.c 3720]
C *** ERROR => CONNECT failed with sql error '1017'
[dbsloci.c 9750]
B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 1200] [dbsh 1200 ]
B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 1200] [dbsh 1200 ]
B ***LOG BY2=> sql error 1017 performing CON [dblink#1 @ 419] [dblink 0419 ]
B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#1 @ 419] [dblink 0419 ]
M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1269]
M in_ThErrHandle: 1
M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 9413]
M
M Info for wp 0
M
M stat = 4
M reqtype = 1
M act_reqtype = -1
M rq_info = 0
M tid = -1
M mode = 255
M len = -1
M rq_id = 65535
M rq_source = 255
M last_tid = 0
M last_mode = 0
M int_checked_resource(RFC) = 0
M ext_checked_resource(RFC) = 0
M int_checked_resource(HTTP) = 0
M ext_checked_resource(HTTP) = 0
M report = > <
M action = 0
M tab_name = > <
M
M *****************************************************************************
M *
M * LOCATION SAP-Server saptest11_T10_10 on host saptest11 (wp 0)
M * ERROR tskh_init: db_connect
M *
M * TIME Thu May 17 14:09:24 2007
M * RELEASE 640
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 9589
M * COUNTER 1
M *
M *****************************************************************************
M
M PfStatDisconnect: disconnect statistics
M Entering TH_CALLHOOKS
M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 730]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 252]
M Entering ThSetStatError
M Entering ThReadDetachMode
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 7872) [dpnttool.c 357]
Is ORA-1403 when accessing table SAPUSER my problem?
That is strange, because everything was working fine before!
HI,
B ***LOG BY2=> sql error 1017 performing CON [dblink#1 @ 419] [dblink 0419 ]
B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#1 @ 419] [dblink 0419 ]
This is the problem.Did u changed any password <SID>ADM before
Soln :
use brtools to change the password of SAPUSER.<SID>ADM
regards
Umesh K
yes, I've changed those passwords before... I've looked at my oradbusr.log file and I found out that OPS$<domain_name>\<SID>ADM and OPS$<domain_name>\SAPSERVICE<SID> already exist. Do I log in the the dbase with these users to change it? Or will the brtools suffice?
Thanks for your reply and your patience!
I have successfully changed the password. Thanks! But now, it is telling me that I cannot login with SAPR3:
M calling db_connect ...
C Got ORACLE_HOME=C:\oracle\C11\920 from environment
C Client NLS settings: AMERICAN_AMERICA.WE8MSWIN1252
C Logon as OPS$-user to get SAPR3's password
C Connecting as /@C11 on connection 0 ...
C Attaching to DB Server C11 (con_hdl=0,svchp=06FD4ADC,svrhp=039136C4)
C Starting user session (con_hdl=0,svchp=06FD4ADC,srvhp=039136C4,usrhp=0391BE9C)
C Now I'm connected to ORACLE
C Got SAPR3's password from OPS$-user
C Disconnecting from connection 0 ...
C Closing user session (con_hdl=0,svchp=06FD4ADC,usrhp=0391BE9C)
C Now I'm disconnected from ORACLE
C Connecting as SAPR3/<pwd>@C11 on connection 0 ...
C Starting user session (con_hdl=0,svchp=06FD4ADC,srvhp=039136C4,usrhp=0391BE9C)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
[dboci.c 3720]
C *** ERROR => CONNECT failed with sql error '1017'
[dbsloci.c 9750]
B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 1200] [dbsh 1200 ]
B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 1200] [dbsh 1200 ]
B ***LOG BY2=> sql error 1017 performing CON [dblink#1 @ 419] [dblink 0419 ]
B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#1 @ 419] [dblink 0419 ]
M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1269]
M in_ThErrHandle: 1
M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 9413]
M
M Info for wp 0
M
M stat = 4
M reqtype = 1
M act_reqtype = -1
M rq_info = 0
M tid = -1
M mode = 255
M len = -1
M rq_id = 65535
M rq_source = 255
M last_tid = 0
M last_mode = 0
M int_checked_resource(RFC) = 0
M ext_checked_resource(RFC) = 0
M int_checked_resource(HTTP) = 0
M ext_checked_resource(HTTP) = 0
M report = > <
M action = 0
M tab_name = > <
M
I have tried to use brtools again, a la:
brconnect -u system/<syspasswd> -f chpass -o SAPR3 -p <password>
and it comes up with the messages:
BR08024E: Owner 'SAPR3' not found in database or not SAP owner
BR0182E: Checking parameter/option 'chpass_owner/-o' failed
Do I have to directly insert a SAPR3 owner to OPS$<sid>ADM".SAPUSER?
Thanks for all your help!
Pleae also update us how did you solve your problem. Your experience will help to other users who are suffering to seek the solution.
REgards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Please explain me what you did to troubleshoot the DNS Problem. How the DNS Probelm arise ? Did you do any other other troubleshooting in last week ?
Did you remember when you start the SAP instances lately ?
Pleaes do the following task on commond prompt on Domain Server & SAP Server..
1) try to ping the IP addresses and hostname including the DNS server from the both server
2) Did you update any policy on the OS & server ?
3) If your problem are solved by the above steps please update the latest kernel to resolved your problem.
REgards
Anwer Waseem
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
OK.. all my problems are solved now.. I've got the dispatcher running again. Thanks everyone for their patience and their help!
Charles
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi guys, thanks for all your help, now it is able to log in successfully:
but now this is what I encounter:
C *** ERROR => NLS_LANG not set appropriately (DB installation requires AMERICAN_AMERICA.WE8DEC) ==> connection refused
[dbsloci.c 9881]
M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1269]
M in_ThErrHandle: 1
M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 9413]
M
any pointers/links on how to modify this setting?
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Looks like the user SAPR3 has not been created..
Can anyone tell me where to get the script to create the SAPR3 user in the oradbusr.sql? Or how to do it manually in sql? Much appreciated!
Charles
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.