{"id":1098,"date":"2016-01-02T13:20:07","date_gmt":"2016-01-02T13:20:07","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1098"},"modified":"2016-01-02T13:20:07","modified_gmt":"2016-01-02T13:20:07","slug":"tnsnamesora-%ec%84%a4%ec%a0%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1098","title":{"rendered":"tnsnames.ora \uc124\uc815"},"content":{"rendered":"<p><P style=\"MARGIN-LEFT: 19pt\">TNSNAMES.ORA<SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ub780<\/SPAN> <\/P><br \/>\n<P style=\"MARGIN-LEFT: 19pt\"><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\">\uc11c\ubc84\uc758<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc815\ubcf4\ub97c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uae30\uc785\ud558\ub294<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ud30c\uc77c\uc785\ub2c8\ub2e4<\/SPAN>. <\/P><br \/>\n<P style=\"MARGIN-LEFT: 19pt\">&nbsp; &nbsp;<\/P><br \/>\n<UL><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ud30c\uc77c<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc704\uce58<\/SPAN> <\/DIV><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>ORCL(ALIAS) = <\/P><br \/>\n<P>&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; (ADDRESS_LIST =&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.101)(PORT&nbsp;=&nbsp;1521))&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;&nbsp; (CONNECT_DATA =&nbsp; <\/P><br \/>\n<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SID\/SERVICE_NAME =&nbsp;orcl)&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; <\/P><br \/>\n<P>&nbsp; &nbsp;<\/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<\/SPAN> <SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uac00\ub2a5\ud569\ub2c8\ub2e4<\/SPAN>. <\/P><\/LI><\/UL><\/p>\n","protected":false},"excerpt":{"rendered":"<p>TNSNAMES.ORA\ub780 \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0\uc11c \uc11c\ubc84\ub85c \uc811\uc18d\ud560 \ub54c \ud544\uc694\ud55c \uc11c\ubc84\uc758 \uc815\ubcf4\ub97c \uae30\uc785\ud558\ub294 \ud30c\uc77c\uc785\ub2c8\ub2e4. &nbsp; &nbsp; \ud30c\uc77c \uc704\uce58 Single DB = $ORACLE_HOME\/network\/admin RAC=$GRID_HOME\/network\/admin &nbsp; &nbsp; ORCL(ALIAS) = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (DESCRIPTION =&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; (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.101)(PORT&nbsp;=&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; (CONNECT_DATA =&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SID\/SERVICE_NAME =&nbsp;orcl)&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; NETCA \ub97c \uc774\uc6a9\ud574\uc11c \uad6c\uc131\ub3c4 \uac00\ub2a5\ud558\uc9c0\ub9cc [&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":[331,593,602,603,597],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1098"}],"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=1098"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1098\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1098"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1098"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1098"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}