Nops Fabrício, tirei de uma hora antes, do mesmo horário no dia anterior e no horário que começou a acontecer o problema... nada indica... :/
Att,/Regards, Vitor Jr. Infraestrutura / Infrastructure Team Oracle 11g DBA Certified Professional - OCP Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator - OCE Oracle Database 11g Performance Tuning Certified Expert - OCE Oracle Exadata 11g Certified Implementation Specialist Oracle Certified Associate, MySQL 5 mail, gtalk e msn: vitorj...@gmail.com http://certificacaobd.com.br/ skype: vjunior1981 https://mybizcard.co/vitor.jr.385628 Em 30 de dezembro de 2013 18:30, Fabricio Pedroso Jorge <fpjb...@gmail.com>escreveu: > > > Não sei se já verificastes isso, mas tenta gerar um AWR/statspack do > período anterior ao problema, e no período durante a ocorrência do > problema, pra ver tem alguma informação relevante pra gente. > > > Em 30 de dezembro de 2013 17:23, Vitor Junior <vitorj...@gmail.com>escreveu: > >> >> >> E aí Fabrício! >> >> - logs do listener sem informações relevantes >> - listeners restartados >> - alert sem informações no momento do ocorrido, log limpo >> - /var/log/messages sem incidentes no problema do ocorrido. >> >> Esse tá f0d4... hehehe >> >> >> >> Att,/Regards, >> >> >> Vitor Jr. >> Infraestrutura / Infrastructure Team >> Oracle 11g DBA Certified Professional - OCP >> Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid >> Infrastructure Administrator - OCE >> Oracle Database 11g Performance Tuning Certified Expert - OCE >> Oracle Exadata 11g Certified Implementation Specialist >> Oracle Certified Associate, MySQL 5 >> mail, gtalk e msn: vitorj...@gmail.com >> http://certificacaobd.com.br/ >> skype: vjunior1981 >> https://mybizcard.co/vitor.jr.385628 >> >> >> Em 30 de dezembro de 2013 18:20, Fabricio Pedroso Jorge < >> fpjb...@gmail.com> escreveu: >> >>> >>> >>> O log do listener mostra alguma coisa útil? >>> >>> >>> 2013/12/30 Vitor Junior <vitorj...@gmail.com> >>> >>>> >>>> >>>> Fala Ederson, tranquilo? >>>> Então, valores adicionados pelo orarun do SLES: >>>> >>>> ## added by orarun ## >>>> oracle soft nproc 2047 >>>> oracle hard nproc 16384 >>>> oracle soft nofile 1024 >>>> oracle hard nofile 65536 >>>> >>>> >>>> >>>> >>>> >>>> Att,/Regards, >>>> >>>> >>>> Vitor Jr. >>>> Infraestrutura / Infrastructure Team >>>> Oracle 11g DBA Certified Professional - OCP >>>> Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid >>>> Infrastructure Administrator - OCE >>>> Oracle Database 11g Performance Tuning Certified Expert - OCE >>>> Oracle Exadata 11g Certified Implementation Specialist >>>> Oracle Certified Associate, MySQL 5 >>>> mail, gtalk e msn: vitorj...@gmail.com >>>> http://certificacaobd.com.br/ >>>> skype: vjunior1981 >>>> https://mybizcard.co/vitor.jr.385628 >>>> >>>> >>>> Em 30 de dezembro de 2013 18:17, <ederson200...@yahoo.com.br> escreveu: >>>> >>>> >>>>> >>>>> Vitor, >>>>> >>>>> >>>>> Permita-me um palpite: >>>>> >>>>> >>>>> Já vi acontecer quando nproc e nfile estão com valores baixos. >>>>> >>>>> >>>>> Dá uma verificada, o padrão da versão 9i era: >>>>> >>>>> >>>>> /etc/security/limits.conf >>>>> >>>>> * soft nproc 2047 >>>>> >>>>> * hard nproc 16384 >>>>> >>>>> * soft nofile 1024 >>>>> >>>>> * hard nofile 65536 >>>>> >>>>> >>>>> >>>>> Ederson Elias >>>>> >>>>> DBA Oracle >>>>> >>>>> http://br.linkedin.com/pub/ederson-elias/24/8b/8b0 >>>>> >>>>> ------------ >>>>> >>>>> Labor improbus omnia vincit >>>>> >>>>> >>>> >>> >>> >>> -- >>> *Fabrício Pedroso Jorge.* >>> >>> Administrador de Banco de Dados >>> Oracle 11g Certified SQL Expert >>> Oracle 11g Certified Associate >>> Oracle 11g Certified Professional >>> Linux Professional Institute Certified Level I (LPIC-I) >>> ITIL V3 Foudations >>> certificacaodb.com.br >>> >>> *Resumo Profissional:* >>> http://br.linkedin.com/in/fabriciojorge >>> >>> *Contatos:* >>> + 55 91 88991116 >>> skype: fabricio.pedroso.jorge >>> fpjb...@gmail.com >>> >>> >> > > > -- > *Fabrício Pedroso Jorge.* > > Administrador de Banco de Dados > Oracle 11g Certified SQL Expert > Oracle 11g Certified Associate > Oracle 11g Certified Professional > Linux Professional Institute Certified Level I (LPIC-I) > ITIL V3 Foudations > certificacaodb.com.br > > *Resumo Profissional:* > http://br.linkedin.com/in/fabriciojorge > > *Contatos:* > + 55 91 88991116 > skype: fabricio.pedroso.jorge > fpjb...@gmail.com > > >
