{"id":1057,"date":"2016-01-02T03:42:53","date_gmt":"2016-01-02T03:42:53","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1057"},"modified":"2016-01-02T03:42:53","modified_gmt":"2016-01-02T03:42:53","slug":"%ec%84%a4%ec%b9%98-%ea%b2%80%ec%88%98-%ec%8b%9c-%ec%82%ac%ec%9a%a9%ed%95%98%eb%8a%94-%ec%bb%a4%eb%a7%a8%eb%93%9c","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1057","title":{"rendered":"\uc124\uce58 \uac80\uc218 \uc2dc \uc0ac\uc6a9\ud558\ub294 \ucee4\ub9e8\ub4dc"},"content":{"rendered":"

\uc124\uce58 \ud6c4 \uac80\uc218\uc5d0 \uc0ac\uc6a9\ud558\ub294 \ucee4\ub9e8\ub4dc <\/SPAN><\/P>
\n


    \n

  1. \n
    pmon \ud655\uc778 <\/SPAN><\/DIV>
    \n

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

    2. \n
      \ub9ac\uc2a4\ub108 \ud655\uc778 <\/SPAN><\/DIV>
      \n

        \n
      1. ps -ef |grep tns <\/SPAN><\/LI>
        \n
      2. lsnrctl status [LISTENER_NAME] <\/SPAN><\/LI><\/OL><\/LI>
        \n

      3. \n
        SID \ubc0f \uc0c1\ud0dc \ud655\uc778 <\/SPAN><\/DIV>
        \n

          \n
        1. select instance_name, status from v$instance ; <\/SPAN><\/LI><\/OL><\/LI>
          \n

        2. \n
          \uc624\ub77c\ud074 \ud504\ub85c\uc138\uc2a4 \ud655\uc778 <\/SPAN><\/DIV>
          \n

            \n
          1. ps -ef |grep ora_ | grep -v grep <\/SPAN><\/LI><\/OL><\/LI>
            \n

          2. \n
            \uc635\uc158\ud655\uc778 <\/SPAN><\/DIV>
            \n

              \n
            1. select * from v$option ; <\/SPAN><\/LI>
              \n

            2. \n
              RAC \ud655\uc778 <\/SPAN><\/DIV>
              \n

                \n
              1. select * from v$option where parameter like ‘%Real%’ ; <\/SPAN><\/LI><\/OL><\/LI>
                \n

              2. \n
                Partition \ud655\uc778 <\/SPAN><\/DIV>
                \n

                  \n
                1. select * from v$option where parameter like ‘%Partition%’ ; <\/SPAN><\/LI><\/OL><\/LI>
                  \n

                2. \n
                  Package \ud655\uc778 <\/SPAN><\/DIV>
                  \n

                    \n
                  1. show parameter pack <\/SPAN><\/LI><\/OL><\/LI>
                    \n

                  2. \n
                    Life Cycle \ud655\uc778 <\/SPAN><\/DIV>
                    \n

                      \n
                    1. show parameter enable_ddl <\/SPAN><\/LI><\/OL><\/LI><\/OL><\/LI><\/OL>
                      \n

                         <\/P>
                      \n

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

                         <\/P>
                      \n

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

                         <\/P>
                      \n

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

                         <\/P>
                      \n

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

                         <\/P>
                      \n

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

                         <\/P>
                      \n

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

                         <\/P>
                      \n

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

                         <\/P>
                      \n

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

                         <\/P>
                      \n

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

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

                      \uc124\uce58 \ud6c4 \uac80\uc218\uc5d0 \uc0ac\uc6a9\ud558\ub294 \ucee4\ub9e8\ub4dc pmon \ud655\uc778 ps -ef |grep pmon \ub9ac\uc2a4\ub108 \ud655\uc778 ps -ef |grep tns lsnrctl status [LISTENER_NAME] SID \ubc0f \uc0c1\ud0dc \ud655\uc778 select instance_name, status from v$instance ; \uc624\ub77c\ud074 \ud504\ub85c\uc138\uc2a4 \ud655\uc778 ps -ef |grep ora_ | grep -v grep \uc635\uc158\ud655\uc778 select * from v$option ; RAC \ud655\uc778 select * from v$option where parameter […]<\/p>\n","protected":false},"author":1,"featured_media":1058,"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":[564,565],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile7.uf.221C3A4856874734230029.png?fit=441%2C67","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1057"}],"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=1057"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1057\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1058"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1057"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1057"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}