{"id":968,"date":"2015-06-04T11:17:57","date_gmt":"2015-06-04T09:17:57","guid":{"rendered":"http:\/\/fougere.myds.me:8080\/info\/?p=968"},"modified":"2015-06-04T11:17:57","modified_gmt":"2015-06-04T09:17:57","slug":"ora_alertlog-sh","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2015\/06\/04\/ora_alertlog-sh\/","title":{"rendered":"ora_alertlog.sh"},"content":{"rendered":"<pre>#!\/bin\/sh\necho \"----------------------------------------------\"\necho \" Recherche des erreurs dans les log\"\necho \"----------------------------------------------\"\necho \" \"<\/pre>\n<pre>fic=$1 # nom du fichier\nmonth=$2 # mois recherch\u00e9\nyear=$3 # ann\u00e9e recherch\u00e9e\nday=$4 # jour recherch\u00e9\nerror=\"$5\" # chaine erreur<\/pre>\n<pre>#fic=\/soft\/oracle\/admin\/BIPROD\/bdump\/alert_BIPROD.log\n#month=DEC\n#year=2013\n#day=30\n#error=\"ORA-\"<\/pre>\n<pre># On transforme le mois de MAJUSCULE en minuscule puis on passe la premi\u00e8re lettre en Majuscule\nmonth=`echo $month|tr \"A-Z\" \"a-z\"|sed 's\/^.\/\\u&amp;\/'`\nday=`echo $day | tr \"0\" \" \" | sed 's\/^.\/\\u&amp;\/'`<\/pre>\n<pre>echo \"File : $fic\"\necho \"month : $month\"\necho \"year : $year\"\necho \"day : $day\"\necho \"error : $error\"<\/pre>\n<pre>nbligne=`wc $fic | awk '{print $1}'`\necho \"nom de lignes dans le fichier log : \" $nbligne<\/pre>\n<pre>echo \"grep -n '... $month $day ........ $year' $fic |head -1 | awk -F ':' '{print $1}'\"\nnumligne=`grep -n \"... $month $day ........ $year\" $fic |head -1 | awk -F ':' '{print $1}'`\necho \"Numero de la ligne de la date demand\u00e9e : \" $numligne<\/pre>\n<pre># on compte le nombre d'erreurs trouv\u00e9es et on affiche les 5 lignes suivantes du log\necho \"tail -n +$numligne $fic| grep $error |wc -l\"\ncpt=`tail -n +$numligne $fic| grep -v WARNING |grep $error |wc -l`\nif [ $cpt == 0 ]; then\n # si pas d'erreur on sort\n exit 0\nelse\n # On affiche les erreur pour le log Vtom\n echo \"tail -n +$numligne $fic | grep -C 5 $error\"\n tail -n +$numligne $fic |grep -v WARNING| grep -C 5 $error\n exit $cpt\nfi<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>#!\/bin\/sh echo &laquo;&nbsp;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-&nbsp;&raquo; echo &nbsp;&raquo; Recherche des erreurs dans les log&nbsp;&raquo; echo &laquo;&nbsp;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-&nbsp;&raquo; echo &nbsp;&raquo; &nbsp;&raquo; fic=$1 # nom du fichier month=$2 # mois recherch\u00e9 year=$3 # ann\u00e9e recherch\u00e9e day=$4 # jour recherch\u00e9 error=&nbsp;&raquo;$5&Prime; # chaine erreur #fic=\/soft\/oracle\/admin\/BIPROD\/bdump\/alert_BIPROD.log #month=DEC #year=2013 #day=30 #error=&nbsp;&raquo;ORA-&nbsp;&raquo; # On transforme le mois de MAJUSCULE en minuscule puis on passe la &hellip; <a href=\"http:\/\/les-fougs.com\/wordpress\/2015\/06\/04\/ora_alertlog-sh\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;ora_alertlog.sh&nbsp;&raquo;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[53,37],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/968"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=968"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/968\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=968"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=968"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=968"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}