Dispatcher no trabaja SAP ECC 6.0

[sapidesmexico]

Hola a todos tengo un SAP ECC 6.0 con Oracle 10g todo funcionaba bien durante 10 meses lo apagaba y prendía sin problema. Un día lo apagué al momento de encenderlo me marca q el dispatcher esta parado

le hice un Trace y me marca el siguiente error:

alguien podria ayudarme?

saludos


--------------------------------------------------
trc file: "dev_disp", trc level: 1, release: "701"
---------------------------------------------------
sysno 00
sid WY2
systemid 562 (PC with Windows NT)
relno 7010
patchlevel 0
patchno 32
intno 20020600
make: multithreaded, Unicode, 64 bit, optimized
pid 1564


Mon Nov 14 10:46:14 2011
kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)
length of sys_adm_ext is 576 bytes
*** SWITCH TRC-HIDE on ***
***LOG Q00=> DpSapEnvInit, DPStart (00 1564) [dpxxdisp.c 1286]
shared lib "dw_xml.dll" version 32 successfully loaded
shared lib "dw_xtc.dll" version 32 successfully loaded
shared lib "dw_stl.dll" version 32 successfully loaded
shared lib "dw_gui.dll" version 32 successfully loaded
shared lib "dw_mdm.dll" version 32 successfully loaded
rdisp/softcancel_sequence : -> 0,5,-1
use internal message server connection to port 3900

Mon Nov 14 10:46:19 2011
*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds
***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 5529]
MtxInit: 30000 0 0
DpSysAdmExtInit: ABAP is active
DpSysAdmExtInit: VMC (JAVA VM in WP) is not active
DpIPCInit2: start server >sapserverid_WY2_00 <
DpShMCreate: sizeof(wp_adm) 29792 (1752)
DpShMCreate: sizeof(tm_adm) 5912704 (29416)
DpShMCreate: sizeof(wp_ca_adm) 24064 (80)
DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080
DpShMCreate: sizeof(comm_adm) 552080 (1088)
DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
DpShMCreate: sizeof(slock_adm) 0 (104)
DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
DpShMCreate: sizeof(file_adm) 0 (72)
DpShMCreate: sizeof(vmc_adm) 0 (1864)
DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)
DpShMCreate: sizeof(gw_adm) 48
DpShMCreate: SHM_DP_ADM_KEY (addr: 00000000092B0050, size: 6614144)
DpShMCreate: allocated sys_adm at 00000000092B0050
DpShMCreate: allocated wp_adm at 00000000092B2270
DpShMCreate: allocated tm_adm_list at 00000000092B96D0
DpShMCreate: allocated tm_adm at 00000000092B9730
DpShMCreate: allocated wp_ca_adm at 000000000985CFB0
DpShMCreate: allocated appc_ca_adm at 0000000009862DB0
DpShMCreate: allocated comm_adm at 0000000009864CF0
DpShMCreate: system runs without slock table
DpShMCreate: system runs without file table
DpShMCreate: allocated vmc_adm_list at 00000000098EB980
DpShMCreate: allocated gw_adm at 00000000098EBA00
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated ca_info at 00000000098EBA30
DpShMCreate: allocated wall_adm at 00000000098EBA40
MBUF state OFF
DpCommInitTable: init table for 500 entries
rdisp/queue_size_check_value : -> off
ThTaskStatus: rdisp/reset_online_during_debug 0
EmInit: MmSetImplementation( 2 ).
MM global diagnostic options set: 0
<ES> client 0 initializing ....
<ES> InitFreeList
<ES> block size is 4096 kByte.
<ES> Info: em/initial_size_MB( 4085MB) not multiple of em/blocksize_KB( 4096KB)
<ES> Info: em/initial_size_MB rounded up to 4088MB
Using implementation view
<EsNT> Using memory model view.
<EsNT> Memory Reset disabled as NT default
<ES> 1021 blocks reserved for free list.
ES initialized.

Mon Nov 14 10:46:20 2011
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1681]
***LOG Q0K=> DpMsAttach, mscon ( sapserverid) [dpxxdisp.c 12483]
DpStartStopMsg: send start message (myname is >sapserverid_WY2_00 <)
DpStartStopMsg: start msg sent
CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.
CCMS: Initalizing shared memory of size 60000000 for monitoring segment.
CCMS: Checking Downtime Configuration of Monitoring Segment.
CCMS: start to initalize 3.X shared alert area (first segment).
DpMsgAdmin: Set release to 7010, patchlevel 0
MBUF state PREPARED
MBUF component UP
DpMBufHwIdSet: set Hardware-ID
***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1048]
DpMsgAdmin: Set patchno for this platform to 32
Release check o.K.

Mon Nov 14 10:47:00 2011
my types changed after wp death/restart 0xbf --> 0xbe
my types changed after wp death/restart 0xbe --> 0xbc
my types changed after wp death/restart 0xbc --> 0xb8
my types changed after wp death/restart 0xb8 --> 0xb0
my types changed after wp death/restart 0xb0 --> 0xa0
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=449
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Nov 14 10:47:10 2011
NiISelect: TIMEOUT occured (10000ms)
dump system status
Workprocess Table (long) Mon Nov 14 16:47:10 2011
========================

No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table
-------------------------------------------------------------------------------------------------------------------------------
0 DIA 1900 Ended no 1 0 0
1 DIA 2696 Ended no 1 0 0
2 DIA 2916 Ended no 1 0 0
3 DIA 2976 Ended no 1 0 0
4 DIA 1548 Ended no 1 0 0
5 DIA 500 Ended no 1 0 0
6 DIA 1728 Ended no 1 0 0
7 DIA 2964 Ended no 1 0 0
8 DIA 1044 Ended no 1 0 0
9 DIA 1608 Ended no 1 0 0
10 UPD 2604 Ended no 1 0 0
11 ENQ 2440 Ended no 1 0 0
12 BTC 604 Ended no 1 0 0
13 BTC 588 Ended no 1 0 0
14 BTC 1720 Ended no 1 0 0
15 SPO 2948 Ended no 1 0 0
16 UP2 2112 Ended no 1 0 0
Dispatcher Queue Statistics Mon Nov 14 16:47:10 2011
===========================

+------+--------+--------+--------+--------+--------+
| 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: Mon Nov 14 16:47:10 2011
=========================

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

Workprocess Comm. Area Blocks Mon Nov 14 16:47:10 2011
=============================

Slots: 300, Used: 1, Max: 0
+------+--------------+----------+-------------+
| id | owner | pid | eyecatcher |
+------+--------------+----------+-------------+
| 0 | DISPATCHER | -1 | *WPCAAD000* |

NiWait: sleep (5000ms) ...
NiISelect: timeout 5000ms
NiISelect: maximum fd=449
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Nov 14 10:47:15 2011
NiISelect: TIMEOUT occured (5000ms)
DpHalt: shutdown server >sapserverid_WY2_00 < (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 (2608) (SOFT_KILL)
Stop icman
killing process (2960) (SOFT_KILL)
Terminate gui connections
wait for end of work processes
wait for end of gateway
[DpProcDied] Process lives (PID:2608 HANDLE:416)
waiting for termination of gateway ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=449
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Nov 14 10:47:16 2011
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process died (PID:2608 HANDLE:416)
wait for end of icman
[DpProcDied] Process lives (PID:2960 HANDLE:424)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=449
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Nov 14 10:47:17 2011
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2960 HANDLE:424)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=449
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Nov 14 10:47:18 2011
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2960 HANDLE:424)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=449
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Nov 14 10:47:19 2011
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2960 HANDLE:424)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=449
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Nov 14 10:47:20 2011
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2960 HANDLE:424)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=449
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Nov 14 10:47:21 2011
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2960 HANDLE:424)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=449
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Nov 14 10:47:22 2011
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2960 HANDLE:424)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=449
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Nov 14 10:47:23 2011
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2960 HANDLE:424)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=449
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Nov 14 10:47:24 2011
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2960 HANDLE:424)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=449
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Nov 14 10:47:25 2011
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2960 HANDLE:424)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=449
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Nov 14 10:47:26 2011
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2960 HANDLE:424)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=449
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Nov 14 10:47:27 2011
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process died (PID:2960 HANDLE:424)
DpStartStopMsg: send stop message (myname is >sapserverid_WY2_00 <)
DpStartStopMsg: Write AD_STARTSTOP message with type= 0, name=sapserverid_WY2_00 , sapsysnr= 0, hostname=sapserverid
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 recv would block (errno=EAGAIN)
NiIPeek: peek successful for hdl 2 (r)
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)
Mon Nov 14 10:47:28 2011
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 12829]

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 340 to: ---
NiBufISelRemove: remove hdl 2 from set0
SiSelNRemove: removed sock 340 (pos=2)
SiSelNRemove: removed sock 340
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/17
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 340
NiBufIClose: clear extension for hdl 2
MsIDetach: detach MS-system
cleanup EM
EsCleanup ....
EmCleanup() -> 0
Es2Cleanup: Cleanup ES2
***LOG Q05=> DpHalt, DPStop ( 1564) [dpxxdisp.c 11045]

[jgsanz]

prueba a subirle la swap y reinicia servidor.

Si sigue fallando pon los archivos dev_disp y el w0

Saludos.

[sapidesmexico]

Hola amigo ahora lo q me hace es q el dispathcer es q se pone en verde y despues de un cierto tiempo unos 30 segundos se va a stopped.

alguna sugerencia?

gracias

[elalien]

Intenta ponernos el trace de algun workprocess

dev_w0 por ejemplo.

¿la BBDD levanta bien?

[sapidesmexico]

Hola amigo te paso la imagen zipeada de lo q me indica el dispatcher despues de el mensaje de running, message server conection ok, Dialog queue time se va a stopped

alguna sugerencia?

como le hago para sacar los traces q me indicas?

saludos

[elalien]

En la imagen que mandas solo se ve un pantallazo de la consola con todo en verde

el fichero trace de los workprocess o bien lo ves en la consola (abres los WP's y boton derecho sobre uno de ellos) o en el directorio work de sap.

[sapidesmexico]

Despues de ese pantallazo en verde despues de un rato se va a stopped. Te paso el archivo trace de dispatcher q hice despues de q se fue a stopped

gracias

[sapidesmexico]

Amigos les agrego el archivo DEV_W0

el problema se presnta de la siguiente manera.

Inicio el servidor, todo bien empieza el dispatcher a ponerse en amarillo con la leyenda

RUNNINGBUT MESSAGE SERVER UNREACHABLE

cambia a verde con la leyenda

RUNNING BUT DIALOG QUEUE STANDSTILL

posteriormente se pone en verde con el siguiente mensaje

RUNNING, MENSAGE SERVER CONNECTION OK, DIALOG QUEUE TIME: 0.0.sec

después de unos segundos se va a verder


algun comentario?

gracias





---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "701"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, MJ
*
B
B Thu Dec 01 11:22:56 2011
B create_con (con_name=R/3)
B Loading DB library 'D:\usr\sap\WY2\DVEBMGS00\exe\dboraslib.dll' ...
B Library 'D:\usr\sap\WY2\DVEBMGS00\exe\dboraslib.dll' loaded
B Version of 'D:\usr\sap\WY2\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.25)
B New connection 0 created
M sysno 00
M sid WY2
M systemid 562 (PC with Windows NT)
M relno 7010
M patchlevel 0
M patchno 32
M intno 20020600
M make: multithreaded, Unicode, 64 bit, optimized
M pid 2204
M
M kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)
M length of sys_adm_ext is 576 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2204) [dpxxdisp.c 1348]
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) 29792 (1752)
M DpShMCreate: sizeof(tm_adm) 5912704 (29416)
M DpShMCreate: sizeof(wp_ca_adm) 24064 (80)
M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080
M DpShMCreate: sizeof(comm_adm) 552080 (1088)
M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
M DpShMCreate: sizeof(slock_adm) 0 (104)
M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M DpShMCreate: sizeof(file_adm) 0 (72)
M DpShMCreate: sizeof(vmc_adm) 0 (1864)
M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000B2B0050, size: 6614144)
M DpShMCreate: allocated sys_adm at 000000000B2B0050
M DpShMCreate: allocated wp_adm at 000000000B2B2270
M DpShMCreate: allocated tm_adm_list at 000000000B2B96D0
M DpShMCreate: allocated tm_adm at 000000000B2B9730
M DpShMCreate: allocated wp_ca_adm at 000000000B85CFB0
M DpShMCreate: allocated appc_ca_adm at 000000000B862DB0
M DpShMCreate: allocated comm_adm at 000000000B864CF0
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 000000000B8EB980
M DpShMCreate: allocated gw_adm at 000000000B8EBA00
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 000000000B8EBA30
M DpShMCreate: allocated wall_adm at 000000000B8EBA40
M rdisp/queue_size_check_value : -> off
M ThTaskStatus: rdisp/reset_online_during_debug 0
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 0 initializing ....
X Using implementation view
X <EsNT> Using memory model view.
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
M
M Thu Dec 01 11:22:57 2011
M ThInit: running on host sapserverid
M
M Thu Dec 01 11:22:58 2011
M calling db_connect ...
C Prepending D:\usr\sap\WY2\DVEBMGS00\exe to Path.
C Oracle Client Version: '10.2.0.4.0'
C Client NLS setting (OCINlsGetInfo): 'AMERICAN_AMERICA.UTF8'
C Logon as OPS$-user to get SAPSR3's password
C Connecting as /@WY2 on connection 0 (nls_hdl 0) ... (dbsl 700 151208)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 0 0000000002F5F900 0000000002509500 000000000250AD28
C Attaching to DB Server WY2 (con_hdl=0,svchp=000000000250ABE8,srvhp=0000000002 F67958)
C Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=000000000250ABE8, srvhp=0000000002F67958, usrhp=0000000002F6E2B0)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033
[dboci.c 4704]
C Detaching from DB Server (con_hdl=0,svchp=000000000250ABE8,srvhp=0000000002 F67958)
C *** ERROR => CONNECT failed with sql error '1033'
[dbsloci.c 11175]
C Try to connect with default password
C Connecting as SAPSR3/<pwd>@WY2 on connection 0 (nls_hdl 0) ... (dbsl 700 151208)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 0 0000000002F5F900 0000000002509500 000000000250AD28
C Attaching to DB Server WY2 (con_hdl=0,svchp=000000000250ABE8,srvhp=0000000002 F67958)
C
C Thu Dec 01 11:22:59 2011
C Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=000000000250ABE8, srvhp=0000000002F67958, usrhp=0000000002F6E2B0)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033
[dboci.c 4704]
C Detaching from DB Server (con_hdl=0,svchp=000000000250ABE8,srvhp=0000000002 F67958)
C *** ERROR => CONNECT failed with sql error '1033'
[dbsloci.c 11175]
B ***LOG BV3=> severe db error 1033 ; work process is stopped [dbsh#2 @ 1203] [dbsh 1203 ]
B ***LOG BY2=> sql error 1033 performing CON [dblink#3 @ 431] [dblink 0431 ]
B ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [dblink#3 @ 431] [dblink 0431 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1449]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10563]
M
M Info for wp 0
M
M pid = 2204
M severity = 0
M status = 0
M stat = WP_RUN
M waiting_for = NO_WAITING
M reqtype = DP_RQ_DIAWP
M act_reqtype = NO_REQTYPE
M rq_info = 0
M tid = -1
M mode = 255
M len = -1
M rq_id = 65535
M rq_source =
M last_tid = 0
M last_mode = 0
M semaphore = 0
M act_cs_count = 0
M csTrack = 0
M csTrackRwExcl = 0
M csTrackRwShrd = 0
M mode_cleaned_counter = 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 attachedVm = no VM
M
M ************************************************** ***************************
M *
M * LOCATION SAP-Server sapserverid_WY2_00 on host sapserverid (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Thu Dec 01 11:22:59 2011
M * RELEASE 701
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 10783
M * COUNTER 1
M *
M ************************************************** ***************************
M
M PfStatDisconnect: disconnect statistics
M Entering TH_CALLHOOKS
M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP
M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 723]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 261]
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 2204) [dpnttool.c 334]

[sapidesmexico]

Les dejo los errores que obtuve de oracle

Dump file d:\oracle\wy2\saptrace\usertrace\wy2_ora_2084.trc
Thu Dec 01 11:22:40 2011
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V5.2 Service Pack 2
CPU : 2 - type 8664, 1 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:3269M/4085M, Ph+PgF:60680M/61730M
Instance name: wy2

Redo thread mounted by this instance: 1

Oracle process number: 14

Windows thread id: 2084, image: ORACLE.EXE (SHAD)


*** ACTION NAME) 2011-12-01 11:22:40.406
*** MODULE NAMEsqlplus.exe) 2011-12-01 11:22:40.406
*** SERVICE NAME) 2011-12-01 11:22:40.406
*** SESSION ID149.3) 2011-12-01 11:22:40.406
Successfully allocated 2 recovery slaves
Using 66 overflow buffers per recovery slave
Thread 1 checkpoint: logseq 22289, block 2, scn 1375672039
cache-low rba: logseq 22289, block 10372
on-disk rba: logseq 22289, block 29850, scn 1375698286
start recovery at logseq 22289, block 10372, scn 0
*** 2011-12-01 11:22:43.031
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kcrfr_update_nab_2], [0x7FFA78E7008], [2], [], [], [], [], []
Current SQL statement for this session:
ALTER DATABASE OPEN
check trace file d:\oracle\product\10.2.0\db_1\rdbms\trace\wy2_ora_ 0.trc for preloading .sym file messages

[elalien]

Está claro que el problema lo tienes en la BBDD Oracle.

Intenta levantarla desde sqlplus y a ver que te dice.

Mira tambien y pon aqui si quieres el ficehero de alertas de oracle. Si es muy grande no lo pongas entero, pon lo que te aparezca desde que intentas arrancar

[sapidesmexico]

disculpa la pregunta como podría hacerle para levantarla desde sql?? me podrían dar una orientada?

esto es la parte de un archivo

kwqmnich: initialized job cache structure
Dump file d:\oracle\wy2\saptrace\usertrace\wy2_ora_2084.trc
Thu Dec 01 11:22:40 2011
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V5.2 Service Pack 2
CPU : 2 - type 8664, 1 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:3269M/4085M, Ph+PgF:60680M/61730M
Instance name: wy2

Redo thread mounted by this instance: 1

Oracle process number: 14

Windows thread id: 2084, image: ORACLE.EXE (SHAD)


*** ACTION NAME) 2011-12-01 11:22:40.406
*** MODULE NAMEsqlplus.exe) 2011-12-01 11:22:40.406
*** SERVICE NAME) 2011-12-01 11:22:40.406
*** SESSION ID149.3) 2011-12-01 11:22:40.406
Successfully allocated 2 recovery slaves
Using 66 overflow buffers per recovery slave
Thread 1 checkpoint: logseq 22289, block 2, scn 1375672039
cache-low rba: logseq 22289, block 10372
on-disk rba: logseq 22289, block 29850, scn 1375698286
start recovery at logseq 22289, block 10372, scn 0
*** 2011-12-01 11:22:43.031
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kcrfr_update_nab_2], [0x7FFA78E7008], [2], [], [], [], [], []
Current SQL statement for this session:
ALTER DATABASE OPEN
check trace file d:\oracle\product\10.2.0\db_1\rdbms\trace\wy2_ora_ 0.trc for preloading .sym file messages
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp+663 CALL??? ksedst+55 003C878B8 000000000 010ED63E8
000000000
ksfdmp+19 CALL??? ksedmp+663 000000003 00ED90E90 010943498
003CACC80
kgerinv+158 CALL??? ksfdmp+19 00ED90850 000000000 0FFFFFFFF
000000000
kgeasnmierr+62 CALL??? kgerinv+158 000000000 000000000 000000000
004F8788F
kcrfr_update_nab+18 CALL??? kgeasnmierr+62 0102F0938 000000000 000000000
6 000000002
kcrfr_read+1078 CALL??? kcrfr_update_nab+18 010943498 00001E650 00ED90850
6 0109437B8
kcrfrgv+13892 CALL??? kcrfr_read+1078 000000000 0051025D7 000000000
0051025D7
kcratr1+488 CALL??? kcrfrgv+13892 010943498 000000000 000000000
000000000
kcratr+412 CALL??? kcratr1+488 010ED91C8 010ED90A4 01096FFB8
0105F7FF0
kctrec+1910 CALL??? kcratr+412 010ED91C8 010EE1E18 000000000
010EE1E48
kcvcrv+3585 CALL??? kctrec+1910 010EE2C58 000000000 01052B1E0
01052B9F8
kcfopd+1007 CALL??? kcvcrv+3585 010EE3350 000000000 000000000
000000000
adbdrv+55820 CALL??? kcfopd+1007 000000000 000000000 000000000
000000000
opiexe+13897 CALL??? adbdrv+55820 000000023 000000003 000000102
000000000
opiosq0+3558 CALL??? opiexe+13897 000000004 000000000 010EEB238
4D4127203D454741
kpooprx+339 CALL??? opiosq0+3558 000000003 00000000E 010EEB3C8
0000000A4
kpoal8+894 CALL??? kpooprx+339 00EDA5970 000000018 0041AE700
000000001
opiodr+1136 CALL??? kpoal8+894 00000005E 000000017 010EEE868
00B71D748
ttcpip+5146 CALL??? opiodr+1136 00000005E 000000017 010EEE868
B07000000000
opitsk+1818 CALL??? ttcpip+5146 00EDA5970 000000000 000000000
000000000
opiino+1129 CALL??? opitsk+1818 00000001E 000000000 010EEEDD0
004F56480
opiodr+1136 CALL??? opiino+1129 00000003C 000000004 010EEFB20
000000000
opidrv+815 CALL??? opiodr+1136 00000003C 000000004 010EEFB20
000000000
sou2o+52 CALL??? opidrv+815 00000003C 000000004 010EEFB20
7FF7FC48580
opimai_real+131 CALL??? sou2o+52 000000002 000000000
7FFFFF95258 077EF4D1C
opimai+96 CALL??? opimai_real+131 7FF7FC48580 7FFFFF94000
0001F0003 000000000
OracleThreadStart+6 CALL??? opimai+96 010EEFEF0 010BEFF3C 010EEFCC0
40 7FF7FC48580
0000000077D6B6DA CALL??? OracleThreadStart+6 010BEFF3C 000000000 000000000
40 010EEFFA8





aqui va la parte del otro

****************************

*** 2011-11-24 12:08:45.093
===== begin preloading .sym files
===== end preloading .sym files
Dump file d:\oracle\product\10.2.0\db_1\rdbms\trace\wy2_ora_ 0.trc
Tue Nov 29 13:12:10 2011
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
Windows NT Version V5.2 Service Pack 2
CPU : 2 - type 8664, 1 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:3370M/4085M, Ph+PgF:58418M/58730M
Instance name: wy2

Redo thread mounted by this instance: 0 <none>

Oracle process number: 0

Windows thread id: 2300, image: ORACLE.EXE


*** 2011-11-29 13:12:10.701
===== begin preloading .sym files
===== end preloading .sym files
Dump file d:\oracle\product\10.2.0\db_1\rdbms\trace\wy2_ora_ 0.trc
Thu Dec 01 11:21:53 2011
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
Windows NT Version V5.2 Service Pack 2
CPU : 2 - type 8664, 1 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:3397M/4085M, Ph+PgF:61419M/61730M
Instance name: wy2

Redo thread mounted by this instance: 0 <none>

Oracle process number: 0

Windows thread id: 2600, image: ORACLE.EXE


*** 2011-12-01 11:21:53.671
===== begin preloading .sym files
===== end preloading .sym files

[elalien]

entras con el usuario administrador de sap

abres una ventana cmd

c:> sqlplus /nolog

connect / as sysdba

startup

y miras a ver que te dice. si te dice que esta levantada o a medio levantar la bajas:

shutdown immediate

y la vuelves a intentar levantar.


y lo que nos tienes que poner es el fichero de alertas de Oracle, normalmente se llama alert<SID>.log

[sapidesmexico]

Hola el fichero de oracle pesa 10.2 mb

me tomé la libertad de subirlo a mediafire.

la direccion es

http://www.mediafire.com/file/2e93qvm421m6ed4/alert_wy2.log

intenté hacer el procedimiento pero me marca el error siguiente q te pongo en el archivo .gif

ORA-12560: TNS protocol adapter error


gracias por su ayuda

[sapidesmexico]

REvisando el archivo me dice q los errores se van a los archivos siguientes

los archivos q menciona el log son los siguientes:

http://www.mediafire.com/file/7i1tt5m924k7h5a/wy2_ora_2084.trc

y abriendo ese archivo me dice q en el archivo

wy2_ora_0

el cual pongo en la siguiente liga

http://www.mediafire.com/file/aqs70bedwg06dhh/wy2_ora_0.trc

segun el archivo 2084 el error es el siguiente

*** 2011-12-01 11:22:43.031
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kcrfr_update_nab_2], [0x7FFA78E7008], [2], [], [], [], [], []

leyendo en google es algun error en la BD, si es asi como podría recuperarla o no se si solo tenga q reinstalarla

gracias por sus aportes
Current SQL statement for this session:
ALTER DATABASE OPEN
check trace file d:\oracle\product\10.2.0\db_1\rdbms\trace\wy2_ora_ 0.trc for preloading .sym file messages