{"id":2055,"date":"2025-04-18T14:50:29","date_gmt":"2025-04-18T06:50:29","guid":{"rendered":"http:\/\/www.821121.com\/?p=2055"},"modified":"2025-05-09T17:08:05","modified_gmt":"2025-05-09T09:08:05","slug":"%e9%9d%99%e6%80%81%e7%9b%91%e5%90%ac%e5%af%b9adg%e7%9a%84%e5%bd%b1%e5%93%8d","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=2055","title":{"rendered":"\u9759\u6001\u76d1\u542c\u5bf9ADG\u7684\u5f71\u54cd"},"content":{"rendered":"<h1>\u524d\u63d0\u77e5\u8bc6<\/h1>\n<ul>\n<li>\u5ba2\u6237\u7aef\u8fde\u63a5RAC\u7684TNS\u4e32\u4f7f\u7528\u591aIP\u65b9\u5f0f\u8fde\u63a5\uff0c\u4f1a\u9ed8\u8ba4\u5148\u8fde\u63a5IP1\uff0c\u82e5IP1\u65e0\u6cd5\u8fde\u63a5\u65f6\uff0c\u624d\u4f1a\u8fde\u63a5IP2\uff0c\u4ee5\u6b64\u7c7b\u63a8<br \/>\n\u53c2\u8003\u8bd5\u9a8c <a href=\"http:\/\/www.821121.com\/?p=2042\u4e0d\u540c\u8fde\u63a5\u4e32\u914d\u7f6e\u4ea7\u751f\u7684\u6548\u679c\">http:\/\/www.821121.com\/?p=2042\u4e0d\u540c\u8fde\u63a5\u4e32\u914d\u7f6e\u4ea7\u751f\u7684\u6548\u679c<\/a><\/li>\n<li>\u5f53\u4e3b\u5e93\u4e3a\u96c6\u7fa4\u73af\u5883\u5e76\u914d\u7f6e\u6709\u672c\u8282\u70b9\u9759\u6001\u76d1\u542c\u65f6\uff0c\u82e5IP1\u6240\u5728\u96c6\u7fa4\u73af\u5883\u7684\u6570\u636e\u5e93\u5173\u95ed\uff08\u4e0d\u5173\u95ed\u76d1\u542c\u3001\u96c6\u7fa4\u670d\u52a1\uff09\uff0c\u5ba2\u6237\u7aef\u8fde\u63a5IP1\u4f1a\u53d7\u5230\u9759\u6001\u76d1\u542c\u5f71\u54cd\uff0c\u4e0d\u4f1a\u5c1d\u8bd5\u540e\u7eedIP2\uff0c\u4ece\u800c\u9020\u6210\u8fde\u63a5\u5f02\u5e38<\/li>\n<li>\u6b64\u6b21\u6a21\u62df\u8bd5\u9a8c\u65f6\u5728\u4e0a\u8ff0\u524d\u63d0\u4e0b\u6a21\u62df\u8be5\u8fde\u63a5\u4e32\u914d\u7f6e\u5bf9ADG\u7684\u5f71\u54cd<\/li>\n<\/ul>\n<h1>\u73af\u5883\u4ecb\u7ecd<\/h1>\n<h2>\u4e3b\u4ece\u60c5\u51b5<\/h2>\n<table>\n<thead>\n<tr>\n<th style=\"text-align: left;\"><\/th>\n<th style=\"text-align: left;\">\u4e3b<\/th>\n<th style=\"text-align: left;\">\u4ece<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"text-align: left;\">\u64cd\u4f5c\u7cfb\u7edf<\/td>\n<td style=\"text-align: left;\">CentOS 7.6.1810 (Core)<\/td>\n<td style=\"text-align: left;\">CentOS 7.6.1810 (Core)<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">\u6570\u636e\u5e93\u7c7b\u578b<\/td>\n<td style=\"text-align: left;\">RAC<\/td>\n<td style=\"text-align: left;\">\u5355\u673a<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">\u7248\u672c<\/td>\n<td style=\"text-align: left;\">19.3<\/td>\n<td style=\"text-align: left;\">19.3<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">IP<\/td>\n<td style=\"text-align: left;\">192.168.0.85  rac1\/192.168.0.86  rac2\/10.0.0.85  rac1priv\/10.0.0.86  rac2priv\/192.168.0.87  rac1vip\/192.168.0.88  rac2vip\/192.168.0.89  racscanip<\/td>\n<td style=\"text-align: left;\">192.168.0.143  oracle<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">log_archive_dest_2<\/td>\n<td style=\"text-align: left;\">log_archive_dest_2='SERVICE=orcl19cdg2 LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl19cdg2';<\/td>\n<td style=\"text-align: left;\">log_archive_dest_2='SERVICE=89orcl19c LGWR ASYNC NOAFFIRM delay=0 max_failure=0 reopen=60 VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl'<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\u4ece\u5e93143\u7684tnsnames.ora<\/h2>\n<pre><code class=\"language-sql\">89orcl19c =\n  (DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.85)(PORT = 1521))\n    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.86)(PORT = 1521))\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = orcl)\n    )\n  )\n\norcl19cdg2 =\n  (DESCRIPTION =\n    (ADDRESS_LIST =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.143)(PORT = 1521))\n    )\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = orcl19cdg2)\n    )\n)\n<\/code><\/pre>\n<h2>85\u76d1\u542c\u60c5\u51b5<\/h2>\n<pre><code class=\"language-sql\">[grid@rac1 ~]$ lsnrctl status\n\nLSNRCTL for Linux: Version 19.0.0.0.0 - Production on 10-DEC-2024 11:22:48\n\nCopyright (c) 1991, 2019, Oracle.  All rights reserved.\n\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))\nSTATUS of the LISTENER\n------------------------\nAlias                     LISTENER\nVersion                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production\nStart Date                09-DEC-2024 17:27:51\nUptime                    0 days 17 hr. 54 min. 56 sec\nTrace Level               off\nSecurity                  ON: Local OS Authentication\nSNMP                      OFF\nListener Parameter File   \/u01\/app\/19.3.0\/grid\/network\/admin\/listener.ora\nListener Log File         \/u01\/app\/grid\/diag\/tnslsnr\/rac1\/listener\/alert\/log.xml\nListening Endpoints Summary...\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.85)(PORT=1521)))\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.87)(PORT=1521)))\nServices Summary...\nService &quot;+ASM&quot; has 1 instance(s).\n  Instance &quot;+ASM1&quot;, status READY, has 1 handler(s) for this service...\nService &quot;+ASM_ARCH&quot; has 1 instance(s).\n  Instance &quot;+ASM1&quot;, status READY, has 1 handler(s) for this service...\nService &quot;+ASM_DATA&quot; has 1 instance(s).\n  Instance &quot;+ASM1&quot;, status READY, has 1 handler(s) for this service...\nService &quot;+ASM_OCR&quot; has 1 instance(s).\n  Instance &quot;+ASM1&quot;, status READY, has 1 handler(s) for this service...\nService &quot;+ASM_TEST&quot; has 1 instance(s).\n  Instance &quot;+ASM1&quot;, status READY, has 1 handler(s) for this service...\nService &quot;24821e337619f56ee0635600a8c08e13&quot; has 1 instance(s).\n  Instance &quot;orcl1&quot;, status READY, has 1 handler(s) for this service...\nService &quot;266aeef7edadba24e0635500a8c080e0&quot; has 1 instance(s).\n  Instance &quot;orcl1&quot;, status READY, has 1 handler(s) for this service...\nService &quot;86b637b62fdf7a65e053f706e80a27ca&quot; has 1 instance(s).\n  Instance &quot;orcl1&quot;, status READY, has 1 handler(s) for this service...\nService &quot;orcl&quot; has 2 instance(s).\n  Instance &quot;orcl1&quot;, status UNKNOWN, has 1 handler(s) for this service...\n  Instance &quot;orcl1&quot;, status READY, has 1 handler(s) for this service...\nService &quot;orclXDB&quot; has 1 instance(s).\n  Instance &quot;orcl1&quot;, status READY, has 1 handler(s) for this service...\nService &quot;pdb&quot; has 1 instance(s).\n  Instance &quot;orcl1&quot;, status READY, has 1 handler(s) for this service...\nService &quot;testpdb&quot; has 1 instance(s).\n  Instance &quot;orcl1&quot;, status READY, has 1 handler(s) for this service...\nThe command completed successfully<\/code><\/pre>\n<h2>86\u76d1\u542c\u60c5\u51b5(\u7565)<\/h2>\n<h1>\u6a21\u62df\u6b65\u9aa4\uff08\u56e0\u535a\u5ba2\u7bc7\u5e45\u6709\u9650\uff0c\u65e5\u5fd7\u6216\u6587\u4ef6\u8bb0\u5f55\u8fc7\u957f\uff0c\u6539\u4e3a\u7701\u7565\u4e0d\u5c55\u793a)<\/h1>\n<h2>\u5b9e\u9a8c\u4e00\u3001ADG\u6b63\u5e38\u60c5\u51b5\u4e0b\uff0c85\u5173\u95ed\uff0c\u540c\u6b65\u662f\u5426\u6b63\u5e38<\/h2>\n<h3>85\u8282\u70b9\u5207\u96c6\u7fa4\u65e5\u5fd7\u5e76\u5173\u5e93<\/h3>\n<h4>85\u5b9e\u4f8b\u65e5\u5fd7(\u7565)<\/h4>\n<h4>\u68c0\u67e5Asm\u91cc\u7684\u5f52\u6863\u6587\u4ef6(\u7565)<\/h4>\n<h4>\u4ece\u5e93143\u5b9e\u4f8b\u65e5\u5fd7\u60c5\u51b5(\u7565)<\/h4>\n<h4>\u4ece\u5e93143\u5f52\u6863\u76ee\u5f55\u60c5\u51b5(\u7565)<\/h4>\n<h4>85\u505c\u5e93\u60c5\u51b5\u4e0b86\u5207\u65e5\u5fd7(\u7565)<\/h4>\n<h4>\u4ece\u5e93143\u5b9e\u4f8b\u65e5\u5fd7\u60c5\u51b5(\u7565)<\/h4>\n<h4>\u4ece\u5e93143\u5f52\u6863\u60c5\u51b5(\u7565)<\/h4>\n<h3>\u7ed3\u8bba<\/h3>\n<p>\u53ef\u6b63\u5e38\u540c\u6b65<\/p>\n<h2>\u5b9e\u9a8c\u4e8c\u3001ADG\u5f02\u5e38\uff0c85\u5173\u95ed\uff0c86\u5207\u6362\u65e5\u5fd7\uff0c\u4ece\u5e93143\u91cd\u65b0\u5f00\u542f\u540e\u540c\u6b65\u662f\u5426\u6b63\u5e38<\/h2>\n<h4>86\u5b9e\u4f8b\u65e5\u5fd7(\u7565)<\/h4>\n<p><!--more--><\/p>\n<p>86\u65e5\u5fd7\u663e\u793a\uff0c\u8fde\u63a5\u65ad\u5f00\uff0c\u540e\u7eed\u5f52\u6863\u6ca1\u80fd\u81ea\u52a8\u4f20\u7ed9\u4ece\u5e93143\uff0c\u6bcf300\u79d2\u5c1d\u8bd5\u8fde\u63a5\u4ece\u5e93143<\/p>\n<h4>\u4ece\u5e93143\u65e5\u5fd7(\u7565)<\/h4>\n<h3>\u7ed3\u8bba<\/h3>\n<p>\u53d7\u76d1\u542c\u5f71\u54cd\uff0c\u4ece\u5e93143\u91cd\u65b0\u5f00\u5e93\u5e76\u5f00\u542f\u540c\u6b65\u662f\u65e0\u6cd5\u4e3b\u52a8\u83b7\u53d6\u5230\u5f52\u6863\u7684\uff0c\u9700\u8981\u4e3b\u5e93\u8fdb\u7a0b\u6062\u590d\u8fde\u63a5\uff08\u9ed8\u8ba4300\u79d2\u8f6e\u8be2\uff09\u540e\u4e3b\u52a8\u53d1\u9001\u7ed9\u4ece\u5e93143<\/p>\n<h2>\u5b9e\u9a8c\u4e09\u3001\u518d\u5b9e\u9a8c\u4e8c\u7684\u57fa\u7840\u4e0a\u4fee\u6539\u8fde\u63a5\u4e32\u4e3ascanIP<\/h2>\n<h4>\u4ece\u5e93143\u7684tnsnames.ora<\/h4>\n<pre><code class=\"language-sql\">89orcl19c =\n  (DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.89)(PORT = 1521))\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = orcl)\n    )\n  )\n\norcl19cdg2 =\n  (DESCRIPTION =\n    (ADDRESS_LIST =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.143)(PORT = 1521))\n    )\n<\/code><\/pre>\n<h3>\u7ed3\u8bba<\/h3>\n<p>\u82e5\u4ece\u5e93143\u8fde\u63a5\u4e32\u6539\u4e3a\u8fde\u63a5SCANIP \uff0c\u4ece\u5e93143\u5f00\u5e93\u5c31\u80fd\u4e3b\u52a8\u8fde\u63a5\u4e0a86\uff0c\u4e0d\u7528\u7b49\u5f85300\u79d2\u7684\u4e3b\u5e93\u8f6e\u8be2<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.821121.com\/wp-content\/uploads\/2025\/12\/image-1736148449735.png\" alt=\"file\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u524d\u63d0\u77e5\u8bc6 \u5ba2\u6237\u7aef\u8fde\u63a5RAC\u7684TNS\u4e32\u4f7f\u7528\u591aIP\u65b9\u5f0f<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49,51,52],"tags":[],"class_list":["post-2055","post","type-post","status-publish","format-standard","hentry","category-oracle-19c","category--oracle-19c"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/2055","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2055"}],"version-history":[{"count":18,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/2055\/revisions"}],"predecessor-version":[{"id":2074,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/2055\/revisions\/2074"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2055"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2055"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2055"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}