{"id":1013,"date":"2016-01-01T12:39:49","date_gmt":"2016-01-01T12:39:49","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1013"},"modified":"2016-01-01T12:39:49","modified_gmt":"2016-01-01T12:39:49","slug":"%ed%8c%8c%eb%9d%bc%eb%af%b8%ed%84%b0%ed%8c%8c%ec%9d%bc-%ec%83%9d%ec%84%b1-%eb%b0%8f-%eb%b3%80%ea%b2%bd","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1013","title":{"rendered":"\ud30c\ub77c\ubbf8\ud130\ud30c\uc77c \uc0dd\uc131 \ubc0f \ubcc0\uacbd"},"content":{"rendered":"<p><OL><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\ud604\uc7ac \ud30c\ub77c\ubbf8\ud130 \ud30c\uc77c \ud655\uc778 <\/SPAN><\/DIV><br \/>\n<OL><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">show parameter spfile <\/SPAN><\/DIV><br \/>\n<OL><br \/>\n<LI><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\uacbd\ub85c\uac00 \uc874\uc7ac\ud558\uba74 spfile <\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\uc874\uc7ac\ud558\uc9c0 \uc54a\uc73c\uba74 pfile <\/SPAN><\/LI><\/OL><\/LI><\/OL><\/LI><\/OL><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile25.uf.227438375686739227AA2B.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<OL><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\ud30c\ub77c\ubbf8\ud130\ud30c\uc77c \uacbd\ub85c \ud655\uc778 <\/SPAN><\/DIV><br \/>\n<OL><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\uae30\ubcf8 \uc124\uc815\uc740 \uc624\ub77c\ud074 \ud648 \uc544\ub798 dbs \ubc11\uc5d0 \uc874\uc7ac <\/SPAN><\/DIV><br \/>\n<OL><br \/>\n<LI><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">$ORACLE_HOME\/dbs\/ <\/SPAN><\/LI><\/OL><\/LI><\/OL><\/LI><\/OL><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile29.uf.25083839568673930CC9DD.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<OL><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">pfile \uc0dd\uc131 \ubc0f \ud655\uc778 <\/SPAN><\/DIV><br \/>\n<OL><br \/>\n<LI><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">create pfile from spfile ; <\/SPAN><\/LI><\/OL><\/LI><\/OL><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile25.uf.2759233D56867393037E6B.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<OL style=\"MARGIN-LEFT: 54pt\"><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\uc5c6\uc5c8\ub358 initorcl1.ora \ud30c\uc77c \ud655\uc778 <\/SPAN><\/DIV><br \/>\n<OL><br \/>\n<LI><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">init[SID].ora\ub85c \uc0dd\uc131 \ub428 <\/SPAN><\/LI><\/OL><\/LI><\/OL><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<OL><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">pfile\ub85c \uc2dc\uc791\ud558\uae30 <\/SPAN><\/DIV><br \/>\n<OL><br \/>\n<LI><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">shutdown immediate ; <\/SPAN><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">startup pfile=&#8217;\/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/dbs\/initorcl1.ora&#8217; ; <\/SPAN><\/DIV><br \/>\n<OL><br \/>\n<LI><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">startup pfile=&#8217;$ORACLE_HOME\/dbs\/init[SID].ora&#8217; ; <\/SPAN><\/LI><\/OL><\/LI><\/OL><\/LI><\/OL><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile7.uf.216B9334568673950F483F.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">&nbsp; <\/SPAN>&nbsp;<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ud604\uc7ac \ud30c\ub77c\ubbf8\ud130 \ud30c\uc77c \ud655\uc778 show parameter spfile \uacbd\ub85c\uac00 \uc874\uc7ac\ud558\uba74 spfile \uc874\uc7ac\ud558\uc9c0 \uc54a\uc73c\uba74 pfile &nbsp; &nbsp; \ud30c\ub77c\ubbf8\ud130\ud30c\uc77c \uacbd\ub85c \ud655\uc778 \uae30\ubcf8 \uc124\uc815\uc740 \uc624\ub77c\ud074 \ud648 \uc544\ub798 dbs \ubc11\uc5d0 \uc874\uc7ac $ORACLE_HOME\/dbs\/ &nbsp; &nbsp; pfile \uc0dd\uc131 \ubc0f \ud655\uc778 create pfile from spfile ; \uc5c6\uc5c8\ub358 initorcl1.ora \ud30c\uc77c \ud655\uc778 init[SID].ora\ub85c \uc0dd\uc131 \ub428 &nbsp; &nbsp; pfile\ub85c \uc2dc\uc791\ud558\uae30 shutdown immediate ; startup pfile=&#8217;\/u01\/app\/oracle\/product\/11.2.0.3\/db_1\/dbs\/initorcl1.ora&#8217; ; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1014,"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":[553,554,555,556],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile7.uf.216B9334568673950F483F.png?fit=589%2C474","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1013"}],"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=1013"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1013\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1014"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1013"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}