{"id":798,"date":"2012-04-28T23:32:39","date_gmt":"2012-04-28T15:32:39","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=798"},"modified":"2012-05-01T22:03:32","modified_gmt":"2012-05-01T14:03:32","slug":"%e6%95%b0%e6%8d%ae%e5%ba%93vip%e5%9c%b0%e5%9d%80%e6%97%a0%e6%b3%95%e8%ae%bf%e9%97%ae%ef%bc%88%e4%b8%80%ef%bc%89","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=798","title":{"rendered":"\u6570\u636e\u5e93VIP\u5730\u5740\u65e0\u6cd5\u8bbf\u95ee\uff08\u4e00\uff09"},"content":{"rendered":"

\u5ba2\u6237\u7684\u6570\u636e\u5e93\u51fa\u73b0VIP\u5730\u5740\u65e0\u6cd5\u8bbf\u95ee\u7684\u60c5\u51b5\u3002
\n\u8fd9\u4e00\u7bc7\u63cf\u8ff0\u95ee\u9898\u7684\u8bca\u65ad\u3002
\n\u5ba2\u6237\u7684RAC\u73af\u5883\u91cd\u5efa\u540e\uff0c\u53d1\u73b0\u4e24\u4e2a\u8282\u70b9\u7684VIP\u90fd\u65e0\u6cd5\u8bbf\u95ee\uff0c\u5f00\u59cb\u8ba4\u4e3a\u662f\u7f51\u7edc\u95ee\u9898\uff0c\u4f46\u662f\u968f\u540e\u53d1\u73b0\u6574\u4e2aRAC\u91cd\u542f\u540e\uff0c\u5176\u4e2d\u4e00\u4e2a\u8282\u70b9\u7684VIP\u53ef\u4ee5\u8bbf\u95ee\uff0c\u800c\u53e6\u4e00\u4e2a\u8282\u70b9\u7684VIP\u4ecd\u7136\u65e0\u6cd5\u8bbf\u95ee\uff0c\u56e0\u6b64\u5224\u65ad\u53ef\u80fd\u662fRAC\u672c\u8eab\u7684\u95ee\u9898\u3002
\n\u542c\u5230\u95ee\u9898\u63cf\u8ff0\u540e\uff0c\u7b2c\u4e00\u4e2a\u5224\u65ad\u662f\u5426VIP\u6ca1\u6709\u542f\u52a8\uff0c\u767b\u5f55\u6570\u636e\u5e93\u670d\u52a1\u5668\u540e\u8fdb\u884c\u4e86\u68c0\u67e5\uff1a<\/p>\n

oracle@racdb1 $ lsnrctl status\r\nLSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 18-APR-2012 10:22:02\r\nCopyright (c) 1991, 2007, Oracle.  All rights reserved.\r\nConnecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))\r\nSTATUS of the LISTENER\r\n------------------------\r\nAlias                     LISTENER_RACDB1\r\nVersion                   TNSLSNR for Solaris: Version 10.2.0.4.0 - Production\r\nStart Date                25-MAR-2012 17:16:47\r\nUptime                    23 days 17 hr. 5 min. 15 sec\r\nTrace Level               off\r\nSecurity                  ON: Local OS Authentication\r\nSNMP                      OFF\r\nListener Parameter File   \/u01\/oracle\/product\/10.2\/database\/network\/admin\/listener.ora\r\nListener Log File         \/u01\/oracle\/product\/10.2\/database\/network\/log\/listener_racdb1.log\r\nListening Endpoints Summary...\r\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.8.60.201)(PORT=1521)))\r\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.8.60.1)(PORT=1521)))\r\nServices Summary...\r\nService \"+ASM\" has 1 instance(s).\r\n  Instance \"+ASM1\", status BLOCKED, has 1 handler(s) for this service...\r\nService \"+ASM_XPT\" has 1 instance(s).\r\n  Instance \"+ASM1\", status BLOCKED, has 1 handler(s) for this service...\r\nService \"PLSExtProc\" has 1 instance(s).\r\n  Instance \"PLSExtProc\", status UNKNOWN, has 1 handler(s) for this service...\r\nService \"racdb\" has 2 instance(s).\r\n  Instance \"racdb1\", status READY, has 2 handler(s) for this service...\r\n  Instance \"racdb2\", status READY, has 1 handler(s) for this service...\r\nService \"racdbXDB\" has 2 instance(s).\r\n  Instance \"racdb1\", status READY, has 1 handler(s) for this service...\r\n  Instance \"racdb2\", status READY, has 1 handler(s) for this service...\r\nService \"racdb_XPT\" has 2 instance(s).\r\n  Instance \"racdb1\", status READY, has 2 handler(s) for this service...\r\n  Instance \"racdb2\", status READY, has 1 handler(s) for this service...\r\nThe command completed successfully<\/pre>\n
\u8282\u70b92\uff1a<\/p>\n
oracle@racdb2 $ lsnrctl status\r\nLSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 18-APR-2012 10:19:00\r\nCopyright (c) 1991, 2007, Oracle.  All rights reserved.\r\nConnecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))\r\nSTATUS of the LISTENER\r\n------------------------\r\nAlias                     LISTENER_RACDB2\r\nVersion                   TNSLSNR for Solaris: Version 10.2.0.4.0 - Production\r\nStart Date                25-MAR-2012 17:14:28\r\nUptime                    23 days 17 hr. 4 min. 31 sec\r\nTrace Level               off\r\nSecurity                  ON: Local OS Authentication\r\nSNMP                      OFF\r\nListener Parameter File   \/u01\/oracle\/product\/10.2\/database\/network\/admin\/listener.ora\r\nListener Log File         \/u01\/oracle\/product\/10.2\/database\/network\/log\/listener_racdb2.log\r\nListening Endpoints Summary...\r\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.8.60.202)(PORT=1521)))\r\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.8.60.3)(PORT=1521)))\r\nServices Summary...\r\nService \"+ASM\" has 1 instance(s).\r\n  Instance \"+ASM2\", status BLOCKED, has 1 handler(s) for this service...\r\nService \"+ASM_XPT\" has 1 instance(s).\r\n  Instance \"+ASM2\", status BLOCKED, has 1 handler(s) for this service...\r\nService \"PLSExtProc\" has 1 instance(s).\r\n  Instance \"PLSExtProc\", status UNKNOWN, has 1 handler(s) for this service...\r\nService \"racdb\" has 2 instance(s).\r\n  Instance \"racdb1\", status READY, has 1 handler(s) for this service...\r\n  Instance \"racdb2\", status READY, has 2 handler(s) for this service...\r\nService \"racdbXDB\" has 2 instance(s).\r\n  Instance \"racdb1\", status READY, has 1 handler(s) for this service...\r\n  Instance \"racdb2\", status READY, has 1 handler(s) for this service...\r\nService \"racdb_XPT\" has 2 instance(s).\r\n  Instance \"racdb1\", status READY, has 1 handler(s) for this service...\r\n  Instance \"racdb2\", status READY, has 2 handler(s) for this service...\r\nThe command completed successfully<\/pre>\n
\u4e24\u4e2a\u8282\u70b9\u7684\u76d1\u542c\u90fd\u662f\u6b63\u5e38\u7684\uff1a<\/p>\n
oracle@racdb1 $ sqlplus \/ as sysdba\r\nSQL*Plus: Release 10.2.0.4.0 - Production on Wed Apr 18 10:20:06 2012\r\nCopyright (c) 1982, 2007, Oracle.  All Rights Reserved.\r\nConnected to:\r\nOracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, OLAP, Data Mining\r\nand Real Application Testing options\r\nSQL> show parameter service_name\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\nservice_names                        string      racdb\r\nSQL> show parameter listener\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\nlocal_listener                       string\r\nremote_listener                      string      LISTENERS_RACDB\r\noracle@racdb1 $ cd $ORACLE_HOME\/network\/admin\r\noracle@racdb1 $ more listener.ora\r\n# listener.ora.racdb1 Network Configuration File: \/u01\/oracle\/product\/10.2\/database\/network\/admin\/listener.ora.racdb1\r\n# Generated by Oracle configuration tools.\r\nLISTENER_RACDB1 =\r\n  (DESCRIPTION_LIST =\r\n    (DESCRIPTION =\r\n      (ADDRESS = (PROTOCOL = TCP)(HOST = racdb1-vip)(PORT = 1521)(IP = FIRST))\r\n      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.60.1)(PORT = 1521)(IP = FIRST))\r\n    )\r\n  )\r\nSID_LIST_LISTENER_RACDB1 =\r\n  (SID_LIST =\r\n    (SID_DESC =\r\n      (SID_NAME = PLSExtProc)\r\n      (ORACLE_HOME = \/u01\/oracle\/product\/10.2\/database)\r\n      (PROGRAM = extproc)\r\n    )\r\n  )\r\noracle@racdb1 $ more tnsnames.ora\r\n# tnsnames.ora Network Configuration File: \/u01\/oracle\/product\/10.2\/database\/network\/admin\/tnsnames.ora\r\n# Generated by Oracle configuration tools.\r\nLISTENERS_RACDB =\r\n  (ADDRESS_LIST =\r\n    (ADDRESS = (PROTOCOL = TCP)(HOST = racdb1-vip)(PORT = 1521))\r\n    (ADDRESS = (PROTOCOL = TCP)(HOST = racdb2-vip)(PORT = 1521))\r\n  )\r\nRACDB2 =\r\n  (DESCRIPTION =\r\n    (ADDRESS = (PROTOCOL = TCP)(HOST = racdb2-vip)(PORT = 1521))\r\n    (CONNECT_DATA =\r\n      (SERVER = DEDICATED)\r\n      (SERVICE_NAME = racdb)\r\n      (INSTANCE_NAME = racdb2)\r\n    )\r\n  )\r\nRACDB1 =\r\n  (DESCRIPTION =\r\n    (ADDRESS = (PROTOCOL = TCP)(HOST = racdb1-vip)(PORT = 1521))\r\n    (CONNECT_DATA =\r\n      (SERVER = DEDICATED)\r\n      (SERVICE_NAME = racdb)\r\n      (INSTANCE_NAME = racdb1)\r\n    )\r\n  )\r\nRACDB =\r\n  (DESCRIPTION =\r\n    (ADDRESS = (PROTOCOL = TCP)(HOST = racdb1-vip)(PORT = 1521))\r\n    (ADDRESS = (PROTOCOL = TCP)(HOST = racdb2-vip)(PORT = 1521))\r\n    (LOAD_BALANCE = yes)\r\n    (CONNECT_DATA =\r\n      (SERVER = DEDICATED)\r\n      (SERVICE_NAME = racdb)\r\n    )\r\n  )\r\nEXTPROC_CONNECTION_DATA =\r\n  (DESCRIPTION =\r\n    (ADDRESS_LIST =\r\n      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))\r\n    )\r\n    (CONNECT_DATA =\r\n      (SID = PLSExtProc)\r\n      (PRESENTATION = RO)\r\n    )\r\n  )\r\noracle@racdb1 $ tnsping racdb\r\nTNS Ping Utility for Solaris: Version 10.2.0.4.0 - Production on 18-APR-2012 10:24:08\r\nCopyright (c) 1997,  2007, Oracle.  All rights reserved.\r\nUsed parameter files:\r\nUsed TNSNAMES adapter to resolve the alias\r\nAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = racdb1-vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = racdb2-vip)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = racdb)))\r\nOK (0 msec)\r\noracle@racdb1 $ tnsping racdb1\r\nTNS Ping Utility for Solaris: Version 10.2.0.4.0 - Production on 18-APR-2012 10:24:11\r\nCopyright (c) 1997,  2007, Oracle.  All rights reserved.\r\nUsed parameter files:\r\nUsed TNSNAMES adapter to resolve the alias\r\nAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = racdb1-vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = racdb) (INSTANCE_NAME = racdb1)))\r\nOK (10 msec)\r\noracle@racdb1 $ tnsping racdb2\r\nTNS Ping Utility for Solaris: Version 10.2.0.4.0 - Production on 18-APR-2012 10:24:12\r\nCopyright (c) 1997,  2007, Oracle.  All rights reserved.\r\nUsed parameter files:\r\nUsed TNSNAMES adapter to resolve the alias\r\nAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = racdb2-vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = racdb) (INSTANCE_NAME = racdb2)))\r\nOK (0 msec)
\r\n\u6570\u636e\u5e93\u4e2d\u8bbe\u7f6e\u4e86REMOTE_LISTENERS\u53c2\u6570\uff0c\u800c\u4e14TNSNAMES.ORA\u4e2d\u7684REMOTE_LISTENERS\u7684\u914d\u7f6e\u4e5f\u6ca1\u6709\u5f02\u5e38\u3002\u901a\u8fc7tnsping\u547d\u4ee4\u68c0\u67e5\u914d\u7f6e\u540c\u6837\u6ca1\u6709\u53d1\u73b0\u5f02\u5e38\u3002\r\n
oracle@racdb2 $ sqlplus \/nolog\r\nSQL*Plus: Release 10.2.0.4.0 - Production on Wed Apr 18 10:19:18 2012\r\nCopyright (c) 1982, 2007, Oracle.  All Rights Reserved.\r\nSQL> conn a\/a@10.8.60.3\/racdb\r\nERROR:\r\nORA-01017: invalid username\/password; logon denied\r\n\r\nSQL> conn a\/a@10.8.60.1\/racdb\r\nERROR:\r\nORA-01017: invalid username\/password; logon denied\r\n\r\nSQL> conn a\/a@10.8.60.202\/racdb\r\nERROR:\r\nORA-01017: invalid username\/password; logon denied\r\n\r\nSQL> conn a\/a@10.8.60.201\/racdb\r\nERROR:\r\nORA-01017: invalid username\/password; logon denied\r\n\r\nSQL> exit<\/pre>\n
\u8282\u70b92\u4e0a\u901a\u8fc7PUBLIC IP\u548cVIP\u5206\u522b\u8fde\u63a5\u4e24\u4e2a\u5b9e\u4f8b\uff0c\u53d1\u73b0\u670d\u52a1\u540d\u914d\u7f6e\u6ca1\u6709\u95ee\u9898\uff0c\u901a\u8fc7VIP\u4e5f\u53ef\u4ee5\u8bbf\u95ee\u6570\u636e\u5e93\uff0c\u5e76\u6ca1\u6709\u51fa\u73b0VIP\u4e0d\u540c\u7684\u60c5\u51b5\u3002<\/p>\n
oracle@racdb1 $ more \/etc\/hosts\r\n#\r\n# Internet host table\r\n#\r\n::1     localhost       \r\n127.0.0.1       localhost       \r\n10.8.60.1       racdb1  racdb1.com      loghost\r\n10.8.60.201     racdb1-vip\r\n192.168.60.201  racdb1-priv\r\n10.8.60.3       racdb2\r\n10.8.60.202     racdb2-vip\r\n192.168.60.202  racdb2-priv\r\n#BackupServer\r\n10.8.48.26      gz-bak\r\noracle@racdb2 $ more \/etc\/hosts\r\n#\r\n# Internet host table\r\n#\r\n::1     localhost       \r\n127.0.0.1       localhost       \r\n10.8.60.1       racdb1\r\n10.8.60.201     racdb1-vip\r\n192.168.60.201  racdb1-priv\r\n10.8.60.3       racdb2  racdb2.com      loghost\r\n10.8.60.202     racdb2-vip\r\n192.168.60.202  racdb2-priv\r\n#BackupServer\r\n10.8.48.26      gz-bak<\/pre>\n
\u5206\u522b\u5728\u4e24\u4e2a\u8282\u70b9\u4e0a\u68c0\u67e5hosts\u6587\u4ef6\u7684\u914d\u7f6e\uff0c\u7ed3\u679c\u540c\u6837\u6b63\u5e38\u3002<\/p>\n
root@racdb1 # .\/crs_stat -t   \r\nName           Type           Target    State     Host        \r\n------------------------------------------------------------\r\nora....b1.inst application    ONLINE    ONLINE    racdb1      \r\nora....b2.inst application    ONLINE    ONLINE    racdb2      \r\nora.racdb.db   application    ONLINE    ONLINE    racdb2      \r\nora....SM1.asm application    ONLINE    ONLINE    racdb1      \r\nora....B1.lsnr application    ONLINE    ONLINE    racdb1      \r\nora.racdb1.gsd application    ONLINE    ONLINE    racdb1      \r\nora.racdb1.ons application    ONLINE    ONLINE    racdb1      \r\nora.racdb1.vip application    ONLINE    ONLINE    racdb1      \r\nora....SM2.asm application    ONLINE    ONLINE    racdb2      \r\nora....B2.lsnr application    ONLINE    ONLINE    racdb2      \r\nora.racdb2.gsd application    ONLINE    ONLINE    racdb2      \r\nora.racdb2.ons application    ONLINE    ONLINE    racdb2      \r\nora.racdb2.vip application    ONLINE    ONLINE    racdb2<\/pre>\n
RAC\u7684\u76f8\u540c\u670d\u52a1\u90fd\u6b63\u5e38\u542f\u52a8\u3002<\/p>\n
root@racdb1 # .\/oifcfg getif  \r\naggr1  192.168.60.0  global  cluster_interconnect\r\naggr2  10.8.60.0  global  public\r\nroot@racdb2 # .\/oifcfg getif\r\naggr1  192.168.60.0  global  cluster_interconnect\r\naggr2  10.8.60.0  global  public<\/pre>\n
\u4f7f\u7528oifcfg\u68c0\u67e5\u7f51\u5361\u914d\u7f6e\u4e5f\u672a\u53d1\u73b0\u5f02\u5e38\u3002<\/p>\n
root@racdb1 # ifconfig -a\r\nlo0: flags=2001000849 mtu 8232 index 1\r\n        inet 127.0.0.1 netmask ff000000 \r\naggr1: flags=1000843 mtu 1500 index 2\r\n        inet 192.168.60.201 netmask ffffff00 broadcast 192.168.60.255\r\n        ether 0:21:28:1a:89:43 \r\naggr1:1: flags=1040843 mtu 1500 index 2\r\n        inet 10.8.60.201 netmask ffffff00 broadcast 10.8.60.255\r\naggr2: flags=1000843 mtu 1500 index 3\r\n        inet 10.8.60.1 netmask ffffff00 broadcast 10.8.60.255\r\n        ether 0:21:28:1a:89:42\r\nroot@racdb2 # ifconfig -a\r\nlo0: flags=2001000849 mtu 8232 index 1\r\n        inet 127.0.0.1 netmask ff000000 \r\naggr1: flags=1000843 mtu 1500 index 2\r\n        inet 192.168.60.202 netmask ffffff00 broadcast 192.168.60.255\r\n        ether 0:21:28:1a:89:6b \r\naggr2: flags=1000843 mtu 1500 index 3\r\n        inet 10.8.60.3 netmask ffffff00 broadcast 10.8.60.255\r\n        ether 0:21:28:1a:89:6a \r\naggr2:1: flags=1040843 mtu 1500 index 3\r\n        inet 10.8.60.202 netmask ffffff00 broadcast 10.8.60.255<\/pre>\n
\u901a\u8fc7\u68c0\u67e5\u5f53\u524d\u7684IP\u5730\u5740\u4fe1\u606f\uff0c\u7ec8\u4e8e\u53d1\u73b0\u4e86\u95ee\u9898\u6240\u5728\uff0c\u8282\u70b92\u4e0a\u7684VIP\u662f\u6b63\u5e38\u7684\uff0c\u4f46\u662f\u8282\u70b91\u7684VIP\u6f02\u5230\u4e86PRIVATE IP\u5bf9\u5e94\u7684\u7f51\u5361\u4e0a\u3002
\n\u5bf9\u4e8e\u8fd9\u79cd\u60c5\u51b5\uff0c\u5f53\u524dRAC\u7684\u5404\u4e2a\u8282\u70b9\u90fd\u53ef\u4ee5\u6b63\u5e38\u8bbf\u95eeVIP\uff0c\u56e0\u4e3a\u65e0\u8bba\u662fPUBLIC\u7f51\u5361\u8fd8\u662fPRIVATE\u7f51\u5361\uff0c\u4e24\u4e2a\u8282\u70b9\u90fd\u53ef\u4ee5\u8bbf\u95ee\u3002\u4f46\u662f\u5bf9\u4e8e\u6570\u636e\u5e93\u5916\u7684\u5176\u4ed6\u670d\u52a1\u5668\u800c\u8a00\uff0c\u662f\u4e0d\u53ef\u80fd\u8bbf\u95eeRAC\u7684PRIVATE\u7f51\u7edc\u7684\uff0c\u56e0\u6b64\u9020\u6210\u4e86\u8282\u70b92\u7684VIP\u53ef\u4ee5\u8bbf\u95ee\uff0c\u800c\u8282\u70b91\u7684VIP\u4e0d\u53ef\u8bbf\u95ee\u3002
\n\u90a3\u4e48\u4e3a\u4ec0\u4e48Oracle\u7684VIP\u4f1a\u6f02\u5230PRIVATE\u7f51\u5361\u4e0a\u5462\uff1a<\/p>\n
root@racdb1 # exit\r\noracle@racdb1 $ srvctl config nodeapps -n racdb1\r\nracdb1 racdb1 \/u01\/oracle\/product\/10.2\/database\r\noracle@racdb1 $ srvctl config nodeapps -n racdb1 -a\r\nVIP exists.: \/racdb1-vip\/10.8.60.201\/255.255.255.0\/aggr1:aggr2\r\noracle@racdb1 $ srvctl config nodeapps -n racdb2 -a\r\nVIP exists.: \/racdb2-vip\/10.8.60.202\/255.255.255.0\/aggr1:aggr2<\/pre>\n
\u663e\u7136\u662fRAC\u5b89\u88c5\u8fc7\u7a0b\u4e2d\u914d\u7f6e\u9519\u8bef\u5bfc\u81f4\u7684\uff0c\u5728\u8bbe\u7f6eVIP\u4f7f\u7528\u7684\u7f51\u5361\u4fe1\u606f\u65f6\uff0c\u5e94\u8be5\u9009\u62e9PUBLIC\u7f51\u7edc\uff0c\u800c\u5f53\u524d\u5c06\u4e24\u4e2a\u7f51\u5361\u90fd\u9009\u62e9\u4e0a\u4e86\u3002\u8fd9\u6b63\u597d\u8bf4\u660e\u4e86\u4e3a\u4ec0\u4e48\u6709\u65f6VIP\u662f\u4e0d\u80fd\u8bbf\u95ee\u7684\uff0c\u800c\u91cd\u542fRAC\u8282\u70b9\u540e\uff0c\u4e00\u4e2a\u8282\u70b9\u7684VIP\u5c31\u53ef\u4ee5\u8bbf\u95ee\u4e86\u3002
\n\u5982\u679cVIP\u542f\u52a8\u7684\u65f6\u5019\u9009\u62e9\u4e86PUBLIC\u7f51\u5361\uff0c\u90a3\u4e48VIP\u5730\u5740\u5bf9\u5916\u5c31\u662f\u53ef\u89c1\u7684\uff0c\u800c\u5982\u679cVIP\u9009\u62e9\u4e86PRIVATE\u7f51\u5361\uff0c\u90a3\u4e48VIP\u5730\u5740\u5bf9\u5916\u5c31\u4e0d\u53ef\u89c1\u4e86\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5ba2\u6237\u7684\u6570\u636e\u5e93\u51fa\u73b0VIP\u5730\u5740\u65e0\u6cd5\u8bbf\u95ee\u7684\u60c5\u51b5\u3002 \u8fd9\u4e00\u7bc7\u63cf\u8ff0\u95ee\u9898\u7684\u8bca\u65ad\u3002 \u5ba2\u6237\u7684RAC\u73af\u5883\u91cd\u5efa\u540e\uff0c\u53d1\u73b0\u4e24\u4e2a\u8282\u70b9\u7684VIP\u90fd\u65e0\u6cd5\u8bbf\u95ee\uff0c\u5f00\u59cb\u8ba4\u4e3a\u662f\u7f51\u7edc\u95ee\u9898\uff0c\u4f46\u662f\u968f\u540e\u53d1\u73b0\u6574\u4e2aRAC\u91cd\u542f\u540e\uff0c\u5176\u4e2d\u4e00\u4e2a\u8282\u70b9\u7684VIP\u53ef\u4ee5\u8bbf\u95ee\uff0c\u800c\u53e6\u4e00\u4e2a\u8282\u70b9\u7684VIP\u4ecd\u7136\u65e0\u6cd5\u8bbf\u95ee\uff0c\u56e0\u6b64\u5224\u65ad\u53ef\u80fd\u662fRAC\u672c\u8eab\u7684\u95ee\u9898\u3002 \u542c\u5230\u95ee\u9898\u63cf\u8ff0\u540e\uff0c\u7b2c\u4e00\u4e2a\u5224\u65ad\u662f\u5426VIP\u6ca1\u6709\u542f\u52a8\uff0c\u767b\u5f55\u6570\u636e\u5e93\u670d\u52a1\u5668\u540e\u8fdb\u884c\u4e86\u68c0\u67e5\uff1a oracle@racdb1 $ lsnrctl status LSNRCTL for Solaris: Version 10.2.0.4.0 – Production on 18-APR-2012 10:22:02 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ———————— Alias LISTENER_RACDB1 Version TNSLSNR for Solaris: … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[657,660,658,659,180,376,301],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-cS","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/798"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=798"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/798\/revisions"}],"predecessor-version":[{"id":800,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/798\/revisions\/800"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=798"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=798"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}