|
Dispatcher no trabaja SAP ECC 6.0
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] |
prueba a subirle la swap y reinicia servidor.
Si sigue fallando pon los archivos dev_disp y el w0 Saludos. |
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 |
Intenta ponernos el trace de algun workprocess
dev_w0 por ejemplo. ¿la BBDD levanta bien? |
1 Adjunto(s)
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 |
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. |
1 Adjunto(s)
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 |
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=0000000002F67958) 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=0000000002F67958) 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=0000000002F67958) 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=0000000002F67958) 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] |
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 NAME:(sqlplus.exe) 2011-12-01 11:22:40.406 *** SERVICE NAME:() 2011-12-01 11:22:40.406 *** SESSION ID:(149.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 |
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 |
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 NAME:(sqlplus.exe) 2011-12-01 11:22:40.406 *** SERVICE NAME:() 2011-12-01 11:22:40.406 *** SESSION ID:(149.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 |
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 |
1 Adjunto(s)
Hola el fichero de oracle pesa 10.2 mb
me tomé la libertad de subirlo a mediafire. la direccion es 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 |
REvisando el archivo me dice q los errores se van a los archivos siguientes
los archivos q menciona el log son los siguientes: y abriendo ese archivo me dice q en el archivo wy2_ora_0 el cual pongo en la siguiente liga 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 |
| Husos Horarios son GMT. La hora en este momento es 02:09:27. |
www.mundosap.com 2006 - Spain
software crm, crm on demand, software call center, crm act, crm solutions, crm gratis, crm web