{"id":1099,"date":"2016-01-02T13:20:22","date_gmt":"2016-01-02T13:20:22","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1099"},"modified":"2016-01-02T13:20:22","modified_gmt":"2016-01-02T13:20:22","slug":"listenerora-%ec%84%a4%ec%a0%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1099","title":{"rendered":"listener.ora \uc124\uc815"},"content":{"rendered":"<p><P>Listener.ora <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc774\ub780<\/SPAN>? <\/P><br \/>\n<P><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0\uc11c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc11c\ubc84\ub85c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc811\uc18d\ud560<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ub54c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ud544\uc694\ud55c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc815\ubcf4\ub4e4\uc744<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc124\uc815\ud574<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc8fc\ub294<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ud30c\uc77c\ub85c\uc11c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc11c\ubc84\uc5d0\ub9cc<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc124\uc815\ud569\ub2c8\ub2e4<\/SPAN>. <\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<UL><br \/>\n<LI><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ud30c\uc77c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc704\uce58<\/SPAN> <\/LI><\/UL><br \/>\n<P>Single DB = $ORACLE_HOME\/network\/admin <\/P><br \/>\n<P>RAC=$GRID_HOME\/network\/admin <\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><STRONG>LISTENER<\/STRONG> = <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (DESCRIPTION_LIST =&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (DESCRIPTION =&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (ADDRESS_LIST =&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST =&nbsp;192.168.56.101)(PORT =&nbsp;1521))&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp; <\/P><br \/>\n<P>SID_LIST_<STRONG>LISTENER<\/STRONG>&nbsp;=&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SID_LIST =&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SID_DESC =&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SID_NAME =&nbsp;orcl)&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(ORACLE_HOME =&nbsp;&lt;ORACLE_HOME&gt;)&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp; <\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><STRONG>TEST<\/STRONG> = <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (DESCRIPTION_LIST =&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (DESCRIPTION =&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (ADDRESS_LIST =&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST =&nbsp;192.168.56.101)(PORT =&nbsp;1522))&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp; <\/P><br \/>\n<P>SID_LIST_<STRONG>TEST<\/STRONG>&nbsp;=&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SID_LIST =&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SID_DESC =&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SID_NAME =&nbsp;test)&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(ORACLE_HOME =&nbsp;&lt;ORACLE_HOME&gt;)&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp; <\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc704\uc640 \uac19\uc774 \uc5ec\ub7ec \uac1c\uc758<\/SPAN> Listener <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uac00<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc874\uc7ac<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ud560<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc218<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc788\uc73c\uba70<\/SPAN>, <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uad75\uac8c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ud45c\uc2dc<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ub41c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ubd80\ubd84<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ub07c\ub9ac\ub294<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uba85\uc774<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uac19\uc544\uc57c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ud569\ub2c8\ub2e4<\/SPAN>. <\/P><br \/>\n<P>TEST <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ub77c\ub294<\/SPAN> Listener <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc758<\/SPAN> SID_LIST <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ub77c\ub294<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc758\ubbf8\uc785\ub2c8\ub2e4<\/SPAN>. <\/P><br \/>\n<P>NETCA <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ub97c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc774\uc6a9\ud574\uc11c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uad6c\uc131\ub3c4<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uac00\ub2a5\ud558\uc9c0\ub9cc<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc218\ub3d9\uc73c\ub85c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ud30c\uc77c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc0dd\uc131<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ud6c4<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uae30\uc785\ud574\uc918\ub3c4<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc0ac\uc6a9\uac00\ub2a5\ud569\ub2c8\ub2e4<\/SPAN>. <\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Listener.ora \uc774\ub780? \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0\uc11c \uc11c\ubc84\ub85c \uc811\uc18d\ud560 \ub54c \ud544\uc694\ud55c \uc815\ubcf4\ub4e4\uc744 \uc124\uc815\ud574 \uc8fc\ub294 \ud30c\uc77c\ub85c\uc11c \uc11c\ubc84\uc5d0\ub9cc \uc124\uc815\ud569\ub2c8\ub2e4. &nbsp; &nbsp; \ud30c\uc77c \uc704\uce58 Single DB = $ORACLE_HOME\/network\/admin RAC=$GRID_HOME\/network\/admin &nbsp; &nbsp; LISTENER = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (DESCRIPTION_LIST =&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (DESCRIPTION =&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (ADDRESS_LIST =&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST =&nbsp;192.168.56.101)(PORT =&nbsp;1521))&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp; SID_LIST_LISTENER&nbsp;=&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SID_LIST =&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SID_DESC =&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SID_NAME [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"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":[21],"tags":[604,331,605,593,597],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1099"}],"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=1099"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1099\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1099"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1099"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1099"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}