Ver Mensaje Individual
  #11  
Viejo 01/12/11, 18:59:58
sapidesmexico sapidesmexico is offline
Member
 
Fecha de Ingreso: mar 2010
Mensajes: 51
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
Responder Con Cita