cancel
Showing results for 
Search instead for 
Did you mean: 

disp+work.exe, dispatcher stopped.

jayaprakashhj
Participant
0 Kudos

Hi experts,

when I start SAPMMC, all three stuffs in process list- msg_server.exe, disp+work.exe, igswd.exe,  do turn greeen, but about a minute later disp+work.exe turns grey.

I had faced this problem before. I found space on hard disc was less than 100MB. I went through Mycomputer-'D' drive- oracle- EC6-oraarch- deleted all files. The problem was solved. But this time its not a solution.

I dont know how to get dev_w0 trace file as i a beginner in SAP. Pls let me know how to get it in case u want me to get it for u.

---------------------------------------------------

trc file: "dev_disp", trc level: 1, release: "700"

---------------------------------------------------

sysno      24

sid        EC6

systemid   560 (PC with Windows NT)

relno      7000

patchlevel 0

patchno    75

intno      20050900

make:      multithreaded, Unicode, optimized

pid        3608

Sat Dec 01 10:47:26 2012

kernel runs with dp version 217000(ext=109000) (@(#) DPLIB-INT-VERSION-217000-UC)

length of sys_adm_ext is 572 bytes

*** SWITCH TRC-HIDE on ***

***LOG Q00=> DpSapEnvInit, DPStart (24 3608) [dpxxdisp.c   1237]

          shared lib "dw_xml.dll" version 75 successfully loaded

          shared lib "dw_xtc.dll" version 75 successfully loaded

          shared lib "dw_stl.dll" version 75 successfully loaded

          shared lib "dw_gui.dll" version 75 successfully loaded

          shared lib "dw_mdm.dll" version 75 successfully loaded

rdisp/softcancel_sequence :  -> 0,5,-1

use internal message server connection to port 3924

Sat Dec 01 10:47:38 2012

*** WARNING => DpNetCheck: NiHostToAddr(www.doesnotexist0219.qqq.nxst) took 12 seconds

Sat Dec 01 10:47:54 2012

*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 16 seconds

***LOG GZZ=> 2 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c  5273]

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

DpSysAdmExtInit: VMC (JAVA VM in WP) is not active

DpIPCInit2: start server >sapdev_EC6_24                           <

DpShMCreate: sizeof(wp_adm)                    18304          (1408)

DpShMCreate: sizeof(tm_adm)                    3994272          (19872)

DpShMCreate: sizeof(wp_ca_adm)                    24000          (80)

DpShMCreate: sizeof(appc_ca_adm)          8000          (80)

DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064

DpShMCreate: sizeof(comm_adm)                    528064          (1048)

DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

DpShMCreate: sizeof(file_adm)                    0          (72)

DpShMCreate: sizeof(vmc_adm)                    0          (1440)

DpShMCreate: sizeof(wall_adm)                    (38456/34360/64/184)

DpShMCreate: sizeof(gw_adm)          48

DpShMCreate: SHM_DP_ADM_KEY                    (addr: 05D30040, size: 4653368)

DpShMCreate: allocated sys_adm at 05D30040

DpShMCreate: allocated wp_adm at 05D31E40

DpShMCreate: allocated tm_adm_list at 05D365C0

DpShMCreate: allocated tm_adm at 05D365F0

DpShMCreate: allocated wp_ca_adm at 06105890

DpShMCreate: allocated appc_ca_adm at 0610B650

DpShMCreate: allocated comm_adm at 0610D590

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 0618E450

DpShMCreate: allocated gw_adm at 0618E490

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 0618E4C0

DpShMCreate: allocated wall_adm at 0618E4C8

MBUF state OFF

DpCommInitTable: init table for 500 entries

Sat Dec 01 10:47:55 2012

EmInit: MmSetImplementation( 2 ).

MM global diagnostic options set: 0

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 1024 kByte.

Using implementation flat

<EsNT> Memory Reset disabled as NT default

<ES> 2047 blocks reserved for free list.

ES initialized.

Sat Dec 01 10:47:56 2012

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c   1623]

***LOG Q0K=> DpMsAttach, mscon ( sapdev) [dpxxdisp.c   11586]

DpStartStopMsg: send start message (myname is >sapdev_EC6_24                           <)

DpStartStopMsg: start msg sent

Sat Dec 01 10:47:57 2012

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

CCMS: Initalizing shared memory of size 60000000 for monitoring segment.

Sat Dec 01 10:47:58 2012

CCMS: start to initalize 3.X shared alert area (first segment).

DpMsgAdmin: Set release to 7000, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c   1050]

DpMsgAdmin: Set patchno for this platform to 75

Release check o.K.

Sat Dec 01 10:48:36 2012

*** ERROR => W0 (pid 2744) died [dpxxdisp.c   14241]

*** ERROR => W1 (pid 2764) died [dpxxdisp.c   14241]

*** ERROR => W2 (pid 3944) died [dpxxdisp.c   14241]

*** ERROR => W3 (pid 2740) died [dpxxdisp.c   14241]

*** ERROR => W4 (pid 2776) died [dpxxdisp.c   14241]

*** ERROR => W5 (pid 2780) died [dpxxdisp.c   14241]

my types changed after wp death/restart 0xbf --> 0xbe

*** ERROR => W6 (pid 2784) died [dpxxdisp.c   14241]

my types changed after wp death/restart 0xbe --> 0xbc

*** ERROR => W7 (pid 2788) died [dpxxdisp.c   14241]

my types changed after wp death/restart 0xbc --> 0xb8

*** ERROR => W8 (pid 2820) died [dpxxdisp.c   14241]

*** ERROR => W9 (pid 2832) died [dpxxdisp.c   14241]

*** ERROR => W10 (pid 2808) died [dpxxdisp.c   14241]

my types changed after wp death/restart 0xb8 --> 0xb0

*** ERROR => W11 (pid 2828) died [dpxxdisp.c   14241]

my types changed after wp death/restart 0xb0 --> 0xa0

*** ERROR => W12 (pid 2848) died [dpxxdisp.c   14241]

my types changed after wp death/restart 0xa0 --> 0x80

*** DP_FATAL_ERROR => DpWPCheck: no more work processes

*** DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

NiWait: sleep (10000ms) ...

NiISelect: timeout 10000ms

NiISelect: maximum fd=1625

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sat Dec 01 10:48:46 2012

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long)                              Sat Dec 01 05:18:46 2012

========================

No Ty. Pid      Status  Cause Start Err Sem CPU    Time  Program  Cl  User         Action                    Table

-----------------------------------------------------------------------------------------------------------------------

0 DIA     2744 Ended         no      1   0             0                                                             

1 DIA     2764 Ended         no      1   0             0                                                             

2 DIA     3944 Ended         no      1   0             0                                                             

3 DIA     2740 Ended         no      1   0             0                                                             

4 DIA     2776 Ended         no      1   0             0                                                             

5 DIA     2780 Ended         no      1   0             0                                                             

6 UPD     2784 Ended         no      1   0             0                                                             

7 ENQ     2788 Ended         no      1   0             0                                                             

8 BTC     2820 Ended         no      1   0             0                                                             

9 BTC     2832 Ended         no      1   0             0                                                             

10 BTC     2808 Ended         no      1   0             0                                                             

11 SPO     2828 Ended         no      1   0             0                                                             

12 UP2     2848 Ended         no      1   0             0                                                             

Dispatcher Queue Statistics                              Sat Dec 01 05:18:46 2012

===========================

+------+--------+--------+--------+--------+--------+

|  Typ |    now |   high |    max | writes |  reads |

+------+--------+--------+--------+--------+--------+

| NOWP |      0 |      2 |   2000 |      5 |      5 |

+------+--------+--------+--------+--------+--------+

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

wake_evt_udp_now          0

wake events                total     8,  udp     6 ( 75%),  shm     2 ( 25%)

since last update          total     8,  udp     6 ( 75%),  shm     2 ( 25%)

Dump of tm_adm structure:                              Sat Dec 01 05:18:46 2012

=========================

Term    uid  man user    term   lastop  mod wp  ta   a/i (modes)

Workprocess Comm. Area Blocks                              Sat Dec 01 05:18:46 2012

=============================

Slots: 300, Used: 1, Max: 0

+------+--------------+----------+-------------+

|   id | owner        |   pid    | eyecatcher  |

+------+--------------+----------+-------------+

|    0 | DISPATCHER   |       -1 | *WPCAAD000* |

NiWait: sleep (5000ms) ...

NiISelect: timeout 5000ms

NiISelect: maximum fd=1625

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sat Dec 01 10:48:51 2012

NiISelect: TIMEOUT occured (5000ms)

DpHalt: shutdown server >sapdev_EC6_24                           < (normal)

DpJ2eeDisableRestart

DpModState: buffer in state MBUF_PREPARED

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO)

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 (2736) (SOFT_KILL)

Stop icman

killing process (2724) (SOFT_KILL)

Terminate gui connections

wait for end of work processes

wait for end of gateway

[DpProcDied] Process lives  (PID:2736  HANDLE:1596)

waiting for termination of gateway ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1625

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sat Dec 01 10:48:52 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died  (PID:2736  HANDLE:1596)

wait for end of icman

[DpProcDied] Process lives  (PID:2724  HANDLE:1600)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1625

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sat Dec 01 10:48:53 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2724  HANDLE:1600)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1625

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sat Dec 01 10:48:54 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2724  HANDLE:1600)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1625

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sat Dec 01 10:48:55 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2724  HANDLE:1600)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1625

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sat Dec 01 10:48:56 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2724  HANDLE:1600)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1625

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sat Dec 01 10:48:57 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2724  HANDLE:1600)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1625

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sat Dec 01 10:48:58 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2724  HANDLE:1600)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1625

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sat Dec 01 10:48:59 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2724  HANDLE:1600)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1625

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sat Dec 01 10:49:00 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2724  HANDLE:1600)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1625

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sat Dec 01 10:49:01 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2724  HANDLE:1600)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1625

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sat Dec 01 10:49:02 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2724  HANDLE:1600)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1625

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sat Dec 01 10:49:03 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died  (PID:2724  HANDLE:1600)

DpStartStopMsg: send stop message (myname is >sapdev_EC6_24                           <)

NiIMyHostName: hostname = 'sapdev'

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 = 189 bytes

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=562,pac=1,MESG_IO)

MsINiWrite: sent 562 bytes

send msg (len 110+452) to name                    -, type 4, key -

DpStartStopMsg: stop msg sent

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER          , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER          , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER          , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER          , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER          , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER          , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER          , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 recv would block (errno=EAGAIN)

NiIRead: read for hdl 2 timed out (0ms)

DpHalt: no more messages from the message server

DpHalt: send keepalive to synchronize with the message server

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=114,pac=1,MESG_IO)

MsINiWrite: sent 114 bytes

send msg (len 110+4) to name           MSG_SERVER, type 0, key -

MsSndName: MS_NOOP ok

Send 4 bytes to MSG_SERVER

NiIRead: hdl 2 received data (rcd=114,pac=1,MESG_IO)

NiBufIIn: NIBUF len=114

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 114 bytes

MSG received, len 110+4, flag 3, from MSG_SERVER          , typ 0, key -

Received 4 bytes from MSG_SERVER                             

Received opcode MS_NOOP from msg_server, reply MSOP_OK

MsOpReceive: ok

MsSendKeepalive : keepalive sent to message server

NiIRead: hdl 2 recv would block (errno=EAGAIN)

Sat Dec 01 10:49:04 2012

NiIPeek: peek for hdl 2 timed out (r; 1000ms)

NiIRead: read for hdl 2 timed out (1000ms)

DpHalt: no more messages from the message server

DpHalt: sync with message server o.k.

detach from message server

***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c   11899]

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO)

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server

MsIDetach: call exit function

DpMsShutdownHook called

NiBufISelUpdate: new MODE -- (r-) for hdl 2 in set0

SiSelNSet: set events of sock 1536 to: ---

NiBufISelRemove: remove hdl 2 from set0

SiSelNRemove: removed sock 1536 (pos=2)

SiSelNRemove: removed sock 1536

NiSelIRemove: removed hdl 2

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/13

LOCK WP ca_blk 1

make DISP owner of wp_ca_blk 1

DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 15)

MBUF component DOWN

NiICloseHandle: shutdown and close hdl 2 / sock 1536

NiBufIClose: clear extension for hdl 2

MsIDetach: detach MS-system

cleanup EM

Sat Dec 01 10:49:05 2012

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

***LOG Q05=> DpHalt, DPStop ( 3608) [dpxxdisp.c   10259]

Good Bye .....

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi jayaprakash ,

You can find dev_w0 trace file in  dir /usr/sap/<SID>/DVEBMGS00/work/

<SID> your system id.

Regards

Ganesh Datt Tiwari

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Jayaprakash,

1. Check hosts file in OS level if the hostname nad IP address maintained properly or not.

2. Check if oracle is running or not.

    2.1 If running stop the oracle as below:

         OS> sqlplus "/ as sysdba"

         SQL> shu immediate
    2.2 If not yet startted start using below process:

         OS> sqlplus "/ as sysdba"

         SQL> startup

3. Check listener:
OS> lsnrctl status
If not running
OS> lsnrctl start

4. Now check DB connectivity with SAP
OS> r3trans -d

Please let me know the output.

Thanks
Rajat

Former Member
0 Kudos

hello jayaprash

first of all R3trans -d is not needed to run at SQL level.

again as i can see your system is windows.

so you go to services and check whether LSNR services is active there or not and it should be started.

also go to task manager and check whether PMON and SMON for Oracle is started or not.

if not then start your oracle via

Run - CMD

SQLPLUS "/as sysdba"

if it is not connected then it will show you connected to ideal instance. if it is the case then

you can start the oracle with

startup;

and also check the lsnr is running or not.

if both is working then it should get connected.

in regards to your user query for scot.

please run following query

select status from v$dba_users;

Regards

Dishant

if it resolves your problem then do give me points.

jayaprakashhj
Participant
0 Kudos

Hi Dishant,

  Here is wat i did.

i wil also giv u snap shots of services and task mgr.

Try to analyze.

Thanks.

JP.

Former Member
0 Kudos

Hi JP,

Is your issue resolved ?

Regards

Ganesh Datt Tiwari

Former Member
0 Kudos

Hi

as i can see there is no oracle running

please start the oracle by

Sqlplus "/as sysdba"

startup

then check task manager

and user view is different it is table dba_users

you do

desc dba_users;

then check for validity and lock status

but start your oracle.

if you still face that issue starting oracle then please do attach alertsid log.

Regards

Dishant.

0 Kudos

Hi Jayaprakash,

Have you tried shutting down oracle db and OS and restarting them.

Before starting Oracle db make sure Oracle listner service is running.

Regards,

Ajay

jayaprakashhj
Participant
0 Kudos

---------------------------------------------------

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

---------------------------------------------------

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

B Sat Dec 01 10:47:57 2012

B  create_con (con_name=R/3)

B  Loading DB library 'D:\usr\sap\EC6\DVEBMGS24\exe\dboraslib.dll' ...

B  Library 'D:\usr\sap\EC6\DVEBMGS24\exe\dboraslib.dll' loaded

B  Version of 'D:\usr\sap\EC6\DVEBMGS24\exe\dboraslib.dll' is "700.08", patchlevel (0.73)

B  New connection 0 created

M sysno      24

M sid        EC6

M systemid   560 (PC with Windows NT)

M relno      7000

M patchlevel 0

M patchno    75

M intno      20050900

M make:      multithreaded, Unicode, optimized

M pid        2744

M

M  kernel runs with dp version 217000(ext=109000) (@(#) DPLIB-INT-VERSION-217000-UC)

M  length of sys_adm_ext is 572 bytes

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

I  MtxInit: 30000 0 0

M  DpSysAdmExtCreate: ABAP is active

M  DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M  DpShMCreate: sizeof(wp_adm)                    18304          (1408)

M  DpShMCreate: sizeof(tm_adm)                    3994272          (19872)

M  DpShMCreate: sizeof(wp_ca_adm)                    24000          (80)

M  DpShMCreate: sizeof(appc_ca_adm)          8000          (80)

M  DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064

M  DpShMCreate: sizeof(comm_adm)                    528064          (1048)

M  DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M  DpShMCreate: sizeof(file_adm)                    0          (72)

M  DpShMCreate: sizeof(vmc_adm)                    0          (1440)

M  DpShMCreate: sizeof(wall_adm)                    (38456/34360/64/184)

M  DpShMCreate: sizeof(gw_adm)          48

M  DpShMCreate: SHM_DP_ADM_KEY                    (addr: 05D30040, size: 4653368)

M  DpShMCreate: allocated sys_adm at 05D30040

M  DpShMCreate: allocated wp_adm at 05D31E40

M  DpShMCreate: allocated tm_adm_list at 05D365C0

M  DpShMCreate: allocated tm_adm at 05D365F0

M  DpShMCreate: allocated wp_ca_adm at 06105890

M  DpShMCreate: allocated appc_ca_adm at 0610B650

M  DpShMCreate: allocated comm_adm at 0610D590

M  DpShMCreate: system runs without file table

M  DpShMCreate: allocated vmc_adm_list at 0618E450

M  DpShMCreate: allocated gw_adm at 0618E490

M  DpShMCreate: system runs without vmc_adm

M  DpShMCreate: allocated ca_info at 0618E4C0

M  DpShMCreate: allocated wall_adm at 0618E4C8

X  EmInit: MmSetImplementation( 2 ).

X  MM global diagnostic options set: 0

X  <ES> client 0 initializing ....

X  Using implementation flat

M  <EsNT> Memory Reset disabled as NT default

X  ES initialized.

M Sat Dec 01 10:47:58 2012

M  ThInit: running on host sapdev

M Sat Dec 01 10:47:59 2012

M  calling db_connect ...

C  Prepending D:\usr\sap\EC6\DVEBMGS24\exe to Path.

C Sat Dec 01 10:48:02 2012

C  Oracle Client Version: '10.2.0.1.0'

C  Client NLS settings: AMERICAN_AMERICA.UTF8

C  Logon as OPS$-user to get SAPSR3's password

C  Connecting as /@EC6 on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      1   062FBFE8   06301584   06300E0C

C  Attaching to DB Server EC6 (con_hdl=0,svchp=06300D58,svrhp=06312264)

C Sat Dec 01 10:48:06 2012

C  Starting user session (con_hdl=0,svchp=06300D58,srvhp=06312264,usrhp=06326F98)

C Sat Dec 01 10:48:07 2012

C  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034

[dboci.c      4391]

C  Detaching from DB Server (con_hdl=0,svchp=06300D58,srvhp=06312264)

C  *** ERROR => CONNECT failed with sql error '1034'

[dbsloci.c    10933]

C  Try to connect with default password

C  Connecting as SAPSR3/<pwd>@EC6 on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      1   062FBFE8   06301584   06300E0C

C  Attaching to DB Server EC6 (con_hdl=0,svchp=06300D58,svrhp=06312264)

C Sat Dec 01 10:48:08 2012

C  Starting user session (con_hdl=0,svchp=06300D58,srvhp=06312264,usrhp=06326F98)

C Sat Dec 01 10:48:09 2012

C  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034

[dboci.c      4391]

C  Detaching from DB Server (con_hdl=0,svchp=06300D58,srvhp=06312264)

C  *** ERROR => CONNECT failed with sql error '1034'

[dbsloci.c    10933]

B  ***LOG BV3=> severe db error 1034      ; work process is stopped [dbsh#2 @ 1199] [dbsh    1199 ]

B  ***LOG BY2=> sql error 1034   performing CON [dblink#3 @ 431] [dblink  0431 ]

B  ***LOG BY0=> ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist [dblink#3 @ 431] [dblink  0431 ]

M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1411]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   10156]

M  Info for wp 0

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    semaphore = 0

M    act_cs_count = 0

M    control_flag = 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    vm = V-1

M  *****************************************************************************

M  *

M  *  LOCATION    SAP-Server sapdev_EC6_24 on host sapdev (wp 0)

M  *  ERROR       ThInit: db_connect

M  *

M  *  TIME        Sat Dec 01 10:48:09 2012

M  *  RELEASE     700

M  *  COMPONENT   Taskhandler

M  *  VERSION     1

M  *  RC          13

M  *  MODULE      thxxhead.c

M  *  LINE        10354

M  *  COUNTER     1

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   720]

M  *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c  260]

M  Entering ThSetStatError

M  ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M  Entering ThReadDetachMode

M  call ThrShutDown (1)...

M  ***LOG Q02=> wp_halt, WPStop (Workproc 0 2744) [dpnttool.c   327]

Former Member
0 Kudos

Hi

please check your listner is running or not ?

Also check SAP note 491174 - Composite SAP note for ORA-01034.

Execute command R3trans -d and send the output.

Regards

Ganesh Datt Tiwari

jayaprakashhj
Participant
0 Kudos

Hi bro,

I executed the listener cmd.

Could u see the image please?

I'm trying your other recommendations.

thanks for being with me.

JP.

Former Member
0 Kudos

Hi JP,

I m not able to see the image.

Please post it in test format.

Regards

Ganesh Datt Tiwari

jayaprakashhj
Participant
0 Kudos

Hi bro,

Is this correct way of executing the command?

Please let me know..

and also let me know how to execute r3trans -d..

thanx.

In DOS command:-

c:\document and settings\ administrator> lsnrctl.exe start

LSNRCTL for 32-bit windows: version 10.2.0.1.0- production on 01-dec-2012 12:57:57

copyright <c> 1991, 2005, oracle. all rirhts reserved.

TNS-01106: Listener using listener name LISTENER has already been started

c:\document and settings\ administrator>

Former Member
0 Kudos

Hi,

It seems that that the database is down. Be sure the database is up. Execute the command, below on SQLplus;

SQL>startup

If the the db started successfully, try to start the SAP application server.

Best regards,

Orkun Gedik

Former Member
0 Kudos

Hi JP,

Please login with ORA<SID> user and then restart the listner.

You also check your database is running or not as after login with ORA<SID> run command sqlplus and start oracle as SQL>startup

For R3trans you login with <SID>ADM and then run command R3trans -d.

Regards

Ganesh Datt Tiwari

jayaprakashhj
Participant
0 Kudos

Hi experts,

i tried this: username 'scott' password 'tiger'

but its locked.

how to unlock it?

i'm searching web but totally confused..

pls help

here is wat i did.

c:\doc and set\admi> sqlplus

SQL*PLUS: Release..........

copyright........

Enter user-name: scott

Enter password: tiger

ERROR:

ORA-28000: the account is locked

dont know wat to do.

pls reply,

JP.

Former Member
0 Kudos

Hi J P,

Please try the below command

c:\doc and set\admi>sqlplus "/ as sysdba"

Regards

Ganesh Datt Tiwari

jayaprakashhj
Participant
0 Kudos

Hi Ganesh,

I appreciate ur patience.

Here is wat i just did:-

c:\docu n settings\adm> sqlplus "/ as sysdba"

SQL*Plus: ......

copyright<c>.......

connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - production

with the partitioning , OLAP and Data Mining options

SQL>R3trans -d

SP2-0103: Nothing in SQL buffer to run.

SQL>_