Skip to Content
avatar image
Former Member

disp+work shows grey in SAPMMC

Hi all,

I am new to SAP. I managed to install SAP 4.7 IDES on windows XP.

I am getting an error while starting SAP from SAPMMC.

The message Server starts and becomes green.

But the disp+work stays grey in color and doesnot start.

I have displayed the contents of dev_w0 & dev_disp

from the work directory.....

Please Can anyone help me identify and rectify the error....

/--


"dev_w0" content--
/

-


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

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, M

*

B

B Thu Nov 20 05:19:58 2008

B create_con (con_name=R/3)

B Loading DB library 'E:\usr\sap\P20\SYS\exe\run\dboraslib.dll' ...

B Library 'E:\usr\sap\P20\SYS\exe\run\dboraslib.dll' loaded

B Version of 'E:\usr\sap\P20\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.112)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6200

M patchlevel 0

M patchno 251

M intno 20020600

M pid 2832

M

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

I MtxInit: -2 0 0

X

X Thu Nov 20 05:19:59 2008

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation std

M <EsNT> Memory Reset enabled as NT default

X ES initialized.

M

M Thu Nov 20 05:20:01 2008

M calling db_connect ...

C Found ORACLE_HOME=E:\oracle\ora81 in Registry

C Client NLS settings: AMERICAN_AMERICA.WE8ISO8859P1

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

C Connecting as /@P20 on connection 0 ...

C Attaching to DB Server P20 (con_hdl=0,svchp=06179808,svrhp=06179614)

C

C Thu Nov 20 05:20:05 2008

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12154

[dboci.c 3566]

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

[dboci.c 9536]

C Try to connect with default password

C Connecting as SAPR3/<pwd>@P20 on connection 0 ...

C Attaching to DB Server P20 (con_hdl=0,svchp=06179808,svrhp=06179420)

C

C Thu Nov 20 05:20:10 2008

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12154

[dboci.c 3566]

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

[dboci.c 9536]

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

B ***LOG BY2=> sql error 12154 performing CON [dblink#1 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-12154: TNS:could not resolve service name [dblink#1 @ 419] [dblink 0419 ]

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M tid = -1

M mode = 255

M len = -1

M rq_id = -1

M rq_source = 255

M last_tid = 0

M last_mode = 0

M rfc_req = 0

M report = > <

M action = 0

M tab_name = > <

M

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

M *

M * LOCATION SAP-Server erp_P20_00 on host erp (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Thu Nov 20 05:20:10 2008

M * RELEASE 620

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 8408

M * COUNTER 1

M *

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

M

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >SAP-Trace buffer write< for event BEFORE_DUMP

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 672]

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

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

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

/--


"dev_disp" content--
/

-


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

-


Thu Nov 20 05:41:46 2008

systemid 560 (PC with Windows NT)

relno 6200

patchlevel 0

patchno 251

intno 20020600

pid 2204

***LOG Q00=> DpSapEnvInit, DPStart (00 2204) [dpxxdisp.c 966]

Thu Nov 20 05:41:47 2008

shared lib "dw_xml.dll" version 252 successfully loaded

shared lib "dw_xtc.dll" version 252 successfully loaded

shared lib "dw_stl.dll" version 252 successfully loaded

Thu Nov 20 05:41:51 2008

  • WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 4 seconds

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

MtxInit: -2 0 0

  • ERROR => DpSysACreate: ShmCreate (CREATE) [dpxxtool2.c 497]

  • ERROR => dispatcher already running ???? [dpxxtool2.c 498]

  • ERROR => I better EXIT before I do any (more) damage [dpxxtool2.c 500]

Regards,

king.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 22, 2008 at 06:20 AM

    Hi Shambo,

    Following are the details that you asked for......

    The actual situation is that I installed SAP for my friend with previous instance as "ERP"

    and then he used it for a few days...and then was trying to change the SID

    from "ERP" to "P20"

    He said that he did almost everything.......But the dispatcher doesnot start....

    CAn you Please guide me.........

    /--


    dev_disp--
    /

    -


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

    -


    Fri Nov 21 22:09:59 2008

    systemid 560 (PC with Windows NT)

    relno 6200

    patchlevel 0

    patchno 251

    intno 20020600

    pid 3324

    ***LOG Q00=> DpSapEnvInit, DPStart (00 3324) [dpxxdisp.c 966]

    shared lib "dw_xml.dll" version 252 successfully loaded

    shared lib "dw_xtc.dll" version 252 successfully loaded

    shared lib "dw_stl.dll" version 252 successfully loaded

    Fri Nov 21 22:10:03 2008

    • WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 4 seconds

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

    MtxInit: -2 0 0

    MBUF state OFF

    Fri Nov 21 22:10:04 2008

    EmInit: MmSetImplementation( 2 ).

    <ES> client 0 initializing ....

    <ES> InitFreeList

    <ES> block size is 1024 kByte.

    Using implementation std

    <EsNT> Memory Reset enabled as NT default

    <EsNT> EsIUnamFileMapInit: Initialize the memory 614 MB

    <ES> 613 blocks reserved for free list.

    ES initialized.

    Fri Nov 21 22:10:05 2008

    ***LOG Q0K=> DpMsAttach, mscon ( erp) [dpxxdisp.c 8832]

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

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

    DpMsgAdmin: Set release to 6200, patchlevel 0

    MBUF state PREPARED

    MBUF component UP

    DpMBufHwIdSet: set Hardware-ID

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

    DpMsgAdmin: Set patchno for this platform to 251

    Release check o.K.

    Fri Nov 21 22:10:45 2008

    • ERROR => W0 (pid 3580) died [dpxxdisp.c 11210]

    • ERROR => W1 (pid 3900) died [dpxxdisp.c 11210]

    • ERROR => W2 (pid 3908) died [dpxxdisp.c 11210]

    • ERROR => W3 (pid 3916) died [dpxxdisp.c 11210]

    • ERROR => W4 (pid 3884) died [dpxxdisp.c 11210]

    • ERROR => W5 (pid 3848) died [dpxxdisp.c 11210]

    • ERROR => W6 (pid 3964) died [dpxxdisp.c 11210]

    • ERROR => W7 (pid 3864) died [dpxxdisp.c 11210]

    • ERROR => W8 (pid 3948) died [dpxxdisp.c 11210]

    • ERROR => W9 (pid 3940) died [dpxxdisp.c 11210]

    • ERROR => W10 (pid 3972) died [dpxxdisp.c 11210]

    • ERROR => W11 (pid 3892) died [dpxxdisp.c 11210]

    • ERROR => W12 (pid 392) died [dpxxdisp.c 11210]

    • ERROR => W13 (pid 468) died [dpxxdisp.c 11210]

    • ERROR => W14 (pid 3128) died [dpxxdisp.c 11210]

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

    • DP_FATAL_ERROR => DpEnvCheck: no more work processes

    • DISPATCHER EMERGENCY SHUTDOWN ***

    • ERROR => DpMBufRead: state MBUF_PREPARED, opmode MBUF_USE [dpxxmbuf.c 503]

    • ERROR => DpModState: DpMBufRead failed (-1) [dpxxdisp.c 13129]

    Fri Nov 21 22:10:51 2008

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

    MBUF state OFF

    MBUF component DOWN

    ***LOG Q05=> DpHalt, DPStop ( 3324) [dpxxdisp.c 7637]

    /--


    dev_w0--
    /

    -


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

    -


    *

    • ACTIVE TRACE LEVEL 1

    • ACTIVE TRACE COMPONENTS all, M

    *

    B

    B Fri Nov 21 22:10:06 2008

    B create_con (con_name=R/3)

    B Loading DB library 'E:\usr\sap\P20\SYS\exe\run\dboraslib.dll' ...

    B Library 'E:\usr\sap\P20\SYS\exe\run\dboraslib.dll' loaded

    B Version of 'E:\usr\sap\P20\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.112)

    B New connection 0 created

    M

    M Fri Nov 21 22:10:07 2008

    M systemid 560 (PC with Windows NT)

    M relno 6200

    M patchlevel 0

    M patchno 251

    M intno 20020600

    M pid 3580

    M

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

    I MtxInit: -2 0 0

    X

    X Fri Nov 21 22:10:08 2008

    X EmInit: MmSetImplementation( 2 ).

    X <ES> client 0 initializing ....

    X Using implementation std

    M <EsNT> Memory Reset enabled as NT default

    X ES initialized.

    M

    M Fri Nov 21 22:10:10 2008

    M calling db_connect ...

    C Found ORACLE_HOME=E:\oracle\ora81 in Registry

    C Client NLS settings: AMERICAN_AMERICA.WE8ISO8859P1

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

    C Connecting as /@P20 on connection 0 ...

    C Attaching to DB Server P20 (con_hdl=0,svchp=065A8A08,svrhp=065A8814)

    C

    C Fri Nov 21 22:10:11 2008

    C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12500

    [dboci.c 3566]

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

    [dboci.c 9536]

    C Try to connect with default password

    C Connecting as SAPR3/<pwd>@P20 on connection 0 ...

    C Attaching to DB Server P20 (con_hdl=0,svchp=065A8A08,svrhp=065A8620)

    C

    C Fri Nov 21 22:10:12 2008

    C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12500

    [dboci.c 3566]

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

    [dboci.c 9536]

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

    B ***LOG BY2=> sql error 12500 performing CON [dblink#1 @ 419] [dblink 0419 ]

    B ***LOG BY0=> ORA-12500: TNS:listener failed to start a dedicated server process [dblink#1 @ 419] [dblink 0419 ]

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

    M in_ThErrHandle: 1

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

    M

    M Info for wp 0

    M

    M stat = 4

    M reqtype = 1

    M act_reqtype = -1

    M tid = -1

    M mode = 255

    M len = -1

    M rq_id = -1

    M rq_source = 255

    M last_tid = 0

    M last_mode = 0

    M rfc_req = 0

    M report = > <

    M action = 0

    M tab_name = > <

    M

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

    M *

    M * LOCATION SAP-Server erp_P20_00 on host erp (wp 0)

    M * ERROR tskh_init: db_connect

    M *

    M * TIME Fri Nov 21 22:10:12 2008

    M * RELEASE 620

    M * COMPONENT Taskhandler

    M * VERSION 1

    M * RC 13

    M * MODULE thxxhead.c

    M * LINE 8408

    M * COUNTER 1

    M *

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

    M

    M Entering TH_CALLHOOKS

    M ThCallHooks: call hook >SAP-Trace buffer write< for event BEFORE_DUMP

    M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

    M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 672]

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

    M Entering ThSetStatError

    M Entering ThReadDetachMode

    M call ThrShutDown (1)...

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

    /--


    tnsping P20--
    /

    TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 21-NOV-20

    08 22:13:08

    (c) Copyright 1997 Oracle Corporation. All rights reserved.

    Attempting to contact (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=erp)(POR

    T=1527))

    OK (40 msec)

    /--


    lsnrctl status--
    /

    LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on 21-NOV-2008 22:13:

    14

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=P20.WORLD))

    STATUS of the LISTENER

    -


    Alias LISTENER

    Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Produc

    tion

    Start Date 21-NOV-2008 21:00:00

    Uptime 0 days 1 hr. 13 min. 17 sec

    Trace Level off

    Security OFF

    SNMP OFF

    Listener Parameter File E:\oracle\ora81\network\admin\listener.ora

    Listener Log File E:\oracle\ora81\network\log\listener.log

    Services Summary...

    P20 has 1 service handler(s)

    The command completed successfully

    /--


    tnsnames.ora--
    /

    ################

    1. Filename......: tnsnames.ora

    2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

    3. Name..........:

    4. Date..........:

    ################

    P20.WORLD=

    (DESCRIPTION =

    (SDU = 32768)

    (ADDRESS_LIST =

    (ADDRESS =

    (COMMUNITY = SAP.WORLD)

    (PROTOCOL = TCP)

    (HOST = erp)

    (PORT = 1527)

    )

    )

    (CONNECT_DATA =

    (SID = P20)

    (GLOBAL_NAME = P20.WORLD)

    )

    )

    /--


    listener.ora--
    /

    ################

    1. Filename......: listener.ora

    2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

    3. Name..........:

    4. Date..........:

    ################

    LISTENER =

    (ADDRESS_LIST =

    (ADDRESS =

    (PROTOCOL = IPC)

    (KEY = P20.WORLD)

    )

    (ADDRESS=

    (PROTOCOL = IPC)

    (KEY = P20)

    )

    (ADDRESS =

    (COMMUNITY = SAP.WORLD)

    (PROTOCOL = TCP)

    (HOST = erp)

    (PORT = 1527)

    )

    )

    STARTUP_WAIT_TIME_LISTENER = 0

    CONNECT_TIMEOUT_LISTENER = 10

    TRACE_LEVEL_LISTENER = OFF

    SID_LIST_LISTENER =

    (SID_LIST =

    (SID_DESC =

    (SDU = 32768)

    (SID_NAME = P20)

    (ORACLE_HOME = E:\oracle\ora81)

    )

    )

    Regards,

    King.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 20, 2008 at 02:27 PM

    issue with your listener. try to start listener manually

    follow Note 443867 - ORA-12154 Collective SAP note

    cheers,

    -Sunil

    Add comment
    10|10000 characters needed characters exceeded