{"id":5049,"date":"2024-11-14T10:50:17","date_gmt":"2024-11-14T02:50:17","guid":{"rendered":"https:\/\/fwq.ai\/blog\/5049\/"},"modified":"2024-11-14T10:50:17","modified_gmt":"2024-11-14T02:50:17","slug":"oracle%e9%85%8d%e7%bd%ae%e6%83%85%e5%86%b5%e6%80%8e%e4%b9%88%e6%9f%a5%e7%9c%8b","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/5049\/","title":{"rendered":"oracle\u914d\u7f6e\u60c5\u51b5\u600e\u4e48\u67e5\u770b"},"content":{"rendered":"<blockquote><p>\n  \u67e5\u770b oracle \u914d\u7f6e\u60c5\u51b5\uff1a\u6570\u636e\u5e93\u914d\u7f6e\uff1a\u4f7f\u7528 sql plus \u6216 enterprise manager \u67e5\u8be2 v$parameter \u8868\u3002\u670d\u52a1\u5668\u914d\u7f6e\uff1a\u4f7f\u7528 java \u7684 getdrivername() \u6216 c# \u7684 serverversion\u3002\u7f51\u7edc\u914d\u7f6e\uff1a\u4f7f\u7528 sql plus \u67e5\u8be2 v$listener \u8868\u6216\u901a\u8fc7 net manager \u67e5\u770b\u3002\u4f1a\u8bdd\u914d\u7f6e\uff1a\u4f7f\u7528 sql plus \u67e5\u8be2 v$session \u8868\u3002\u73af\u5883\u53d8\u91cf\uff1a\u5728 windows \u4e2d\u67e5\u770b\u7cfb\u7edf\u5c5e\u6027\u4e2d\u7684\u73af\u5883\u53d8\u91cf\uff0c\u6216\u5728 unix\/linux\n<\/p><\/blockquote>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/202405\/21\/2024052112541826366.jpg\" class=\"aligncenter\" title=\"oracle\u914d\u7f6e\u60c5\u51b5\u600e\u4e48\u67e5\u770b\u63d2\u56fe\" alt=\"oracle\u914d\u7f6e\u60c5\u51b5\u600e\u4e48\u67e5\u770b\u63d2\u56fe\" \/><\/p>\n<p><strong>\u5982\u4f55\u67e5\u770b Oracle \u914d\u7f6e\u60c5\u51b5<\/strong><\/p>\n<p><strong>\u76f4\u63a5\u67e5\u770b\u6570\u636e\u5e93\u914d\u7f6e<\/strong><\/p>\n<ul>\n<li> <strong>SQL Plus<\/strong>\uff1a\u4f7f\u7528 SELECT * FROM V$PARAMETER; \u67e5\u8be2\u6570\u636e\u5e93\u53c2\u6570\u3002<\/li>\n<li> <strong>Enterprise Manager (EM)<\/strong>\uff1a\u5bfc\u822a\u5230 &#8220;\u76d1\u63a7&#8221;\uff0c\u7136\u540e\u9009\u62e9 &#8220;\u6570\u636e\u5e93&#8221;\uff0c\u5355\u51fb &#8220;\u914d\u7f6e&#8221;\u3002<\/li>\n<\/ul>\n<p><strong>\u67e5\u770b\u670d\u52a1\u5668\u914d\u7f6e<\/strong><\/p>\n<ul>\n<li> <strong>Java<\/strong>\uff1a\u4f7f\u7528 OracleConnection.getMetaData().getDriverName();\u3002<\/li>\n<li> <strong>C#<\/strong>\uff1a\u4f7f\u7528 OracleConnection.ServerVersion\u3002<\/li>\n<\/ul>\n<p><strong>\u67e5\u770b\u7f51\u7edc\u914d\u7f6e<\/strong><\/p>\n<ul>\n<li> <strong>SQL Plus<\/strong>\uff1a\u4f7f\u7528 SELECT * FROM V$LISTENER; \u67e5\u8be2\u76d1\u542c\u7a0b\u5e8f\u914d\u7f6e\u3002<\/li>\n<li> <strong>Net Manager (NM)<\/strong>\uff1a\u5bfc\u822a\u5230 &#8220;\u7f51\u7edc\u914d\u7f6e&#8221;\u3002<\/li>\n<\/ul>\n<p><strong>\u67e5\u770b\u4f1a\u8bdd\u914d\u7f6e<\/strong><\/p>\n<ul>\n<li> <strong>SQL Plus<\/strong>\uff1a\u4f7f\u7528 SELECT * FROM V$SESSION; \u67e5\u8be2\u4f1a\u8bdd\u53d8\u91cf\u3002<\/li>\n<\/ul>\n<p><strong>\u67e5\u770b\u73af\u5883\u53d8\u91cf<\/strong><\/p>\n<ul>\n<li> <strong>Windows<\/strong>\uff1a\u6253\u5f00 &#8220;\u63a7\u5236\u9762\u677f&#8221;\uff0c\u9009\u62e9 &#8220;\u7cfb\u7edf\u548c\u5b89\u5168&#8221;\uff0c\u7136\u540e\u5355\u51fb &#8220;\u7cfb\u7edf&#8221;\uff0c\u9009\u62e9 &#8220;\u9ad8\u7ea7\u7cfb\u7edf\u8bbe\u7f6e&#8221;\uff0c\u7136\u540e\u5355\u51fb &#8220;\u73af\u5883\u53d8\u91cf&#8221;\u3002<\/li>\n<li> <strong>Unix\/Linux<\/strong>\uff1a\u5728\u7ec8\u7aef\u4e2d\u8f93\u5165 env \u547d\u4ee4\u3002<\/li>\n<\/ul>\n<p><strong>\u5176\u4ed6\u65b9\u6cd5<\/strong><\/p>\n<ul>\n<li> <strong>\u7b2c\u4e09\u65b9\u5de5\u5177<\/strong>\uff0c\u4f8b\u5982 &#8220;Oracle Database Control&#8221; \u6216 &#8220;toad for Oracle&#8221;\u3002<\/li>\n<li> <strong>\u64cd\u4f5c\u7cfb\u7edf\u547d\u4ee4<\/strong>\uff0c\u4f8b\u5982 &#8220;ps -ef | grep &#8220;\u3002<\/li>\n<\/ul>\n<p><strong>\u6269\u5c55\u4fe1\u606f<\/strong><\/p>\n<ul>\n<li>V$\u89c6\u56fe\u662f Oracle \u63d0\u4f9b\u7684\u7279\u6b8a\u8868\uff0c\u7528\u4e8e\u67e5\u770b\u6570\u636e\u5e93\u5185\u90e8\u4fe1\u606f\u3002<\/li>\n<li>DriverName \u548c ServerVersion \u5c5e\u6027\u63d0\u4f9b Oracle \u9a71\u52a8\u7a0b\u5e8f\u548c\u670d\u52a1\u5668\u7684\u7248\u672c\u4fe1\u606f\u3002<\/li>\n<li>V$LISTENER \u89c6\u56fe\u5305\u542b\u6709\u5173\u76d1\u542c\u7a0b\u5e8f\u7684\u8be6\u7ec6\u4fe1\u606f\uff0c\u4f8b\u5982\u4fa6\u542c\u5730\u5740\u548c\u7aef\u53e3\u3002<\/li>\n<li>\u4f1a\u8bdd\u53d8\u91cf\u662f\u4e0e\u5f53\u524d\u4f1a\u8bdd\u5173\u8054\u7684\u914d\u7f6e\u8bbe\u7f6e\u3002<\/li>\n<li>\u73af\u5883\u53d8\u91cf\u5728\u542f\u52a8 Oracle \u8fdb\u7a0b\u65f6\u8bbe\u7f6e\uff0c\u5e76\u63a7\u5236\u6570\u636e\u5e93\u884c\u4e3a\u3002<\/li>\n<\/ul>\n<p>\u4ee5\u4e0a\u5c31\u662f\u914d\u7f6e\u60c5\u51b5\u600e\u4e48\u67e5\u770b\u7684\u8be6\u7ec6\u5185\u5bb9\uff0c\u66f4\u591a\u8bf7\u5173\u6ce8\u7c73\u4e91\u7f51\u5176\u5b83\u76f8\u5173\u6587\u7ae0\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u67e5\u770b oracle \u914d\u7f6e\u60c5\u51b5\uff1a\u6570\u636e\u5e93\u914d\u7f6e\uff1a\u4f7f\u7528 sql plus \u6216 enterprise manager \u67e5\u8be2 v$parameter \u8868\u3002\u670d\u52a1\u5668\u914d\u7f6e\uff1a\u4f7f\u7528 java \u7684 getdrivername() \u6216 c# \u7684 serverversion\u3002\u7f51\u7edc\u914d\u7f6e\uff1a\u4f7f\u7528 sql plus \u67e5\u8be2 v$listener \u8868\u6216\u901a\u8fc7 net manager \u67e5\u770b\u3002\u4f1a\u8bdd\u914d\u7f6e\uff1a\u4f7f\u7528 sql plus \u67e5\u8be2 v$session \u8868\u3002\u73af\u5883\u53d8\u91cf\uff1a\u5728 windows \u4e2d\u67e5\u770b\u7cfb\u7edf\u5c5e\u6027\u4e2d\u7684\u73af\u5883\u53d8\u91cf\uff0c\u6216\u5728 unix\/linux \u5982\u4f55\u67e5\u770b Oracle \u914d\u7f6e\u60c5\u51b5 \u76f4\u63a5\u67e5\u770b\u6570\u636e\u5e93\u914d\u7f6e SQL Plus\uff1a\u4f7f\u7528 SELECT * FROM V$PARAMETER; \u67e5\u8be2\u6570\u636e\u5e93\u53c2\u6570\u3002 Enterprise Manager (EM)\uff1a\u5bfc\u822a\u5230 &#8220;\u76d1\u63a7&#8221;\uff0c\u7136\u540e\u9009\u62e9 &#8220;\u6570\u636e\u5e93&#8221;\uff0c\u5355\u51fb &#8220;\u914d\u7f6e&#8221;\u3002 \u67e5\u770b\u670d\u52a1\u5668\u914d\u7f6e Java\uff1a\u4f7f\u7528 OracleConnection.getMetaData().getDriverName();\u3002 C#\uff1a\u4f7f\u7528 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-5049","post","type-post","status-publish","format-standard","hentry","category-16"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/5049","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=5049"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/5049\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=5049"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=5049"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=5049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}