{"id":976,"date":"2015-06-04T11:22:07","date_gmt":"2015-06-04T09:22:07","guid":{"rendered":"http:\/\/fougere.myds.me:8080\/info\/?p=976"},"modified":"2015-06-04T11:22:07","modified_gmt":"2015-06-04T09:22:07","slug":"start_database-sh","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2015\/06\/04\/start_database-sh\/","title":{"rendered":"start_database.sh"},"content":{"rendered":"<pre>#!\/bin\/bash\n# ==================================================\n# Nom : start_database.sh\n# Objet : demarrage d'une base de donnees\n# Cree le : 28\/01\/2010\n# Syntaxe : start_database.sh database_name\n# ==================================================<\/pre>\n<pre># ----------------------------------\n# Fonction d'affichage de la syntaxe\n# ----------------------------------\nsyntaxe()\n{\n echo \"Usage : $0 database_name\"\n}<\/pre>\n<pre># --------------------------\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>export ORACLE_SID=${w_instance}\necho $ORACLE_SID\n# export NLS_DATE_FORMAT=YYYY.MM.DD.HH24.MI.SS<\/pre>\n<pre>w_prog=`basename $0 .sh`\nw_date=$(date '+%Y_%m_%d_%H_%M_%S')<\/pre>\n<pre>w_log_dest=\/exploit\/logs\nw_log_file=$w_log_dest\/${w_date}_${w_prog}_${w_instance}.log;<\/pre>\n<pre>sqlplus \/nolog &lt;&lt;EOSQL &gt;&gt;$w_log_file 2&gt;&amp;1\nconnect \/ as sysdba\nstartup;\nselect NAME, CREATED,LOG_MODE,OPEN_MODE from v\\$database;\nexit\nEOSQL<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>#!\/bin\/bash # ================================================== # Nom : start_database.sh # Objet : demarrage d&rsquo;une base de donnees # Cree le : 28\/01\/2010 # Syntaxe : start_database.sh database_name # ================================================== # &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- # Fonction d&rsquo;affichage de la syntaxe # &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- syntaxe() { echo &laquo;&nbsp;Usage : $0 database_name&nbsp;&raquo; } # &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; # Verification de la syntaxe # &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; if &hellip; <a href=\"http:\/\/les-fougs.com\/wordpress\/2015\/06\/04\/start_database-sh\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;start_database.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\/976"}],"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=976"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/976\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=976"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}