Dispatcher no trabaja SAP ECC 6.0

[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=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]

[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