{"id":758,"date":"2015-11-30T16:30:31","date_gmt":"2015-11-30T16:30:31","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=758"},"modified":"2015-11-30T16:30:31","modified_gmt":"2015-11-30T16:30:31","slug":"single-dbfilesystem-%ec%a0%95%ec%a7%80-%eb%b0%8f-%ea%b8%b0%eb%8f%99-%ec%a0%88%ec%b0%a8","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=758","title":{"rendered":"Single DB(Filesystem) \uc815\uc9c0 \ubc0f \uae30\ub3d9 \uc808\ucc28"},"content":{"rendered":"


    \n

  1. \n
    \ub9ac\uc2a4\ub108 \ud655\uc778 \ubc0f \ub9ac\uc2a4\ub108 \uc815\uc9c0 <\/SPAN><\/DIV>
    \n

      \n
    1. ps -ef |grep tns <\/SPAN><\/LI>
      \n

    2. \n
      lsnrctl status [\ub9ac\uc2a4\ub108 \uba85] <\/SPAN><\/DIV>
      \n

        \n
      1. lsnrctl status LISTENER <\/SPAN><\/LI><\/OL><\/LI>
        \n

      2. \n
        lsnrctl stop [\ub9ac\uc2a4\ub108 \uba85] <\/SPAN><\/DIV>
        \n

          \n
        1. lsnrctl stop LISTENER <\/SPAN><\/LI><\/OL><\/LI><\/OL><\/LI><\/OL>
          \n

          <\/SPAN><\/P>
          \n


            \n

          1. \n
            DB \ud655\uc778 \ubc0f \uc815\uc9c0 <\/SPAN><\/DIV>
            \n

              \n
            1. ps -ef |grep pmon <\/SPAN><\/LI>
              \n
            2. sqlplus \/ as sysdba <\/SPAN><\/LI>
              \n
            3. alter system switch logfile ; * 3 <\/SPAN><\/LI>
              \n
            4. alter system checkpoint ; * 3 <\/SPAN><\/LI>
              \n
            5. shutdown immediate ; <\/SPAN><\/LI>
              \n
            6. exit <\/SPAN><\/LI>
              \n
            7. ps -ef |grep pmon <\/SPAN><\/LI><\/OL><\/LI><\/OL>
              \n

              <\/SPAN><\/P>
              \n


                \n

              1. \n
                DB \uc2dc\uc791 <\/SPAN><\/DIV>
                \n

                  \n
                1. sqlplus \/ as sysdba <\/SPAN><\/LI>
                  \n
                2. startup <\/SPAN><\/LI>
                  \n
                3. exit <\/SPAN><\/LI><\/OL><\/LI><\/OL>
                  \n

                  <\/SPAN><\/P>
                  \n


                    \n

                  1. \n
                    \ub9ac\uc2a4\ub108 \uc2dc\uc791 <\/SPAN><\/DIV>
                    \n

                      \n
                    1. lsnrctl start LISTENER <\/SPAN><\/LI>
                      \n
                    2. sqlplus \/ as sysdba <\/SPAN><\/LI>
                      \n
                    3. alter system register ; * 3 <\/SPAN><\/LI><\/OL><\/LI><\/OL>
                      \n

                      <\/SPAN><\/P>
                      \n

                         <\/P>
                      \n

                      <\/SPAN><\/P>
                      \n

                      <\/SPAN> <\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

                      \ub9ac\uc2a4\ub108 \ud655\uc778 \ubc0f \ub9ac\uc2a4\ub108 \uc815\uc9c0 ps -ef |grep tns lsnrctl status [\ub9ac\uc2a4\ub108 \uba85] lsnrctl status LISTENER lsnrctl stop [\ub9ac\uc2a4\ub108 \uba85] lsnrctl stop LISTENER DB \ud655\uc778 \ubc0f \uc815\uc9c0 ps -ef |grep pmon sqlplus \/ as sysdba alter system switch logfile ; * 3 alter system checkpoint ; * 3 shutdown immediate ; exit ps -ef |grep […]<\/p>\n","protected":false},"author":1,"featured_media":759,"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":[9],"tags":[441,442,443,444],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile3.uf.2362EF33565C79A70C2562.png?fit=677%2C426","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/758"}],"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=758"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/758\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/759"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=758"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=758"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}