oracle 之 CLUSTER_INTERCONNECTS is not set to the recommended value

问题:Database parameter CLUSTER_INTERCONNECTS is not set to the recommended value

在Oracle实际应用程序集群环境中可以使用cluster_interconnect,以指示可用于数据库通信的集群互连。如果需要覆盖为数据库流量配置的默认互连(存储在群集注册表中),请使用此参数。这个过程也可能对数据仓库系统有用,因为数据仓库系统降低了可用性需求和高互连带宽需求。

cluster_interconnect具体覆盖了以下内容:
由oifcfg在OCR中存储的网络分类。
由Oracle选择的默认互连。

适用版本:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Oracle Exadata Storage Server Software - Version 12.1.1.1.0 and later
Oracle SuperCluster Specific Software - Version 1.x and later
Information in this document applies to any platform.

Solition:

$ $ORACLE_HOME/bin/oifcfg getif
bondeth0 10.152.224.0 global public
ib0 192.168.8.1 global cluster_interconnect,asm
ib1 192.168.8.2 global cluster_interconnect,asm

$ ifconfig ib0
ib0 Link encap:InfiniBand HWaddr 80:00:00:48:FE:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00
inet addr:192.168.9.203 Bcast:192.168.11.255 Mask:255.255.252.0
inet6 addr: fe80::210:e000:133:296d/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:7000 Metric:1
RX packets:34872644 errors:0 dropped:0 overruns:0 frame:0
TX packets:33220479 errors:0 dropped:2 overruns:0 carrier:0
collisions:0 txqueuelen:4096
RX bytes:12937195873 (12.0 GiB) TX bytes:11896620848 (11.0 GiB)

$ ifconfig ib1
ib1 Link encap:InfiniBand HWaddr 80:00:00:49:FE:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00
inet addr:192.168.9.204 Bcast:192.168.11.255 Mask:255.255.252.0
inet6 addr: fe80::210:e000:133:296e/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:7000 Metric:1
RX packets:17880631 errors:0 dropped:0 overruns:0 frame:0
TX packets:29918338 errors:0 dropped:9 overruns:0 carrier:0
collisions:0 txqueuelen:4096
RX bytes:5098988721 (4.7 GiB) TX bytes:100635031058 (93.7 GiB)

$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Jan 25 13:09:39 2018

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> alter system set CLUSTER_INTERCONNECTS='192.168.9.203:192.168.9.204' sid='<instanceName>' scope=spfile;

System altered.

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

上一篇:[转载] C++ STL string的Copy-On-Write技术


下一篇:ASP.NET Core的身份认证框架IdentityServer4--(1)服务配置