{"id":995,"date":"2015-12-31T00:37:28","date_gmt":"2015-12-31T00:37:28","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=995"},"modified":"2015-12-31T00:37:28","modified_gmt":"2015-12-31T00:37:28","slug":"oracle-sid-%eb%b3%80%ea%b2%bd-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=995","title":{"rendered":"ORACLE SID \ubcc0\uacbd \ubc29\ubc95"},"content":{"rendered":"

ORACLE SID \ubcc0\uacbd\ubc29\ubc95<\/SPAN><\/STRONG><\/FONT><\/SPAN><\/SPAN><\/P>
\n

\ucc38\uc870 \ubb38\uc11c<\/FONT><\/SPAN><\/SPAN><\/P>
\n

How to Rename Database\/Change DB_NAME or ORACLE_SID\/Instance Name <\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

(<\/SPAN><\/B>\ubb38\uc11c ID 15390.1))<\/SPAN><\/SPAN><\/B><\/FONT><\/FONT><\/P>
\n

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

A.<\/FONT>     <\/SPAN><\/SPAN><\/SPAN>SID <\/SPAN>\ubcc0\uacbd<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2460<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Database Shutdown <\/FONT><\/FONT><\/SPAN><\/P>
\n

\u2461<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>\ubaa8\ub4e0 Control, redo, datafiles Backup<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2462<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>ORACLE_SID <\/SPAN>\ubcc0\uacbd \uc801\uc6a9(export ORACLE_SID=NewSID or profile <\/SPAN>\uc5d0 \uc801\uc6a9)<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2463<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>tnsnames.ora file <\/SPAN>\uc5d0\ub3c4 \ubcc0\uacbd\ub41c SID <\/SPAN>\uc801\uc6a9<\/SPAN><\/FONT><\/FONT><\/P>
\n

<\/v:rect><\/P>
\n

<\/P>
\n

\u2464<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>$ORACLE_HOME\/dbs <\/SPAN>\uacbd\ub85c\uc5d0 \uc788\ub294 parameter file <\/SPAN>\uc744 (init<SID>.ora or spfile<SID>) <\/SPAN>\uc0c8\ub85c\uc6b4 SID <\/SPAN>\uc5d0 \ub9de\uac8c \ubcc0\uacbd<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2465<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>password file <\/SPAN>\ub3c4 \uc0c8\ub85c\uc6b4 SID <\/SPAN>\uc5d0 \ub9de\uac8c \uc0dd\uc131<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2466<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Startup Database<\/FONT><\/FONT><\/SPAN><\/P>
\n

\u2467<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>\ucd94\uac00\uc801\uc73c\ub85c Controlfile, Redo, Datafiles <\/SPAN>\uc758 \uacbd\ub85c \ubcc0\uacbd\uc774 \ud544\uc694\ud55c \uacbd\uc6b0 parameter <\/SPAN>\ubcc0\uacbd\uacfc rename <\/SPAN>\uc744 \ud1b5\ud574\uc11c \uc9c4\ud589<\/SPAN><\/FONT><\/FONT><\/P>
\n
\n
\n
\n

\n

\uba85\ub839\uc5b4<\/SPAN><\/FONT><\/FONT><\/SPAN><\/B><\/P><\/TD>
\n


\n

SQL> shutdown immedaite<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

$ export ORACLE_SID=TECHDATA<\/SPAN><\/B><\/FONT><\/FONT><\/P>
\n

$ vi $ORACLE_HOME\/network\/admin\/tnsnames.ora<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

$ cp initTECH.ora initTECHDATA.ora   <\/SPAN><\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

$ cp spfileTECH.ora spfileTECHDATA.ora<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

$ passwd file=orapwTECHDATA password=oracle entries=5<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> startup<\/FONT><\/FONT><\/SPAN><\/B><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

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

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

ORACLE SID \ubcc0\uacbd\ubc29\ubc95 \ucc38\uc870 \ubb38\uc11c How to Rename Database\/Change DB_NAME or ORACLE_SID\/Instance Name (\ubb38\uc11c ID 15390.1))   A.     SID \ubcc0\uacbd \u2460    Database Shutdown \u2461    \ubaa8\ub4e0 Control, redo, datafiles Backup \u2462    ORACLE_SID \ubcc0\uacbd \uc801\uc6a9(export ORACLE_SID=NewSID or profile \uc5d0 \uc801\uc6a9) \u2463    tnsnames.ora file \uc5d0\ub3c4 \ubcc0\uacbd\ub41c SID \uc801\uc6a9 \u2464    $ORACLE_HOME\/dbs \uacbd\ub85c\uc5d0 \uc788\ub294 parameter file \uc744 (init<SID>.ora or spfile<SID>) […]<\/p>\n","protected":false},"author":1,"featured_media":996,"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":[533,534],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile9.uf.236965495684781B0DD826.PNG?fit=499%2C153","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/995"}],"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=995"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/995\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/996"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=995"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=995"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}