{"id":980,"date":"2015-06-04T11:23:34","date_gmt":"2015-06-04T09:23:34","guid":{"rendered":"http:\/\/fougere.myds.me:8080\/info\/?p=980"},"modified":"2015-06-04T11:23:34","modified_gmt":"2015-06-04T09:23:34","slug":"ora_compilation-sh","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2015\/06\/04\/ora_compilation-sh\/","title":{"rendered":"ora_compilation.sh"},"content":{"rendered":"<pre>#!\/bin\/bash<\/pre>\n<pre>\n# --------------------------\n# Verification de la syntaxe\n# --------------------------\nif [ $# -ne 1 ]\nthen\n echo \"==================================================\"\n echo \"ERREUR : Nombre d'arguments incorrects !\"\n syntaxe\n echo \"==================================================\"\n exit 1\nfi<\/pre>\n<pre># --------------------------\n# Verification des arguments\n# --------------------------\nw_instance=$1\nv_res=`grep \"${w_instance}\" \/etc\/oratab | wc -l`\nv_res=`expr ${v_res}`\nif [ ${v_res} -eq 0 ]\nthen\n echo \"==================================================\"\n echo \"ERREUR : Base de donnees [${w_instance}] inexistante !\"\n syntaxe\n echo \"==================================================\"\n exit 1\nfi<\/pre>\n<pre>echo \"SID=${w_instance}\"\nexport ORACLE_SID=${w_instance}<\/pre>\n<pre>ls \/soft\/oracle\/db102\/rdbms\/admin\/utlrp.sql\nerr_fic=$?<\/pre>\n<pre>if [ \"${err_fic}\" != \"0\" ]\nthen\n echo Fichier absent.\n exit ${err_fic}\nfi\nexport ORACLE_SID=$1<\/pre>\n<pre>echo \"recompile tous les objets invalides\" ${ORACLE_SID}<\/pre>\n<pre>sqlplus \/nolog &lt;&lt;EOF\n connect \/ as sysdba\n WHENEVER SQLERROR EXIT SQL.SQLCODE\n SELECT owner#,name,status,ctime,mtime,stime FROM obj$ WHERE status IN (4, 5, 6);<\/pre>\n<pre>start \/soft\/oracle\/db102\/rdbms\/admin\/utlrp.sql<\/pre>\n<pre>SELECT job_name FROM dba_scheduler_running_jobs WHERE job_name like 'UTL_RECOMP_SLAVE_%';<\/pre>\n<pre>exit\n EOF<\/pre>\n<pre>exit ${err_sql}<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>#!\/bin\/bash # &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; # Verification de la syntaxe # &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; if [ $# -ne 1 ] then echo &laquo;&nbsp;==================================================&nbsp;&raquo; echo &laquo;&nbsp;ERREUR : Nombre d&rsquo;arguments incorrects !&nbsp;&raquo; syntaxe echo &laquo;&nbsp;==================================================&nbsp;&raquo; exit 1 fi # &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; # Verification des arguments # &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; w_instance=$1 v_res=`grep &laquo;&nbsp;${w_instance}&nbsp;&raquo; \/etc\/oratab | wc -l` v_res=`expr ${v_res}` if [ ${v_res} -eq 0 ] &hellip; <a href=\"http:\/\/les-fougs.com\/wordpress\/2015\/06\/04\/ora_compilation-sh\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;ora_compilation.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\/980"}],"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=980"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/980\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=980"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=980"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=980"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}