{"id":1295,"date":"2016-02-11T06:40:31","date_gmt":"2016-02-11T06:40:31","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1295"},"modified":"2016-02-11T06:40:31","modified_gmt":"2016-02-11T06:40:31","slug":"tnsping%ec%9c%bc%eb%a1%9c-%ec%a0%91%ec%86%8d-test%ed%95%98%eb%8a%94-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1295","title":{"rendered":"TNSPING\uc73c\ub85c \uc811\uc18d TEST\ud558\ub294 \ubc29\ubc95"},"content":{"rendered":"

TNSPING\uc73c\ub85c \uc811\uc18d TEST\ud558\ub294 \ubc29\ubc95 <\/span>


<\/span><\/span><\/p>\n

Windows 95\uc6a9 SQL*Net\uc744 \uc124\uce58\ud558\uba74 tnsping.exe\ub77c\ub294 \ud504\ub85c\uadf8\ub7a8\uc774 \uc0dd\uae34\ub2e4. \uc774 \ud504\ub85c\uadf8\ub7a8\uc740 \uc77c\ubc18\uc801\uc778 TCP\/IP \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 Ping Utility\uc640 \uc720\uc0ac\ud55c \ubc29\uc2dd\uc73c\ub85c DB Server\uc5d0\u3000Login \uc5ec\ubd80\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4. SQL*Net 2.2\uc774\uc0c1\uc5d0\uc11c\ub9cc \uc81c\uacf5\uc774 \ub418\uba70, SQL*Net V1\uc5d0\uc11c\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4.\u3000<\/span> <\/span><\/span>

<\/span><\/p>\n

[ \uc0ac\uc6a9 \ubc29\ubc95 ]\u3000\u3000<\/span> <\/span><\/span>

tnsnames.ora file\uc5d0 tns services name\ubc0f \uc811\uc18d\uc5d0 \uad00\ub828\ub41c \ub0b4\uc6a9\uc744 \uae30\uc220\ud55c\ub2e4.\u3000\u3000<\/span> <\/span><\/span>
\uc608: TORA =\u3000<\/span> <\/span><\/span>
\u3000\u3000\u3000 (DESCRIPTION=\u3000<\/span> <\/span><\/span>
\u3000\u3000\u3000\u3000\u3000 (ADDRESS=\u3000<\/span> <\/span><\/span>
\u3000\u3000\u3000\u3000\u3000\u3000\u3000 (PROTOCOL=tcp)\u3000<\/span> <\/span><\/span>
\u3000\u3000\u3000\u3000\u3000\u3000\u3000 (PORT=1621)\u3000<\/span> <\/span><\/span>
\u3000\u3000\u3000\u3000\u3000\u3000\u3000 (HOST=krrcsun)\u3000<\/span> <\/span><\/span>
\u3000\u3000\u3000\u3000\u3000 )\u3000<\/span> <\/span><\/span>
\u3000\u3000\u3000\u3000\u3000 (CONNECT_DATA=(SID=ORA73))\u3000<\/span> <\/span><\/span>
\u3000\u3000\u3000 )\u3000<\/span> <\/span><\/span>

tnsping utility \uc0ac\uc6a9 \uc608\u3000\u3000<\/span> <\/span><\/span>

<\/span><\/p>\n

cmd<\/span><\/font><\/p>\n


<\/span><\/p>\n

c:\\orawin95\\bin\\tnsping TDOR 10\u3000\u3000<\/span> <\/span><\/span>

TNS Ping Utility for WINDOWS 32: Version 2.2.2.0.0 – Production on 24-OCT-96 09:52:34\u3000\u3000<\/span> <\/span><\/span>

Copyright (c) Oracle Corporation 1995. All rights reserved.\u3000<\/span> <\/span><\/span>
Attempting to contact\u3000\u3000<\/span> <\/span><\/span>
(ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=blue))\u3000<\/span> <\/span><\/span>
OK (170 msec)\u3000<\/span> <\/span><\/span>
OK (50 msec)\u3000<\/span> <\/span><\/span>
OK (0 msec)\u3000<\/span> <\/span><\/span>
OK (60 msec)\u3000<\/span> <\/span><\/span>
OK (0 msec)\u3000<\/span> <\/span><\/span>
OK (50 msec)\u3000<\/span> <\/span><\/span>
OK (0 msec)\u3000<\/span> <\/span><\/span>
OK (60 msec)\u3000<\/span> <\/span><\/span>
OK (50 msec)\u3000<\/span> <\/span><\/span>
OK (0 msec)<\/span> <\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

TNSPING\uc73c\ub85c \uc811\uc18d TEST\ud558\ub294 \ubc29\ubc95  Windows 95\uc6a9 SQL*Net\uc744 \uc124\uce58\ud558\uba74 tnsping.exe\ub77c\ub294 \ud504\ub85c\uadf8\ub7a8\uc774 \uc0dd\uae34\ub2e4. \uc774 \ud504\ub85c\uadf8\ub7a8\uc740 \uc77c\ubc18\uc801\uc778 TCP\/IP \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 Ping Utility\uc640 \uc720\uc0ac\ud55c \ubc29\uc2dd\uc73c\ub85c DB Server\uc5d0\u3000Login \uc5ec\ubd80\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4. SQL*Net 2.2\uc774\uc0c1\uc5d0\uc11c\ub9cc \uc81c\uacf5\uc774 \ub418\uba70, SQL*Net V1\uc5d0\uc11c\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4.\u3000  [ \uc0ac\uc6a9 \ubc29\ubc95 ]\u3000\u3000 tnsnames.ora file\uc5d0 tns services name\ubc0f \uc811\uc18d\uc5d0 \uad00\ub828\ub41c \ub0b4\uc6a9\uc744 \uae30\uc220\ud55c\ub2e4.\u3000\u3000 \uc608: TORA =\u3000 \u3000\u3000\u3000 (DESCRIPTION=\u3000 \u3000\u3000\u3000\u3000\u3000 (ADDRESS=\u3000 \u3000\u3000\u3000\u3000\u3000\u3000\u3000 (PROTOCOL=tcp)\u3000 \u3000\u3000\u3000\u3000\u3000\u3000\u3000 (PORT=1621)\u3000 \u3000\u3000\u3000\u3000\u3000\u3000\u3000 (HOST=krrcsun)\u3000 \u3000\u3000\u3000\u3000\u3000 […]<\/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":[9],"tags":[707,708,596],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1295"}],"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=1295"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1295\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1295"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1295"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}