Boa tarde Alisson. Esse tal erro ora 600 novamente... Eu mesmo já abri um tópico sobre isso, e a maioria das respostas que você vai encontrar sobre isso é abrir um SR, tem que abrir um chamado pra Oracle.
No meu caso era um bug mesmo, no Datapump, quando fazia o impdp aparecia esse erro ora600 e descobriram que a placa mãe, as configurações de ambiente do SO não estavam batendo... Nós trocamos a máquina e funcionou, mas seu caso deve ser outro, vamos esperar alguém se pronunciar. ________________________________ De: alisson <[email protected]> Para: [email protected] Enviadas: Quarta-feira, 30 de Maio de 2012 14:39 Assunto: [oracle_br] ERROR: UGA memory leak detected ---- Alert.Log Olá amigos ... Estou com um log de alerta no meu servidor... Configuração: S.O : Windows Server 2008 R2 Entreprise 64 - Service pack 1 12gb RAM Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production OS logs de alertas começaram ontem e vi em alguns forum oracle que é um erro que pode ser ignorando e em alguns falou sobre reiniciar que deve ser resolvido o problema. Pelo que observei é um vasamento de memoria e isso acontece quando o datadump é executado por scripts rman.. Ontem dei um shutdown na base de dados e o mesmo parou de gerar o erro e hoje as 12:12 retornou o alerta. Bom segue o erro no alert. ###################################################################### Wed May 30 12:12:00 2012 Errors in file c:\app\administrator\diag\rdbms\bdeducar\bdeducar\trace\bdeducar_j000_5872.trc (incident=108282): ORA-00600: código de erro interno, argumentos: [729], [17064], [space leak], [], [], [], [], [], [], [], [], [] Incident details in: c:\app\administrator\diag\rdbms\bdeducar\bdeducar\incident\incdir_108282\bdeducar_j000_5872_i108282.trc Errors in file c:\app\administrator\diag\rdbms\bdeducar\bdeducar\trace\bdeducar_j000_5872.trc: ORA-00600: código de erro interno, argumentos: [729], [17064], [space leak], [], [], [], [], [], [], [], [], [] Wed May 30 12:12:01 2012 Trace dumping is performing id=[cdmp_20120530121201] Wed May 30 12:12:11 2012 Sweep Incident[108282]: completed Wed May 30 12:33:07 2012 Thread 1 advanced to log sequence 6025 (LGWR switch) Current log# 1 seq# 6025 mem# 0: C:\APP\ADMINISTRATOR\ORADATA\BDEDUCAR\REDO01.LOG Wed May 30 13:00:16 2012 Thread 1 advanced to log sequence 6026 (LGWR switch) Current log# 2 seq# 6026 mem# 0: C:\APP\ADMINISTRATOR\ORADATA\BDEDUCAR\REDO02.LOG Wed May 30 13:00:53 2012 Thread 1 advanced to log sequence 6027 (LGWR switch) Current log# 4 seq# 6027 mem# 0: C:\APP\ADMINISTRATOR\ORADATA\BDEDUCAR\REDO04.LOG Wed May 30 13:31:43 2012 Errors in file c:\app\administrator\diag\rdbms\bdeducar\bdeducar\trace\bdeducar_j000_2296.trc (incident=108010): ORA-00600: código de erro interno, argumentos: [729], [17064], [space leak], [], [], [], [], [], [], [], [], [] Incident details in: c:\app\administrator\diag\rdbms\bdeducar\bdeducar\incident\incdir_108010\bdeducar_j000_2296_i108010.trc Errors in file c:\app\administrator\diag\rdbms\bdeducar\bdeducar\trace\bdeducar_j000_2296.trc: ORA-00600: código de erro interno, argumentos: [729], [17064], [space leak], [], [], [], [], [], [], [], [], [] Wed May 30 13:31:46 2012 Trace dumping is performing id=[cdmp_20120530133146] Wed May 30 13:31:48 2012 Sweep Incident[108010]: completed Wed May 30 14:01:42 2012 Errors in file c:\app\administrator\diag\rdbms\bdeducar\bdeducar\trace\bdeducar_j000_5204.trc (incident=107802): ORA-00600: código de erro interno, argumentos: [729], [9144], [space leak], [], [], [], [], [], [], [], [], [] Incident details in: c:\app\administrator\diag\rdbms\bdeducar\bdeducar\incident\incdir_107802\bdeducar_j000_5204_i107802.trc Errors in file c:\app\administrator\diag\rdbms\bdeducar\bdeducar\trace\bdeducar_j000_5204.trc: ORA-00600: código de erro interno, argumentos: [729], [9144], [space leak], [], [], [], [], [], [], [], [], [] Wed May 30 14:01:43 2012 Trace dumping is performing id=[cdmp_20120530140143] Wed May 30 14:01:47 2012 Sweep Incident[107802]: completed ********************************************************************** Segue o arquivo bdeducar_j000_5872.trc ###################################################################### Trace file c:\app\administrator\diag\rdbms\bdeducar\bdeducar\trace\bdeducar_j000_2296.trc Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Windows NT Version V6.1 Service Pack 1 CPU : 6 - type 8664, 6 Physical Cores Process Affinity : 0x0000000000000000 Memory (Avail/Total): Ph:6733M/12227M, Ph+PgF:18799M/24453M Instance name: bdeducar Redo thread mounted by this instance: 1 Oracle process number: 53 Windows thread id: 2296, image: ORACLE.EXE (J000) *** 2012-05-30 13:31:43.381 *** SESSION ID:(336.5490) 2012-05-30 13:31:43.381 *** CLIENT ID:() 2012-05-30 13:31:43.381 *** SERVICE NAME:(SYS$USERS) 2012-05-30 13:31:43.381 *** MODULE NAME:() 2012-05-30 13:31:43.381 *** ACTION NAME:() 2012-05-30 13:31:43.381 Incident 108010 created, dump file: c:\app\administrator\diag\rdbms\bdeducar\bdeducar\incident\incdir_108010\bdeducar_j000_2296_i108010.trc ORA-00600: código de erro interno, argumentos: [729], [17064], [space leak], [], [], [], [], [], [], [], [], [] ORA-00600: código de erro interno, argumentos: [729], [17064], [space leak], [], [], [], [], [], [], [], [], [] ###################################################################### Dump file c:\app\administrator\diag\rdbms\bdeducar\bdeducar\incident\incdir_108010\bdeducar_j000_2296_i108010.trc Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Windows NT Version V6.1 Service Pack 1 CPU : 6 - type 8664, 6 Physical Cores Process Affinity : 0x0000000000000000 Memory (Avail/Total): Ph:6733M/12227M, Ph+PgF:18799M/24453M Instance name: bdeducar Redo thread mounted by this instance: 1 Oracle process number: 53 Windows thread id: 2296, image: ORACLE.EXE (J000) *** 2012-05-30 13:31:43.381 *** SESSION ID:(336.5490) 2012-05-30 13:31:43.381 *** CLIENT ID:() 2012-05-30 13:31:43.381 *** SERVICE NAME:(SYS$USERS) 2012-05-30 13:31:43.381 *** MODULE NAME:() 2012-05-30 13:31:43.381 *** ACTION NAME:() 2012-05-30 13:31:43.381 Dump continued from file: c:\app\administrator\diag\rdbms\bdeducar\bdeducar\trace\bdeducar_j000_2296.trc ORA-00600: código de erro interno, argumentos: [729], [17064], [space leak], [], [], [], [], [], [], [], [], [] ========= Dump for incident 108010 (ORA 600 [729]) ======== ----- Beginning of Customized Incident Dump(s) ----- ******** ERROR: UGA memory leak detected 17064 ******** ****************************************************** HEAP DUMP heap name="session heap" desc=0000000024308078 extent sz=0xff80 alt=32767 het=32767 rec=0 flg=3 opc=3 parent=000000002524A990 owner=0000000378920778 nex=0000000000000000 xsz=0xff80 heap=0000000000000000 fl2=0x60, nex=0000000000000000 EXTENT 0 addr=0000000031A80080 Chunk 031a80090 sz= 65392 free " " EXTENT 1 addr=0000000035700080 Chunk 035700090 sz= 10040 perm "perm " alo=2592 Chunk 0357027c8 sz= 4024 free " " Chunk 035703780 sz= 472 freeable "hssc hokoc/3 " [As partes desta mensagem que não continham texto foram removidas]
