|
#1
|
||||
|
||||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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] |
#4
|
|||
|
|||
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 |
#5
|
||||
|
||||
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 |
#6
|
|||
|
|||
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 |
#7
|
||||
|
||||
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 |
Herramientas | Buscar en Tema |
Desplegado | |
|
|