{"id":1581,"date":"2024-05-08T14:48:49","date_gmt":"2024-05-08T06:48:49","guid":{"rendered":"http:\/\/oneai.eu.org\/?p=1581"},"modified":"2024-05-08T14:48:49","modified_gmt":"2024-05-08T06:48:49","slug":"oracle%e6%97%a0%e6%b3%95%e5%90%af%e5%8a%a8%e8%a7%a3%e5%86%b3%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/oneai.eu.org\/?p=1581","title":{"rendered":"oracle\u65e0\u6cd5\u542f\u52a8\u89e3\u51b3\u65b9\u6cd5"},"content":{"rendered":"<p>\u53d1\u73b0\u53c8\u62a5\u4e86\u201cORA-12514 TNS \u76d1\u542c\u7a0b\u5e8f\u5f53\u524d\u65e0\u6cd5\u8bc6\u522b\u8fde\u63a5\u63cf\u8ff0\u7b26\u4e2d\u8bf7\u6c42\u670d\u52a1\u201d\u9519\u8bef<\/p>\n<p>\u542f\u52a8\u76d1\u542c\uff1alsnrctl start<br \/>\n\u67e5\u770b\u76d1\u542c\uff1alsnrctl status<br \/>\n\u505c\u6b62\u76d1\u542c\uff1alsnrctl stop <\/p>\n<p>sqlplus 'sys\/passwd@ORCL as sysdba'<\/p>\n<p>htne-cs.999.com.cn<br \/>\nlistener.ora<\/p>\n<p>172.16.1.192<\/p>\n<p>\u89e3\u51b3\u65b9\u6cd5\u4e00\uff1a<\/p>\n<p>\u5728listener.ora\u91cc\u9762\u6dfb\u52a0\u4e86\u4e00\u884c<\/p>\n<p>SID_LIST_LISTENER =<br \/>\n(SID_LIST =<br \/>\n(SID_DESC =<br \/>\n(GLOBAL_DBNAME = orcl)<br \/>\n(SID_NAME = orcl)<br \/>\n)<br \/>\n)<br \/>\n\u91cd\u65b0\u542f\u52a8\u76d1\u542c\uff1a<br \/>\nlsnrctl start <\/p>\n<p>\u6ce8\uff1a\u91cc\u9762\u7684orcl\u6839\u636e\u4f60\u5b89\u88c5\u7684\u6570\u636e\u5e93\u5b9e\u4f8b\u540d\u786e\u5b9a\uff0c\u6211\u7528\u6b64\u6cd5\u89e3\u51b3\u4e86\u8fd9\u4e2a\u62a5\u9519\u3002<\/p>\n<p>\u89e3\u51b3\u65b9\u6cd5\u4e8c\uff1a<\/p>\n<h2>\u767b\u5f55\u6570\u636e\u5e93\uff1a<br \/>\n$sqlplus \/ as sysdba<br \/>\n\u663e\u793a\u670d\u52a1\u540d\uff1a<br \/>\nSQL&gt;show parameter service_names<br \/>\n\u5f3a\u5236\u6ce8\u518c\u670d\u52a1\uff1a<br \/>\nSQL&gt;alter system register;<br \/>\n\u67e5\u770b\u76d1\u542c\u72b6\u6001\uff1a<br \/>\n$lsnrctl status<\/h2>\n<p>sqlplus sys\/ as sysdba<br \/>\nstartup<\/p>\n<p>2\u3002\u4fee\u6539processes\u548csessions\u503c<br \/>\nSQL&gt; alter system set processes=300 scope=spfile;<br \/>\n\u7cfb\u7edf\u5df2\u66f4\u6539\u3002<br \/>\nSQL&gt; alter system set sessions=300 scope=spfile;<br \/>\n\u7cfb\u7edf\u5df2\u66f4\u6539\u3002<br \/>\nshow parameter session<br \/>\nshow parameter process<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u53d1\u73b0\u53c8\u62a5\u4e86\u201cORA-12514 TNS \u76d1\u542c\u7a0b\u5e8f\u5f53\u524d\u65e0\u6cd5\u8bc6\u522b\u8fde\u63a5\u63cf\u8ff0\u7b26\u4e2d\u8bf7\u6c42\u670d\u52a1\u201d\u9519\u8bef \u542f\u52a8\u76d1\u542c\uff1alsnrctl start \u67e5\u770b\u76d1\u542c\uff1alsnrctl status \u505c\u6b62\u76d1\u542c\uff1alsnrctl stop sqlplus &#8216;sys\/passwd@ORCL as sysdba&#8217; htne-cs.999.com.cn listener.ora 172.16.1.192 \u89e3\u51b3\u65b9\u6cd5\u4e00\uff1a \u5728listener.ora\u91cc\u9762\u6dfb\u52a0\u4e86\u4e00\u884c SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl) (SID_NAME = orcl) ) ) \u91cd\u65b0\u542f\u52a8\u76d1\u542c\uff1a lsnrctl start \u6ce8\uff1a\u91cc\u9762\u7684orcl\u6839\u636e\u4f60\u5b89\u88c5\u7684\u6570\u636e\u5e93\u5b9e\u4f8b\u540d\u786e\u5b9a\uff0c\u6211\u7528\u6b64\u6cd5\u89e3\u51b3\u4e86\u8fd9\u4e2a\u62a5\u9519\u3002 \u89e3\u51b3\u65b9\u6cd5\u4e8c\uff1a \u767b\u5f55\u6570\u636e\u5e93\uff1a $sqlplus \/ as sysdba \u663e\u793a\u670d\u52a1\u540d\uff1a SQL&gt;show parameter service_names \u5f3a\u5236\u6ce8\u518c\u670d\u52a1\uff1a SQL&gt;alter system register; \u67e5\u770b\u76d1\u542c\u72b6\u6001\uff1a $lsnrctl status sqlplus sys\/ as sysdba startup 2\u3002\u4fee\u6539processes\u548csessions\u503c SQL&gt; alter system set processes=300 scope=spfile; \u7cfb\u7edf\u5df2\u66f4\u6539\u3002 SQL&gt; alter system set sessions=300 scope=spfile; \u7cfb\u7edf\u5df2\u66f4\u6539\u3002 show parameter session show parameter process<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[88,82],"tags":[],"class_list":["post-1581","post","type-post","status-publish","format-standard","hentry","category-oracle","category-82"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1581","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1581"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1581\/revisions"}],"predecessor-version":[{"id":1582,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1581\/revisions\/1582"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1581"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1581"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1581"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}