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 [oracle_br] < 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 ? > > > > >
