{"id":616,"date":"2016-03-22T15:40:12","date_gmt":"2016-03-23T00:40:12","guid":{"rendered":"\/blog\/?p=616"},"modified":"2023-09-21T09:38:04","modified_gmt":"2023-09-21T00:38:04","slug":"oracle-start-shutdown-script","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=616","title":{"rendered":"Oracle Start\/Shutdown script"},"content":{"rendered":"\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DB \uc778\uc2a4\ud134\uc2a4  : orcl\nOracle owner : oracle\n\n\ub2e4\uc6b4\ub85c\ub4dc:\ndbora\nstartup.sh\nshutdown.sh\n\n1. \/etc\/oratab \ud30c\uc77c\uc744 \uc544\ub798\uc640 \uac19\uc774 \ud3b8\uc9d1\ud55c\ub2e4.\n\n# Entries are of the form:\n#   $ORACLE_SID:$ORACLE_HOME:&lt;N|Y>:\norcl:\/opt\/oracle\/12.1.0:Y\n2. \uc544\ub798\uc758 \uc2a4\ud06c\ub9bd\ud2b8\ub97c root \uad8c\ud55c\uc73c\ub85c \uc2e4\ud589\ud55c\ub2e4.\n\/etc\/rc.d\/init.d\/dbora<\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>\/home\/oracle\/scripts\/startup.sh<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">#!\/bin\/bash\nexport TMP=\/tmp\nexport TMPDIR=$TMP\nexport ORACLE_BASE=\/opt\/oracle\nexport LANG=ko_KR.UTF-8\nexport NLS_LANG=AMERICAN_AMERICA.UTF8\nexport ORA_NLS33=${ORACLE_HOME}\/ocommon\/nls\/admin\/data\nexport ORACLE_HOME=${ORACLE_BASE}\/11g\nexport ORACLE_HOME_LISTNER=${ORACLE_HOME}\nexport ORACLE_HOSTNAME=localhost\nexport ORACLE_TERM=xterm\nexport PATH=\/usr\/sbin:${ORACLE_HOME}\/bin:${PATH}:\/usr\/local\/bin\nLD_LIBRARY_PATH=${ORACLE_HOME}\/lib:\/lib:\/usr\/lib\nLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:\/usr\/local\/lib\nexport LD_LIBRARY_PATH\n# Start Listener\necho \"    Starting lsnrctl\u2026\"\nlsnrctl start\n# Start Database\nexport ORACLE_SID=orcl\necho \"    Starting ${ORACLE_SID} Database\u2026\"\nsqlplus \/ as sysdba &lt;&lt; EOF\nSTARTUP;\nEXIT;\nEOF<\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>\/home\/oracle\/scripts\/shutdown.sh<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">#!\/bin\/bash\nexport TMP=\/tmp\nexport TMPDIR=$TMP\nexport ORACLE_BASE=\/opt\/oracle\nexport LANG=ko_KR.UTF-8\nexport NLS_LANG=AMERICAN_AMERICA.UTF8\nexport ORA_NLS33=${ORACLE_HOME}\/ocommon\/nls\/admin\/data\nexport ORACLE_HOME=${ORACLE_BASE}\/11g\nexport ORACLE_HOME_LISTNER=${ORACLE_HOME}\nexport ORACLE_HOSTNAME=localhost\nexport ORACLE_TERM=xterm\nexport PATH=\/usr\/sbin:${ORACLE_HOME}\/bin:${PATH}:\/usr\/local\/bin\nLD_LIBRARY_PATH=${ORACLE_HOME}\/lib:\/lib:\/usr\/lib\nLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:\/usr\/local\/lib\nexport LD_LIBRARY_PATH\n# Stop Database\nexport ORACLE_SID=orcl\necho \"    Shutting down ${ORACLE_SID} Database...\"\nsqlplus \/ as sysdba &lt;&lt; EOF\nSHUTDOWN IMMEDIATE;\nEXIT;\nEOF\nsleep 1\n# Stop Listener\necho \"    Shutting down lsnrctl\u2026\"\nlsnrctl stop<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\/home\/oracle\/scripts\/startup.sh \/home\/oracle\/scripts\/shutdown.sh<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-616","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/616","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=616"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/616\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}