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='' 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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORACLE APP培訓筆記(3) -- Value SetOracleAPP筆記
- Oracle Recommended Patches -- Oracle Database [ID 756671.1]OracleDatabase
- Oracle CLUSTER_INTERCONNECTS引數詳解Oracle
- mysql遇到Variable can’t be set to the value of ‘NULL’MySqlNull
- mysql:Variable 'character_set_client' can't be set to the value of 'NULL'解決MySqlclientNull
- Recommended Browsers for Oracle Applications 11iOracleAPP
- Variable 'character_set_client' can't be set to the value of Null的解決方法clientNull
- [mysql] 批量匯入提示: Variable ‘character_set_client’ can’t be set to the value of ‘NULLMySqlclientNull
- PSU下載 - Oracle Recommended Patches -- Oracle Database (文件 ID 756671.1)OracleDatabase
- rhel5_oracle10g_10.2.0.4_字符集character set_nls_valid_valueOracle
- value xxx for the flexfield segment customer:does not exist in the value set xxxxFlex
- oracle set eventsOracle
- oracle set roleOracle
- Redis之setRedis
- AndroidStudio之自定義輸出包名報錯 Cannot set the value of read-only property 'outputFile' forAndroid
- oracle全文索引之STOPLIST_ CTXCAT 索引_INDEX SETOracle索引Index
- Oracle分析函式-first_value()和last_value()Oracle函式AST
- Mysql:Variable 'XXXt' can't be set to the value of 'NULL'解決MySqlNull
- 解決問題:Variable 'time_zone' can't be set to the value of 'NULL'Null
- 452 Error writing file: A file cannot be larger than the value set by ulimit.ErrorMIT
- Oracle裡的setOracle
- 六、redis之setRedis
- [Err] 1231 - Variable 'sql_mode' can't be set to the value of 'NULLSQLNull
- Oracle set unused的用法Oracle
- Oracle SET 命令總結Oracle
- oracle set 使用命令Oracle
- 為oracle listener set passwordOracle
- Oracle 11.2.0.2.0 patch setOracle
- metalink上oracle資料庫推薦補丁列表的document id(Oracle Recommended Patches -- Oracle Database)Oracle資料庫Database
- mysql匯入報錯Variable 'sql_notes' can't be set to the value of 'NULL'MySqlNull
- 12-Overview-Recommended LabelsView
- WPF System.Windows.Media.Color A value must be set, display ball and number in canvas ,mouse down to refreshWindowsCanvas
- Oracle跟蹤事件 -- set eventsOracle事件
- Oracle 跟蹤事件 set eventOracle事件
- Oracle set unused的用法.sqlOracleSQL
- java容器之Set常用方法Java
- sqlplus之prompt_&&_&_new_valueSQL
- oracle 格式化user_tab_col_ststistics(low_value,high_value)Oracle