oracle 之 CLUSTER_INTERCONNECTS is not set to the recommended value

張衝andy發表於2018-03-16

問題: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='' 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


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31383567/viewspace-2151920/,如需轉載,請註明出處,否則將追究法律責任。

相關文章