{"id":642,"date":"2023-11-24T16:37:18","date_gmt":"2023-11-24T08:37:18","guid":{"rendered":"https:\/\/blog.yunvisit.com\/?p=642"},"modified":"2023-11-24T16:43:22","modified_gmt":"2023-11-24T08:43:22","slug":"oracle%e6%8a%a5%e9%94%99ora-12519-tnsno-appropriate-service-handler-found","status":"publish","type":"post","link":"https:\/\/blog.yunvisit.com\/?p=642","title":{"rendered":"Oracle\u62a5\u9519ORA-12519, TNS:no appropriate service handler found"},"content":{"rendered":"<p>weblogic \u8fde\u63a5oralce\u5b9e\u4f8b\u51fa\u73b0\u8be5\u9879\u62a5\u9519\uff0c\u5bfc\u81f4\u539f\u56e0\u662f\u7531\u4e8e\u6570\u636e\u5e93\u8fde\u63a5\u6570\u8d85\u8fc7\u6570\u636e\u5e93\u8bbe\u7f6e\u5bfc\u81f4\u3002<\/p>\n<p>\u9ed8\u8ba4\u914d\u7f6e\u4e0b\u6700\u5927\u8fde\u63a5\u6570\u4e3a150\uff0c\u65e0\u6cd5\u6ee1\u8db3\u9ad8\u8d1f\u8f7d\u60c5\u51b5\u4e0b\u7684\u4f7f\u7528\u3002<\/p>\n<p>\u8be5\u64cd\u4f5c\u9700\u8981\u6709DBA\u6743\u9650\uff0c\u65b9\u6cd5\u5982\u4e0b<\/p>\n<div class=\"my-syntax-highlighter\">\n<pre><textarea id=\"mshighlighter\" class=\"mshighlighter\" language=\"shell\" name=\"mshighlighter\" >\r\nalter system set processes = 500 scope = spfile;\u00a0 --\u4fee\u6539\u6700\u5927\u8fde\u63a5\u6570\uff0c\u53ef\u4ee5\u6839\u636e\u60c5\u51b5\u52a0\u5927\u6570\u503c\r\nshutdown immediate;\u00a0 --\u91cd\u542f\u6570\u636e\u5e93\u5b9e\u4f8b\u4f7f\u914d\u7f6e\u4fee\u6539\u751f\u6548\r\nstartup;<\/textarea><\/pre>\n<\/div>\n<p>\u5b9e\u9645\u64cd\u4f5c\u5982\u4e0b<\/p>\n<p><img loading=\"lazy\" class=\"alignnone wp-image-643\" src=\"https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2023\/11\/oracle-update-conn-1-300x165.png\" alt=\"\" width=\"693\" height=\"381\" srcset=\"https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2023\/11\/oracle-update-conn-1-300x165.png 300w, https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2023\/11\/oracle-update-conn-1-1024x563.png 1024w, https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2023\/11\/oracle-update-conn-1-768x423.png 768w, https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2023\/11\/oracle-update-conn-1.png 1065w\" sizes=\"(max-width: 693px) 100vw, 693px\" \/><\/p>\n<p>\u4ee5\u4e0bSQL \u7528\u4e8e\u68c0\u67e5\u5f53\u524d\u914d\u7f6e<\/p>\n<div class=\"my-syntax-highlighter\">\n<pre><textarea id=\"mshighlighter\" class=\"mshighlighter\" language=\"shell\" name=\"mshighlighter\" >\r\nselect count(*) from v$process; --\u67e5\u770b\u6570\u636e\u5e93\u5f53\u524d\u8fde\u63a5\u6570\r\n\r\nselect value from v$parameter where name = 'processes'; --\u67e5\u770b\u6570\u636e\u5e93\u5f53\u524d\u914d\u7f6e\u6700\u5927\u8fde\u63a5\u6570\u662f\u591a\u5c11<\/textarea><\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>weblogic \u8fde\u63a5oralce\u5b9e\u4f8b\u51fa\u73b0\u8be5\u9879\u62a5\u9519\uff0c\u5bfc\u81f4\u539f\u56e0\u662f\u7531\u4e8e\u6570\u636e\u5e93\u8fde\u63a5\u6570\u8d85\u8fc7\u6570\u636e\u5e93\u8bbe\u7f6e\u5bfc\u81f4\u3002 \u9ed8\u8ba4\u914d\u7f6e\u4e0b\u6700\u5927\u8fde\u63a5\u6570\u4e3a150\uff0c &#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[59],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=\/wp\/v2\/posts\/642"}],"collection":[{"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=642"}],"version-history":[{"count":8,"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=\/wp\/v2\/posts\/642\/revisions"}],"predecessor-version":[{"id":651,"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=\/wp\/v2\/posts\/642\/revisions\/651"}],"wp:attachment":[{"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}