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 ).
client 0 initializing ....
InitFreeList
block size is 1024 kByte.
Using implementation std
Memory Reset enabled as NT default
EsIUnamFileMapInit: Initialize the memory 614 MB
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 client 0 initializing ....
X Using implementation std
M 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/@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--/
################
Filename......: tnsnames.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
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--/
################
Filename......: listener.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
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.