oracle parameter CLUSTER_INTERCONNECTS

本文详细介绍了Oracle Real Application Clusters (RAC) 中的CLUSTER_INTERCONNECTS参数配置方法及注意事项,包括如何通过该参数实现负载均衡和故障转移,特别强调了在数据仓库系统中的应用。

CLUSTER_INTERCONNECTS

PropertyDescription
Parameter typeString
SyntaxCLUSTER_INTERCONNECTS = ifn [: ifn ] ...
Default valueThere is no default value.
ModifiableNo
Range of valuesOne or more IP addresses, separated by colons
BasicNo

CLUSTER_INTERCONNECTS provides Oracle with information about additional cluster interconnects available for use in Real Application Clusters environments.

The CLUSTER_INTERCONNECTS parameter can be used to override the default interconnect with a preferred cluster traffic network. This parameter is useful in Data Warehouse systems that have reduced availability requirements and high interconnect bandwidth demands. You can also use CLUSTER_INTERCONNECTS to override the default interconnect chosen by Oracle.

For example, if you are running two instances of Oracle for two databases on the same machine, then you can load balance the interconnect traffic to different physical interconnects. This does not reduce Oracle availability.

CLUSTER_INTERCONNECTS can be used in Oracle Real Application Clusters environments to indicate cluster interconnects available for use for the database traffic. Use this parameter if you need to override the default interconnect configured for the database traffic, which is stored in the cluster registry. This procedure also may be useful with Data Warehouse systems that have reduced availability requirements and high interconnect bandwidth demands.

CLUSTER_INTERCONNECTS specifically overrides the following:

  • Network classifications stored by oifcfg in the OCR.

  • The default interconnect chosen by Oracle.

If you want to load-balance the interconnect, then Oracle recommends that you use link-bonding at the operating system level, even if you have two databases on the same server, so that multiple interconnects use the same address. Note that multiple private addresses provide load balancing, but do not provide failover unless bonded. If you specify multiple addresses in init.ora using CLUSTER_INTERCONNECTS, instead of bonding multiple addresses at the operating system level, then typically availability is reduced, because each network interface card failure will take down that instance.

Refer to your vendor documentation for information about bonding interfaces. Some vendor bonding architectures may require the use of this parameter.

If you have multiple database instances on Oracle Real Application Clusters nodes and want to use a specific interface for each instance, then you can set the CLUSTER_INTERCONNECTS initialization parameter to the IP address for each database instance. For example:

hr1.init.ora.cluster_interconnects="192.0.2.111"
oltp3.init.ora.cluster_interconnects="192.0.2.112"

If the Oracle RAC interconnect is configured to run on a different interface than the Oracle Clusterware interconnect, then this configuration can cause reduced availability, as failovers or instance evictions can be delayed if the Oracle RAC interconnect fails while the Oracle Clusterware NIC remains up.

See Also:

Oracle Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide for additional platform-specific information about using CLUSTER_INTERCONNECTS
 
 
from:http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams025.htm#sthref81
 
---------------------------------------------------------------------------------------------
 
 private network multiple:
Cluster_Interconnects
使用IP,不用设备名
多个IP之间用冒号分隔
这个参数只在Unix中使用,UDP        IPC启用。
GCS、GES使用IPC通讯。
内部通讯使用IPC。
Cluster_Interconnects的修改将会覆盖OCR中的cluster的配置信息,降低rac的可用性。
导致rac节点被踢出延迟。
OCR中的inter connect信息是由oifcfg工具写入的。
cluster_interconnects:
1.可以分别给同一台服务器上的多个数据库指定对外服务的IP地址,将load分布到各个IP地址对应的NIC设备上。
2.两个节点上的设备IP参数列表必须顺序相同。
3.这个参数指定的值无效的情况下将会使用系统默认设备。
### 关于可靠性感知的应用映射和波长分配联合设计方法 在基于波分复用(WDM)的硅光子片上互连中,可靠性感知的设计方法是一个重要的研究方向。这种方法旨在优化应用映射和波长分配策略,以提高系统的可靠性和性能。以下是对此主题的一些深入探讨。 #### 方法概述 一种典型的可靠性感知联合设计方法涉及以下几个方面: - **应用映射**:此过程定义了如何将不同的计算任务或数据流分配到芯片的不同区域。这种映射需要考虑硬件资源的可用性以及通信需求。 - **波长分配**:由于WDM技术允许多个信号共享同一物理链路,因此合理分配波长可以减少干扰并提升传输效率[^1]。 这两种操作通常被集成在一个框架内进行协同优化,目的是最小化延迟、功耗或其他成本函数的同时最大化系统可靠性。 #### 技术挑战与解决方案 实施此类设计方案面临的主要挑战包括但不限于: - 如何量化组件级失效对于整体网络性能的影响; - 设计能够适应动态变化环境条件下的自愈机制; - 平衡短期效益与长期稳健性的关系。 针对这些问题,研究人员提出了多种解决办法,比如采用机器学习算法来预测潜在故障点,并据此调整路径规划逻辑;或者利用遗传算法寻找全局最优解等高级启发式搜索技术[^2]。 ```python def reliability_aware_mapping(tasks, resources): """ A simplified function demonstrating application mapping based on resource availability. Args: tasks (list): List of computational tasks requiring allocation. resources (dict): Dictionary containing available hardware resources. Returns: dict: Mapping results indicating which task goes where. """ mappings = {} for task in tasks: best_resource = max(resources.items(), key=lambda item:item[1]) # Find most suitable resource mappings[task] = best_resource[0] resources[best_resource[0]] -= 1 # Update remaining capacity return mappings def wavelength_assignment(links, wavelengths_per_link=4): """ Basic approach to assigning wavelengths across links avoiding conflicts. Args: links (set[tuple]): Set representing all possible communication pairs between nodes. Yields: tuple(int,int): Pair consisting link identifier along with assigned wavelength index. """ assignments = {} current_wl = {link:0 for link in links} while any(current_wl.values()): yield from ((lnk,current_wl.get(lnk))for lnk,val in current_wl.items()if val<=wavelengths_per_link) _update_conflicts(assignments,(links,)) ``` 以上代码片段展示了简化版的任务映射及波长指派逻辑,实际工业应用场景下还需要更多复杂的考量因素加入其中。 #### 结论 综上所述,在WDM为基础架构之上执行可靠性导向型联合作业是一项复杂但极具前景的工作领域。它不仅有助于改善当前技术水平局限之处,也为未来更高效能计算机体系结构奠定了坚实基础[^3]。
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值