{"id":659,"date":"2015-11-19T07:25:53","date_gmt":"2015-11-19T07:25:53","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=659"},"modified":"2015-11-19T07:25:53","modified_gmt":"2015-11-19T07:25:53","slug":"oerr-%ed%99%9c%ec%9a%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=659","title":{"rendered":"OERR \ud65c\uc6a9\ubc95"},"content":{"rendered":"

O<\/SPAN>ERR <\/SPAN>\uc774\ub780<\/SPAN>?<\/SPAN><\/STRONG><\/P>
\n

Oracle<\/SPAN>\uc744<\/SPAN> <\/SPAN>\uc124\uce58<\/SPAN> <\/SPAN>\ud558\uac8c<\/SPAN> <\/SPAN>\ub418\uba74<\/SPAN> <\/SPAN>\uc0ac\uc6a9\ud560<\/SPAN> <\/SPAN>\uc218<\/SPAN> <\/SPAN>\uc788\ub294<\/SPAN> <\/SPAN>\uae30\ub2a5\uc73c\ub85c<\/SPAN> $ORACLE_HOME\/bin\/ <\/SPAN>\uc544\ub798<\/SPAN> <\/SPAN>\uc788\uc2b5\ub2c8\ub2e4<\/SPAN>.<\/SPAN><\/P>
\n

 <\/P>
\n

Oerr <\/SPAN>\uc744<\/SPAN> <\/SPAN>\uc774\uc6a9\ud558\uc5ec<\/SPAN> <\/SPAN>\uc544\ub798\uc640<\/SPAN> <\/SPAN>\uac19\uc774<\/SPAN> <\/SPAN>\ud574\ub2f9<\/SPAN> Error <\/SPAN>\uac00<\/SPAN> <\/SPAN>\ubb34\uc5c7<\/SPAN> <\/SPAN>\uc778\uc9c0\uc640<\/SPAN> Error<\/SPAN>\uc5d0<\/SPAN> <\/SPAN>\ub300\ud55c<\/SPAN> <\/SPAN>\uc194\ub8e8\uc158\uc744<\/SPAN> <\/SPAN>\ud655\uc778<\/SPAN> <\/SPAN>\ud558\uc2e4<\/SPAN> <\/SPAN>\uc218<\/SPAN> <\/SPAN>\uc788\uc2b5\ub2c8\ub2e4<\/SPAN>.<\/SPAN><\/P>
\n

ORA-XXXXX <\/SPAN>\uba54\uc2dc\uc9c0<\/SPAN> <\/SPAN>\ub9d0\uace0\ub3c4<\/SPAN> TNS-XXXXX \uba54\uc2dc<\/SPAN>\uc9c0<\/SPAN> <\/SPAN>\ub3c4<\/SPAN> <\/SPAN>\ud655\uc778\uc774<\/SPAN> <\/SPAN>\uac00\ub2a5\ud569\ub2c8\ub2e4<\/SPAN>.<\/SPAN><\/P>
\n

 <\/P>
\n

[oracle@<\/SPAN>orcl ~<\/SPAN>]$ oerr ora 12514<\/SPAN><\/P>
\n

12514, 00000, “TNS:listener does not currently know of service requested in connect descriptor”<\/P>
\n

\/\/ *Cause:  <\/SPAN>The listener received a request to establish a connection to a<\/P>
\n

\/\/ database or other service. The connect descriptor received by the listener<\/P>
\n

\/\/ specified a service name for a service (usually a database service)<\/P>
\n

\/\/ that either has not yet dynamically registered with the listener or has<\/P>
\n

\/\/ not been statically configured for the listener.  <\/SPAN>This may be a temporary<\/P>
\n

\/\/ condition such as after the listener has started, but before the database<\/P>
\n

\/\/ instance has registered with the listener.<\/P>
\n

\/\/ *Action: <\/P>
\n

\/\/  <\/SPAN>– Wait a moment and try to connect a second time.<\/P>
\n

\/\/  <\/SPAN>– Check which services are currently known by the listener by executing:<\/P>
\n

\/\/    <\/SPAN>lsnrctl services <listener name><\/P>
\n

\/\/  <\/SPAN>– Check that the SERVICE_NAME parameter in the connect descriptor of the<\/P>
\n

\/\/    <\/SPAN>net service name used specifies a service known by the listener.<\/P>
\n

\/\/  <\/SPAN>– If an easy connect naming connect identifier was used, check that<\/P>
\n

\/\/    <\/SPAN>the service name specified is a service known by the listener.<\/P>
\n

\/\/  <\/SPAN>– Check for an event in the listener.log file.<\/P>
\n

[oracle@<\/SPAN>orcl ~<\/SPAN>]$ <\/SPAN><\/P>
\n

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

OERR \uc774\ub780? Oracle\uc744 \uc124\uce58 \ud558\uac8c \ub418\uba74 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc73c\ub85c $ORACLE_HOME\/bin\/ \uc544\ub798 \uc788\uc2b5\ub2c8\ub2e4.   Oerr \uc744 \uc774\uc6a9\ud558\uc5ec \uc544\ub798\uc640 \uac19\uc774 \ud574\ub2f9 Error \uac00 \ubb34\uc5c7 \uc778\uc9c0\uc640 Error\uc5d0 \ub300\ud55c \uc194\ub8e8\uc158\uc744 \ud655\uc778 \ud558\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. ORA-XXXXX \uba54\uc2dc\uc9c0 \ub9d0\uace0\ub3c4 TNS-XXXXX \uba54\uc2dc\uc9c0 \ub3c4 \ud655\uc778\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.   [oracle@orcl ~]$ oerr ora 12514 12514, 00000, “TNS:listener does not currently know of service requested […]<\/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":[3],"tags":[337,338,339,340],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/659"}],"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=659"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/659\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=659"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}