{"id":73,"date":"2024-06-28T14:06:26","date_gmt":"2024-06-28T06:06:26","guid":{"rendered":"http:\/\/192.168.5.24\/?p=73"},"modified":"2025-04-28T11:27:19","modified_gmt":"2025-04-28T03:27:19","slug":"windows-server-%e5%ae%89%e8%a3%85oracle%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/bigvip.dpdns.org\/?p=73","title":{"rendered":"Windows Server \u5b89\u88c5Oracle\u914d\u7f6e\u65b9\u6cd5"},"content":{"rendered":"\n<p class=\"has-small-font-size\">1\u3001\u5b89\u88c5\u524d\u51c6\u5907\uff0c\u9700\u8981\u5b89\u88c5 .net framwork 2.3<\/p>\n\n\n\n<p>2\u3001<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"787\" height=\"591\" src=\"http:\/\/192.168.5.24\/wp-content\/uploads\/2024\/06\/oracle1.jpg\" alt=\"\" class=\"wp-image-89\" srcset=\"https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/oracle1.jpg 787w, https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/oracle1-300x225.jpg 300w, https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/oracle1-768x577.jpg 768w\" sizes=\"auto, (max-width: 787px) 100vw, 787px\" \/><\/figure>\n\n\n\n<p>3\u3001\u76d1\u542c\u7684\u67e5\u8be2<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&gt;lsnrctl status    --\u67e5\u770b\u76d1\u542c\u7684\u72b6\u6001\u3002\n&gt;lsnrctl start\n&gt;lsnrctl stop\n&gt;lsnrctl reload\n<\/code><\/pre>\n\n\n\n<p>4\u3001\u67e5\u8be2\u670d\u52a1\u540d\u79f0(\u7b2c2\u6b65\u4e2d\u7684\u201c\u5168\u5c40\u6570\u636e\u5e93\u540d\u201d)<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\u6253\u5f00sql plus\nSQL&gt; show parameter service;\n\nNAME                 TYPE          VALUE\n--------------    -----------    -----------------\nservice_names       string       <strong> orcl.168.5.20<\/strong><\/code><\/pre>\n\n\n\n<p>5\u3001\u67e5\u8be2\u4e3b\u673a\u540d\u79f0<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>C:\\Users\\Administrator&gt;hostname\nWIN-L5EC7CO66O8<\/code><\/pre>\n\n\n\n<p>6\u3001TCP\/IP\u76d1\u542c\u7684\u914d\u7f6e<\/p>\n\n\n\n<p>\u6253\u5f00Net Manager<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"756\" height=\"643\" src=\"http:\/\/192.168.5.24\/wp-content\/uploads\/2024\/06\/image.png\" alt=\"\" class=\"wp-image-98\" style=\"width:812px;height:auto\" srcset=\"https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/image.png 756w, https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/image-300x255.png 300w\" sizes=\"auto, (max-width: 756px) 100vw, 756px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"759\" height=\"645\" src=\"http:\/\/192.168.5.24\/wp-content\/uploads\/2024\/06\/image-1.png\" alt=\"\" class=\"wp-image-99\" srcset=\"https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/image-1.png 759w, https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/image-1-300x255.png 300w\" sizes=\"auto, (max-width: 759px) 100vw, 759px\" \/><\/figure>\n\n\n\n<p>\u8fd9\u91cc\u7684\u4e3b\u673a\u586b\u5199\u4e0a\u9762\u67e5\u8be2\u5230\u7684\u4e3b\u673a\u540d\u79f0\uff1a<mark style=\"background-color:#0073a8\" class=\"has-inline-color has-dark-gray-color\">WIN-L5EC7CO66O8<\/mark> \u6216\u8005localhost\u6216\u8005\u670d\u52a1\u5668\u7684IP\u5730\u5740\u3002<\/p>\n\n\n\n<p>7\u3001\u521b\u5efa\u7f51\u7edc\u670d\u52a1\u540d<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"754\" height=\"640\" src=\"http:\/\/192.168.5.24\/wp-content\/uploads\/2024\/06\/image-2.png\" alt=\"\" class=\"wp-image-101\" srcset=\"https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/image-2.png 754w, https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/image-2-300x255.png 300w\" sizes=\"auto, (max-width: 754px) 100vw, 754px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"758\" height=\"639\" src=\"http:\/\/192.168.5.24\/wp-content\/uploads\/2024\/06\/image-4.png\" alt=\"\" class=\"wp-image-103\" style=\"width:565px;height:auto\" srcset=\"https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/image-4.png 758w, https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/image-4-300x253.png 300w\" sizes=\"auto, (max-width: 758px) 100vw, 758px\" \/><\/figure>\n\n\n\n<p>\u6b64\u5904\u4e3b\u673a\u540d\u4e3aoracle\u6570\u636e\u5e93\u7684ip\u5730\u5740\u6216\u8005localhost<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"755\" height=\"635\" src=\"http:\/\/192.168.5.24\/wp-content\/uploads\/2024\/06\/image-5.png\" alt=\"\" class=\"wp-image-104\" srcset=\"https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/image-5.png 755w, https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/image-5-300x252.png 300w\" sizes=\"auto, (max-width: 755px) 100vw, 755px\" \/><\/figure>\n\n\n\n<p>\u6b64\u5904\u7684\u670d\u52a1\u540d\u4e3a\u4e0a\u9762\u7b2c4\u6b65\u67e5\u5230\u7684\u670d\u52a1\u540d\uff08<strong>\u91cd\u8981<\/strong>\uff09<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"757\" height=\"639\" src=\"http:\/\/192.168.5.24\/wp-content\/uploads\/2024\/06\/image-6.png\" alt=\"\" class=\"wp-image-106\" srcset=\"https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/image-6.png 757w, https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/image-6-300x253.png 300w\" sizes=\"auto, (max-width: 757px) 100vw, 757px\" \/><\/figure>\n\n\n\n<p>\u914d\u7f6e\u5b8c\u6210\u540e\u4fdd\u5b58\u914d\u7f6e\u4fe1\u606f\u5373\u53ef\u3002<\/p>\n\n\n\n<p>8\u3001\u5f00\u542f\u5f52\u6863\u6a21\u5f0f<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\u4f7f\u7528sql plus \u8fde\u63a5\u6570\u636e\u5e93\nEnter user-name: sys \/ as sysdba\nEnter password:\n\nSQL> archive log list;\nDatabase log mode              No Archive Mode\nAutomatic archival             Disabled\nArchive destination            USE_DB_RECOVERY_FILE_DEST\nOldest online log sequence     12\nCurrent log sequence           14\n\nSQL> shutdown immediate;\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\n\nSQL> startup mount;\nORACLE instance started.\n\nTotal System Global Area 2421825536 bytes\nFixed Size                  2178136 bytes\nVariable Size            1358955432 bytes\nDatabase Buffers         1040187392 bytes\nRedo Buffers               20504576 bytes\nDatabase mounted.\n\nSQL> alter database archivelog;\n\nDatabase altered.\n\nSQL> alter database open;\n\nDatabase altered.\n\nSQL> archive log list;\nDatabase log mode              Archive Mode\nAutomatic archival             Enabled\nArchive destination            USE_DB_RECOVERY_FILE_DEST\nOldest online log sequence     12\nNext log sequence to archive   14\nCurrent log sequence           14\nSQL><\/code><\/pre>\n\n\n\n<p>\u9a8c\u8bc1<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"205\" src=\"http:\/\/192.168.5.24\/wp-content\/uploads\/2024\/06\/image-11-1024x205.png\" alt=\"\" class=\"wp-image-1086\" srcset=\"https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/image-11-1024x205.png 1024w, https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/image-11-300x60.png 300w, https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/image-11-768x153.png 768w, https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/image-11-816x163.png 816w, https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2024\/06\/image-11.png 1061w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1\u3001\u5b89\u88c5\u524d\u51c6\u5907\uff0c\u9700\u8981\u5b89\u88c5 .net framwork 2.3 2\u3001 3\u3001\u76d1\u542c\u7684\u67e5\u8be2 4\u3001\u67e5\u8be2\u670d\u52a1\u540d\u79f0(\u7b2c2\u6b65\u4e2d [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,35],"tags":[21,22],"class_list":["post-73","post","type-post","status-publish","format-standard","hentry","category-windows","category-35","tag-oracle","tag-22"],"_links":{"self":[{"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=\/wp\/v2\/posts\/73","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=73"}],"version-history":[{"count":14,"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=\/wp\/v2\/posts\/73\/revisions"}],"predecessor-version":[{"id":1087,"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=\/wp\/v2\/posts\/73\/revisions\/1087"}],"wp:attachment":[{"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=73"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=73"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=73"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}