Olá boa tarde!
Ela tem um storage conectada a ela e é ASM, Stande Alone.. Tem backup sim. Na verdade o ASM estava ativo ... Fri Sep 23 12:27:02 2016 Errors in file c:\app\administrator\diag\rdbms\bdeducar\bdeducar\trace\bdeducar_cjq0_6948.trc (incident=684822): Olhei as conexões com o Storage tudo ok.. De: oracle_br@yahoogrupos.com.br [mailto:oracle_br@yahoogrupos.com.br] Enviada em: sexta-feira, 23 de setembro de 2016 14:48 Para: oracle_br@yahoogrupos.com.br Assunto: Re: [oracle_br] Ajuda Erro ORA-00445: background process "J000" did not start after 120 seconds Boa tarde Essa maquina está ligada a algum storage e usando ASM ? É RAC ou stand alone ? Tem backup ? Parece que caiu a conexao com o ASM, por isso pipocando as mensagens de erro.. ORA-15064: communication failure with ASM instance On 23 September 2016 at 14:14, alisson...@yahoo.com.br <mailto:alisson...@yahoo.com.br> [oracle_br] <oracle_br@yahoogrupos.com.br <mailto:oracle_br@yahoogrupos.com.br> > wrote: boa tarde Senhores. Hoje comecei a receber erros (ORA-00445: background process "J000" did not start after 120 seconds) e com isso o banco parou , tive que levanta-lo novamente. Meu ambiente encontrasse em Windows server 2012 R2, temos 128G de memorias. versão do Oracle Sendo a versão do oracle 11r . parallel_servers_target integer 224 memory_target big integer 78336M memory_max_target big integer 78336M RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE processes 388 453 3000 3000 sessions 401 480 4536 4536 enqueue_locks 532 590 52700 52700 enqueue_resources 136 157 20176 UNLIMITED ges_procs 0 0 0 0 ges_ress 0 0 0 UNLIMITED ges_locks 0 0 0 UNLIMITED ges_cache_ress 0 0 0 UNLIMITED ges_reg_msgs 0 0 0 UNLIMITED ges_big_msgs 0 0 0 UNLIMITED ges_rsv_msgs 0 0 0 0 gcs_resources 0 0 0 0 gcs_shadows 0 0 0 0 dml_locks 3 3 19956 UNLIMITED temporary_table_locks 0 0 UNLIMITED UNLIMITED transactions 4 4 4989 UNLIMITED branches 0 2 4989 UNLIMITED cmtcallbk 0 1 4989 UNLIMITED max_rollback_segments 24 24 4989 65535 sort_segment_locks 92 103 UNLIMITED UNLIMITED k2q_locks 0 0 9072 UNLIMITED max_shared_servers 1 1 UNLIMITED UNLIMITED parallel_max_servers 0 32 560 3600 Bom o erro começou aqui e no momento do erro não vi processamento e nem memoria alta ... ORA-03113: end-of-file on communication channelORA-15064: communication failure with ASM instanceErrors in file c:\app\administrator\diag\rdbms\bdeducar\bdeducar\trace\bdeducar_asmb_5144.trc:NOTE: ASMB terminatingFri Sep 23 12:31:12 2016Incident details in: c:\app\administrator\diag\rdbms\bdeducar\bdeducar\incident\incdir_684734\bdeducar_arc1_6372_i684734.trcORA-00240: control file enqueue held for more than 120 secondsErrors in file c:\app\administrator\diag\rdbms\bdeducar\bdeducar\trace\bdeducar_arc1_6372.trc (incident=684734):Fri Sep 23 12:31:11 2016Trace dumping is performing id=[cdmp_20160923122908]Fri Sep 23 12:29:08 2016 Current log# 1 seq# 184145 mem# 3: E:\BDEDUCAR\ONLINELOG\O1_MF_1_C54Q6NK8_.LOG Current log# 1 seq# 184145 mem# 2: +DATA/bdeducar/onlinelog/group_1.355.896477093 Current log# 1 seq# 184145 mem# 1: C:\APP\REDO\REDO01A.LOG Current log# 1 seq# 184145 mem# 0: E:\REDO\REDO01A.LOGThread 1 advanced to log sequence 184145 (LGWR switch)Incident details in: c:\app\administrator\diag\rdbms\bdeducar\bdeducar\incident\incdir_684623\bdeducar_lgwr_6700_i684623.trcORA-00445: background process "O000" did not start after 120 secondsErrors in file c:\app\administrator\diag\rdbms\bdeducar\bdeducar\trace\bdeducar_lgwr_6700.trc (incident=684623):Fri Sep 23 12:29:07 2016Trace dumping is performing id=[cdmp_20160923122759]Fri Sep 23 12:27:59 2016Incident details in: c:\app\administrator\diag\rdbms\bdeducar\bdeducar\incident\incdir_684622\bdeducar_lgwr_6700_i684622.trcORA-00240: control file enqueue held for more than 120 secondsErrors in file c:\app\administrator\diag\rdbms\bdeducar\bdeducar\trace\bdeducar_lgwr_6700.trc (incident=684622):Fri Sep 23 12:27:58 2016Trace dumping is performing id=[cdmp_20160923122703]Fri Sep 23 12:27:03 2016Errors in file c:\app\administrator\diag\rdbms\bdeducar\bdeducar\trace\bdeducar_cjq0_6948.trc:kkjcre1p: unable to spawn jobq slave process Incident details in: c:\app\administrator\diag\rdbms\bdeducar\bdeducar\incident\incdir_684822\bdeducar_cjq0_6948_i684822.trcORA-00445: background process "J000" did not start after 120 secondsErrors in file c:\app\administrator\diag\rdbms\bdeducar\bdeducar\trace\bdeducar_cjq0_6948.trc (incident=684822):Fri Sep 23 12:27:02 2016 Alguem já passou por esse problema ?
