cancel
Showing results for 
Search instead for 
Did you mean: 

disp+work shows grey in SAPMMC

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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.

vincentlim826
Employee
Employee
0 Kudos

Hi,

Please check you have Oracle Service is running on the system.

Otherwise you have to create the service OracleService<DBSID> manually

with the following command as user <sapsid>adm:

oradim -new -sid <DBSID> -STARTMODE auto

After it is created, restart the server and try again with the SAP

start.

The errors you recieve when you connect could be due to the missing

oracle service. Further it could be due to memory exhaustion - please

check how much memory does the oracle.exe process occupy and if the

/3GB switch is active in boot.ini (if you want to use it of course)

Worse case, reinstall the oracle software (check SAP note 551542)

Regards,

Vincent

Former Member
0 Kudos

startmode should be manual.

Former Member
0 Kudos

issue with your listener. try to start listener manually

follow Note 443867 - ORA-12154 Collective SAP note

cheers,

-Sunil

Former Member
0 Kudos

Hi Sunil,

The listner is working fine.....

It says that the listener is successfully started....

Regards,

King.

former_member204746
Active Contributor
0 Kudos
ORA-12154: TNS:could not resolve service name

this means that tnsnames.ora does not contain an entry for your SID. check that out.

Former Member
0 Kudos

Hi,

Paste the results of tnsping <SID> & lsnrctl status. Also paste tnsname.ora & listener.ora file.

Tnx,

Shambo