on 11-20-2008 2:15 PM
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....
/--
-
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]
/--
-
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.
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.........
/--
-
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]
/--
-
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]
/--
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 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
/--
################
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)
)
)
/--
################
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
issue with your listener. try to start listener manually
follow Note 443867 - ORA-12154 Collective SAP note
cheers,
-Sunil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.