Skip to Content
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 03, 2007 at 05:26 AM

    very poor description?

    do you see oracle.exe in taskmanager?

    what oracle alert logs/traces are saying

    what is stated in dew_w0?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      dew_01

      -


      -


      trc file: "dev_w0", trc level: 1, release: "640"

      -


      *

      • ACTIVE TRACE LEVEL 1

      • ACTIVE TRACE COMPONENTS all, M

      *

      B

      B Sat Jun 23 15:33:13 2007

      B create_con (con_name=R/3)

      B Loading DB library 'C:\usr\sap\XI3\SYS\exe\run\dbadaslib.dll' ...

      B Library 'C:\usr\sap\XI3\SYS\exe\run\dbadaslib.dll' loaded

      B Version of 'C:\usr\sap\XI3\SYS\exe\run\dbadaslib.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 4080

      M

      M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 4080) [dpxxdisp.c 1160]

      I MtxInit: -2 0 0

      M DpSysAdmExtCreate: ABAP is active

      M DpSysAdmExtCreate: JAVA is not active

      M

      M Sat Jun 23 15:33:14 2007

      M DpShMCreate: sizeof(wp_adm) 9936 (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: 039D0040, size: 2508728)

      M DpShMCreate: allocated sys_adm at 039D0040

      M DpShMCreate: allocated wp_adm at 039D17A8

      M DpShMCreate: allocated tm_adm_list at 039D3E78

      M DpShMCreate: allocated tm_adm at 039D3EA0

      M DpShMCreate: allocated wp_ca_adm at 03BF1DE8

      M DpShMCreate: allocated appc_ca_adm at 03BF6438

      M DpShMCreate: allocated comm_adm_list at 03BF7BA8

      M DpShMCreate: allocated comm_adm at 03BF7BC0

      M DpShMCreate: allocated vmc_adm_list at 03C269C0

      M DpShMCreate: system runs without vmc_adm

      M DpShMCreate: allocated ca_info at 03C269E8

      M DpShMCreate: allocated wall_adm at 03C269F0

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

      C

      C DBADASLIB : version 640.00

      C SAPDB shared library (dbadaslib) patchlevels (last 10)

      C (0.039) Invalid data of STAD corrected (note 779116)

      C (0.039) Do not abort session after -810 (note 780238)

      C (0.035) Sapdb_free invalid address (note 766340)

      C (0.035) EXPLAIN with non character inputvariables (note 770755)

      C (0.032) Sapdb_free invalid address (note 766340)

      C (0.032) Abap info for performance montior (note 216208)

      C (0.032) SAPDB min. release is 7.4.3 (note 326487)

      C (0.031) Set isolation level calls optimized (note 762712)

      C (0.018) ThGetWpId corrected (note 624930)

      C (0.014) LobGetpiece returns a failure if no data available (note 720343)

      C

      C

      C INFO : SQLOPT= -I 0 -t 0 -F SAPDB.4080.pct

      C Precompiler Runtime : C-PreComp 7.4.3 Build 035-113-078-680

      C Precompiler runtime is SAP DB 7.4.3.035

      C Try to connect (DEFAULT) on connection 0 ...

      C

      C Sat Jun 23 15:33:15 2007

      C Attach to SAP DB : Kernel 7.5.0 Build 018-123-079-776

      C Database release is SAP DB 7.5.0.018

      C INFO : Database 'XI3' instance is running on 'XI03'

      C INFO : SAP DB Packet_Size = 131072

      C INFO : SAP DB Min_Reply_Size = 4096

      C INFO : SAP DB Comm_Size = 126976

      C INFO : DBSL buffer size = 126976

      C INFO : SAP DB MaxLocks = 300000

      C INFO : Connect to DB as 'SAPXI3'

      C 00: DB_000 XI03-XI3, conn=1, since=20070623153315

      C ABAP= <unknown> (0)

      C Now I'm connected to SAP DB

      B Connection 0 opened

      B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost

      B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20070623 153314 XI03

      C INFO : SAP RELEASE (DB) = 640

      M db_connect o.k.

      *

      • ACTIVE TRACE LEVEL 2

      • ACTIVE TRACE COMPONENTS all, M

      *

      M -


      C-STACK -


      SAP (R) - R/3(TM) Callstack, Version 1.0

      Copyright (C) SAP AG. All rights reserved.

      -


      Callstack without Exception:

      App : disp+work.EXE (pid=4080)

      When : 6/23/2007 15:46:32.609

      Threads : 2

      -


      Computer Name : XI03

      User Name : SAPServicexi3

      -


      Number of Processors: 1

      Processor Type: x86 Family 6 Model 13 Stepping 8

      Windows Version : 5.2 Current Build: 3790

      -


      State Dump for Thread Id ff4

      eax=7f6f06a0 ebx=00001388 ecx=23c34600 edx=00000000 esi=000006c8 edi=00000000

      eip=7ffe0304 esp=0312fd60 ebp=0312fdd0 iopl=0 nv up ei pl zr na po nc

      cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00000246

      function : <nosymbols>

      7ffe02f0 0000 add [eax],al ds:7f6f06a0=14

      7ffe02f2 0000 add [eax],al ds:7f6f06a0=14

      7ffe02f4 0000 add [eax],al ds:7f6f06a0=14

      7ffe02f6 0000 add [eax],al ds:7f6f06a0=14

      7ffe02f8 0000 add [eax],al ds:7f6f06a0=14

      7ffe02fa 0000 add [eax],al ds:7f6f06a0=14

      7ffe02fc 0000 add [eax],al ds:7f6f06a0=14

      7ffe02fe 0000 add [eax],al ds:7f6f06a0=14

      7ffe0300 8bd4 mov edx,esp

      7ffe0302 0f34 ???

      7ffe0304 c3 ret

      7ffe0305 9c pushfd

      7ffe0306 810c2400010000 or dword ptr [esp],0x100 ss:0312fd60=77f43741

      7ffe030d 9d popfd

      7ffe030e c3 ret

      7ffe030f 90 nop

      7ffe0310 90 nop

      7ffe0311 90 nop

      7ffe0312 90 nop

      7ffe0313 90 nop

      7ffe0314 90 nop

      7ffe0315 90 nop

      -- > Stack Back Trace < --

      FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name

      0312fd5c 77f43741 77e41817 000006c8 00000001 0312fda4 <nosymbols>

      0312fdd0 00f01f0e 000006c8 00001388 00000001 00000180 ntdll!NtWaitForSingleObject

      0312fdfc 0044e0ad 000006c8 00001388 7c3719e4 000000c0 disp+work!NT_AlertWaitForSingleObject [ntutil.c (1936)]

      0312fe38 0044eedf 01bffc78 00000003 00000478 ffffffff disp+work!ITL_RqOsSem [semnt.c (3030)]

      0312fe7c 0048489f 00000004 00000001 ffffffff 7c36a42b disp+work!SemRq [semnt.c (1040)]

      0312fe94 00493a2c 003a6008 00000002 0312ff04 00000000 disp+work!ThIPCInit [thxxhead.c (1826)]

      0312feec 00497e15 00000001 7ffdf000 00000000 00000000 disp+work!tskh_init [thxxhead.c (1352)]

      0312ff04 00421eb4 00000000 00000000 0312ff60 00401059 disp+work!tskhstart [thxxhead.c (1008)]

      0312ff14 00401059 00000003 003a6008 00000001 00000000 disp+work!DpMain [dpxxdisp.c (1009)]

      0312ff60 01064763 00000003 003a6008 003a28b8 015a6000 disp+work!main [thxxanf.c (58)]

      0312ffc0 77e4f38c 00000000 00000000 7ffdf000 00000000 disp+work!mainCRTStartup [crtexe.c (398)]

      0312fff0 00000000 01064620 00000000 00905a4d 00000003 kernel32!TerminateThread

      -


      State Dump for Thread Id 4f8

      eax=00000000 ebx=00000001 ecx=0000040e edx=00000000 esi=003a6050 edi=003a6020

      eip=7ffe0304 esp=04d5f7a0 ebp=04d5fbe0 iopl=0 nv up ei pl zr na po nc

      cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00000246

      function : <nosymbols>

      7ffe02f0 0000 add [eax],al ds:00000000=??

      7ffe02f2 0000 add [eax],al ds:00000000=??

      7ffe02f4 0000 add [eax],al ds:00000000=??

      7ffe02f6 0000 add [eax],al ds:00000000=??

      7ffe02f8 0000 add [eax],al ds:00000000=??

      7ffe02fa 0000 add [eax],al ds:00000000=??

      7ffe02fc 0000 add [eax],al ds:00000000=??

      7ffe02fe 0000 add [eax],al ds:00000000=??

      7ffe0300 8bd4 mov edx,esp

      7ffe0302 0f34 ???

      7ffe0304 c3 ret

      7ffe0305 9c pushfd

      7ffe0306 810c2400010000 or dword ptr [esp],0x100 ss:04d5f7a0=04d5fbe0

      7ffe030d 9d popfd

      7ffe030e c3 ret

      7ffe030f 90 nop

      7ffe0310 90 nop

      7ffe0311 90 nop

      7ffe0312 90 nop

      7ffe0313 90 nop

      7ffe0314 90 nop

      7ffe0315 90 nop

      -- > Stack Back Trace < --

      FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name

      04d5fbe0 00effd26 01c16a3c 00000002 00000000 00000000 <nosymbols>

      04d5fc70 005368d4 0053690d 7c38b548 01c16a3c 01c16a3c disp+work!NTDebugProcess [ntstcdbg.c (388)]

      04d5fc74 0053690d 7c38b548 01c16a3c 01c16a3c 01653a1c disp+work!NTStack [dptstack.c (1358)]

      04d5fc90 00536941 01c16a3c 00000000 00438c5a 01c16a3c disp+work!CTrcStack2 [dptstack.c (345)]

      04d5fc9c 00438c5a 01c16a3c 77e41d23 04d5fee8 00000000 disp+work!CTrcStack [dptstack.c (175)]

      04d5fcb8 00fc5fcd 00000011 00000011 7c36a42b 00000000 disp+work!DpTrcOnOff [dpxxtool.c (2257)]

      04d5fed0 00fc63ce 04d5fee8 01c18e8c 7c36a42b 7c343868 disp+work!SigISignalExecute [signt.c (810)]

      04d5fefc 00fc6691 00000000 037502b0 03750348 00000011 disp+work!SigISignalHandling [signt.c (741)]

      04d5ff84 7c349565 00000000 00000000 00000000 03750348 disp+work!SigIMsgFunc [signt.c (585)]

      04d5ffb8 77e4a990 03750348 00000000 00000000 03750348 MSVCR71!endthreadex

      04d5ffec 00000000 7c3494f6 03750348 00000000 00000000 kernel32!FlsSetValue

      -


      M -


      M Sat Jun 23 15:46:41 2007

      M ITL_ChkOsSem: Check semaphore process (Key:4 Slot:3)

      M Sat Jun 23 15:46:46 2007

      M ITL_ChkOsSem: Check semaphore process (Key:4 Slot:3)

      I am new to SAP,where do i see the taskmanager?