{"id":2822,"date":"2018-02-03T14:04:48","date_gmt":"2018-02-03T05:04:48","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2822"},"modified":"2018-02-03T14:04:48","modified_gmt":"2018-02-03T05:04:48","slug":"h-a-%ed%81%b4%eb%9f%ac%ec%8a%a4%ed%84%b0-%ed%99%98%ea%b2%bd%ec%97%90%ec%84%9c-%ec%98%a4%eb%9d%bc%ed%81%b4-%ea%b8%b0%eb%8f%99-%ec%a4%91%ec%a7%80-%ec%89%98-%ec%8a%a4%ed%81%ac%eb%a6%bd%ed%8a%b8","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2822","title":{"rendered":"H\/A \ud074\ub7ec\uc2a4\ud130 \ud658\uacbd\uc5d0\uc11c \uc624\ub77c\ud074 \uae30\ub3d9 \uc911\uc9c0 \uc258 \uc2a4\ud06c\ub9bd\ud2b8"},"content":{"rendered":"<p>&nbsp;<\/p>\n<pre class=\"theme:eclipse lang:plsql decode:true  \">\r\n###########################\uc815\uc9c0\ud558\ub294 \uc258 stop_db.sh\r\n\r\n\r\n## ORACLE Listener STOP ##\r\nsu - oracle -c \"\"&lt;\uc624\ub77c\ud074 \ud648 \uae30\uc220&gt;\/bin\/lsnrctl stop listener\"\"\r\n\r\n\r\n## ORACLE Connection Kill ##\r\nps -ef |grep LOCAL|grep oracle|grep -v grep |awk '{print $2}'|xargs kill -9\r\n\r\n\r\n## ORACLE Shutdown ##\r\nsu - oracle -c \"\/oracle\/product\/11.2.0\/bin\/sqlplus '\/as sysdba' &lt; \/oracle\/shutdown_abort.sql\"\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n###########################\uae30\ub3d9\ud558\ub294 \uc258 (VIP \uac00 \uc62c\ub77c\uc628 \uc0c1\ud0dc + disk mount \uc0c1\ud0dc\uc5d0\uc11c  \uae30\ub3d9\ub418\uc5b4\uc57c \ud568) start_db.sh\r\n\r\n\r\n\r\n\r\n## ORACLE Startup ##\r\nsu - oracle -c \"\/oracle\/product\/11.2.0\/bin\/sqlplus '\/as sysdba' &lt; \/oracle\/recover_startup.sql\"\r\n\r\n\r\n\r\n## ORACLE Listener START ##\r\nsu - oracle -c \"\"&lt;\uc624\ub77c\ud074\ud648&gt;\/bin\/lsnrctl start listener\"\"\r\n\r\n\r\n\r\n## recover_startup.sql\r\n\r\nstartup mount ;\r\nALTER DATABASE RECOVER  AUTOMATIC DATABASE ; \r\nalter database open ;\r\n\r\n\r\n## shutdown_abort.sql\r\n\r\nalter system checkpoint ;\r\nalter system checkpoint ;\r\nalter system checkpoint ;\r\nshutdown abort ;<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; ###########################\uc815\uc9c0\ud558\ub294 \uc258 stop_db.sh ## ORACLE Listener STOP ## su &#8211; oracle -c &#8220;&#8221;&lt;\uc624\ub77c\ud074 \ud648 \uae30\uc220&gt;\/bin\/lsnrctl stop listener&#8221;&#8221; ## ORACLE Connection Kill ## ps -ef |grep LOCAL|grep oracle|grep -v grep |awk &#8216;{print $2}&#8217;|xargs kill -9 ## ORACLE Shutdown ## su &#8211; oracle -c &#8220;\/oracle\/product\/11.2.0\/bin\/sqlplus &#8216;\/as sysdba&#8217; &lt; \/oracle\/shutdown_abort.sql&#8221; ###########################\uae30\ub3d9\ud558\ub294 \uc258 (VIP \uac00 \uc62c\ub77c\uc628 \uc0c1\ud0dc + [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2331,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[3],"tags":[910,911,909,912,914,913],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/custom-Custom_Size___Cloud-Marketplace_457-x-457-e1493910495972.jpg?fit=457%2C457","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2822"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2822"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2822\/revisions"}],"predecessor-version":[{"id":2823,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2822\/revisions\/2823"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2331"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2822"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2822"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2822"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}