Cluster Interconnect in Oracle RAC

Cluster Interconnect in Oracle RAC (文檔 ID 787420.1)?編輯轉到底部

In this Document

Purpose
Scope
Details
Physical Layout of the Private Interconnect
Why Do We Need a Private Interconnect ?
Interconnect Failure
Interconnect High Availability
Private Interconnect for Oracle Clusterware
Private Interconnect for RAC
Identification of the Private Interconnect for RAC
Private Interconnect for ASM
Different Interconnects for Clusterware and RAC
CLUSTER_INTERCONNECTS Parameter
Changing the Private Interconnect
References

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7
Last Updated: 20-Feb-2012
?

Purpose

The purpose of this note is to make DBAs and System Administrators familiar with the concept of the cluster or private interconnect and its usage in Oracle Clusterware and Oracle Real Application Clusters

Scope

The main audience is DBAs and System Administrators. This note applies to Oracle Clusterware and Oracle Real Application Clusters releases 10.1, 10.2 and 11.1.

Details

The term?'Private Interconnect' or?'Cluster Interconnect' is the private communication link between cluster nodes.
?For Oracle Real Application Clusters and Oracle Clusterware we can differentiate between
1. Physical interface (including NIC, cables and switches)
2. Private Interconnect used by Oracle Clusterware
3. Private Interconnect used by Oracle Real Application Clusters (RAC)

Physical Layout of the Private Interconnect

The basic requirements are described in the Installation Guide for each platform. Additional information about certification can be found on Metalink Certify.
The interconnect as identified by both subnet number and interface name must be configured on all clustered nodes.
A switch between the clustered nodes is an absolute requirement.

Why Do We Need a Private Interconnect ?

Clusterware uses the interconnect for cluster synchronization (network heartbeat) and daemon communication between the the clustered nodes. This communication is based on the TCP protocol.
RAC uses the interconnect for cache fusion (UDP) and inter-process communication (TCP). Cache Fusion is the remote memory mapping of Oracle buffers, shared between the caches of participating nodes in the cluster. The volume and traffic patterns of this type of data, shared between nodes can vary greatly depending on the applications.
There are some vendor specific protocol exceptions in Oracle 10g.

Interconnect Failure

The private interconnect is the critical communication link between nodes and instances. Network errors will negatively impact Oracle Clusterware communication as well as RAC communication and performance.
Private interconnect failures are recognized by Oracle Clusterware and result in what is known as a 'split-brain' or subdivided cluster.
A subdivided cluster can result in data corruption, consequently immediate action is taken to resolve this condition. Interconnect failures, therefore, result in a node or subset of nodes in the cluster shutting down. In the case of two equally sized sub clusters, it is basically random which sub cluster will survive, and a customer's architecture and design should be based on this. At this time the Oracle Clusterware happens to use the node numbers to resolve this, but this could change in the future.

RAC instances will wait for the end of cluster reconfiguration to start their own reconfiguration.

Interconnect High Availability

It is an Oracle Best Practice to make the private interconnect highly available. Depending on the operating system and vendor you can use OS network drivers such as bonding, teaming, IPMP, Etherchannel, APA, MultiPrivNIC. For that purpose the interconnect should be configured across two NICs as well as two switches for complete redundancy so that the cluster can survive a single point of failure.

The setup of the highly available interconnect is transparent to Oracle Clusterware and RAC. This means that an underlying failure is handled by the OS or networking drivers that manage the interfaces. Oracle software does not recognize the change underneath, because the failover is handled by the operating system transparently to Oracle.

Private Interconnect for Oracle Clusterware

The private node name determines the interface being used for Oracle Clusterware and is defined during installation of the Clusterware.
With 3rd party Vendor Clusterware in place Oracle Clusterware should be configured to use the same interconnect (often referred to as the heartbeat) as the underlying vendor cluster software.

There exist three ways to identify the private node name after installation:

  • olsnodes -n -p can be used to identify the private node name.

    [oracle@racnode1 ~]$ olsnodes -n -p
    racnode1 1 racnode1-priv
    racnode2 2 racnode2-priv
    [oracle@racnode1 ~]$

  • You may also check the private node name in the ocrdump output.

    [SYSTEM.css.node_numbers.node1.privatename]
    ORATEXT : racnode1-priv

  • ocssd.log has a line with clssnmClusterListener

    [ CSSD]2009-02-23 03:09:06.945 [3086] >TRACE: clssnmClusterListener: Listening on (ADDRESS=(PROTOCOL=tcp)(HOST=racnode1-priv)(PORT=49895))

Although the Oracle Universal Installer allows IP addresses when prompted for the private node name you should always use the host names defined in the hosts file or DNS. This enables you to change the IP addresses when you need to move the server to a different IP range.? You would have to reinstall Oracle Clusterware when you used IP-addresses instead of host names and you are changing the server's IP adresses.

Private Interconnect for RAC

The database uses the private interconnect for communication and cache fusion. The private interconnect is also referred to as "The Cluster Interconnect". Oracle highly recommends that the database and Oracle Clusterware share the same interconnect.
The instances get the private interconnect definition from

  • spfile or init.ora when the parameter CLUSTER_INTERCONNECTS was set
  • Oracle Cluster Regsitry (OCR) defined during the installation (default)
  • automatically from platform defaults if not defined in the spfile/init.ora and OCR.

A value in the spfile or init.ora overrides a definition in the OCR.

Identification of the Private Interconnect for RAC

The value of the private interconnect for an instance can be identified using

  1. The views V$CLUSTER_INTERCONNECTS and V$CONFIGURED_INTERCONNECTS

    V$CLUSTER_INTERCONNECTS displays one or more interconnects that are being used for cluster communication.

    V$CONFIGURED_INTERCONNECTS displays all the interconnects that Oracle is aware of. This view aims to answer the question on where Oracle found the information about a specific interconnect.

    These views are not available in Oracle 10g 10.1.
  2. The alert.log
    • CLUSTER_INTERCONNECTS parameter is set
    • Value read from Cluster Registry

      Interface type 1 Database Team 10.x.x.0 configured from OCR for use as a cluster interconnect

    • Interconnect finally used

      Cluster communication is configured to use the following interface(s) for this instance
      10.x.x.1


      Note that there might be a difference to the interconnect defined in the OCR because the value was overridden by setting the CLUSTER_INTERCONNECTS parameter or when Oracle selected another interconnect because the one in the OCR was not available.
    • Protocol
      Unix and Linux

      cluster interconnect IPC version:Oracle UDP/IP (generic)


      Windows:

      cluster?interconnect?IPC?version:Oracle?9i?Winsock2?TCP/IP?IPC

Private Interconnect for ASM

Oracle ASM?must?use the same interconnect as Oracle Clusterware.

Different Interconnects for Clusterware and RAC

Oracle Clusterware does not monitor interfaces other than the one specified via the private host name during installation. If RAC instances run with an interconnect that is different from the Oracle Clusterware interconnect any failure will remain undetected by Oracle Clusterware. The instances will detect this failure themselves and clear the situation by a mechanism called Instance Membership Recovery (IMR). Instance evictions due to IMR happen after 10 minutes.
This configuration should be avoided.

CLUSTER_INTERCONNECTS Parameter

This parameter overrides the value configured in the OCR. You may specify multiple IP addresses in CLUSTER_INTERCONNECTS which will cause all defined interfaces to be used. Keep in mind that a failure of one of those interfaces will cause the instance to fail. The failed instance can only be restarted when all the interfaces are fixed or you start all the instances without the faulty interface.

?

Changing the Private Interconnect

  • Clusterware
    • Change of the IP Address: change the IP address in the hosts file and/or DNS and make sure that ASM and the database also use the same interconnect
    • Change of the private node name used by Oracle Clusterware: requires a reinstall of Oracle Clusterware
  • Real Application Clusters
    • OCR: Use?Note 283684.1?How to Change Interconnect/Public Interface IP or Subnet in Oracle Clusterware
    • CLUSTER_INTERCONNECTS: shutdown all instances, change the IP address and restart the instances

Database - RAC/Scalability Community
To discuss this topic further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the My Oracle Support?Database - RAC/Scalability Community

References


NOTE:283684.1?- How to Modify Private Network Information in Oracle Clusterware
NOTE:341788.1?- Recommendation for the Real Application Cluster Interconnect and Jumbo Frames

本文來自互聯網用戶投稿,該文觀點僅代表作者本人,不代表本站立場。本站僅提供信息存儲空間服務,不擁有所有權,不承擔相關法律責任。
如若轉載,請注明出處:http://www.pswp.cn/diannao/82505.shtml
繁體地址,請注明出處:http://hk.pswp.cn/diannao/82505.shtml
英文地址,請注明出處:http://en.pswp.cn/diannao/82505.shtml

如若內容造成侵權/違法違規/事實不符,請聯系多彩編程網進行投訴反饋email:809451989@qq.com,一經查實,立即刪除!

相關文章

.Net HttpClient 使用準則

HttpClient 使用準則 System.Net.Http.HttpClient 類用于發送 HTTP 請求以及從 URI 所標識的資源接收 HTTP 響應。 HttpClient 實例是應用于該實例執行的所有請求的設置集合,每個實例使用自身的連接池,該池將其請求與其他請求隔離開來。 從 .NET Core …

【PostgreSQL】數據庫主從庫備份與高可用部署

文章目錄 一、架構設計原理二、部署清單示例2.1 StatefulSet配置片段2.2 Service配置三、配置詳解3.1 主節點postgresql.conf3.2 從節點配置四、初始化流程4.1 創建復制用戶4.2 配置pg_hba.conf五、故障轉移示例5.1 自動切換腳本5.2 手動提升從節點六、監控與維護6.1 關鍵監控指…

JavaScript 數組去重:11 種方法對比與實戰指南

文章目錄 前言一、使用 Set 數據結構二、使用 filter indexOf三、使用 reduce 累加器四、雙重 for 循環五、利用對象屬性唯一性六、先排序后去重七、使用 Map 數據結構八、使用 includes 方法九、優化處理 NaN 的 filter 方法十、利用 findIndex十一.利用Set和展開運算符處理多…

ai agent(智能體)開發 python3基礎14:在python 中 總能看到方法里面套方法,那什么時候用這種方式合適呢?

讓人頭疼的方法嵌套還是要去了解的 在 Python 中,方法內部嵌套方法(即在類的方法中定義另一個函數)是一種常見的代碼組織技巧,它可以在特定場景下帶來以下好處: 1. 代碼復用與邏輯封裝 如果某個方法內部有重復的邏輯…

Yocto項目實戰經驗總結:從入門到高級的全面概覽

本文面向開發者和實際項目經驗者,分享經過大量實戰積累的 Yocto 項目工程經驗和基礎技巧。本文簡明但精彩,應用和觀察相結合,充分適合做為全面進階 Yocto 項目開發的實用指南。 一、入門理解:Yocto 是什么?規劃如何開始…

添加物體.

在cesium中我們可以添加物體進入地圖.我們以廣州塔為例 //生成廣州塔的位置var position2 Cesium.Cartesian3.fromDegrees(113.3191,23.109,100)viewer.camera.setView({//指定相機位置destination: position2, 運行后如圖 我們使用cesium官網提供的代碼為廣州塔在地圖上標點…

正則表達式非捕獲分組?:

一個使用 Java 正則表達式的具體例子,展示了 (ab) 和 (?:ab) 的不同: 示例 1:使用 (ab)(捕獲分組) import java.util.regex.*; public class RegexExample { public static void main(String[] args) { …

ragflow報錯:KeyError: ‘\n “序號“‘

環境: ragflowv 0.17.2 問題描述: ragflow報錯:KeyError: ‘\n “序號”’ **1. 推薦表(輸出json格式)** [{"},{},{"},{} ]raceback (most recent call last): May 08 20:06:09 VM-0-2-ubuntu ragflow-s…

Spring Boot-8啟動涉及的監聽器(擴展點)

從出現時間上看: org.springframework.context.ApplicationListener,Spring 1.0開始出現 org.springframework.context.ApplicationContextInitializer,Spring 3.1開始出現 org.springframework.boot.SpringApplicationRunListener&#x…

如何啟動vue項目及vue語法組件化不同標簽應對的作用說明

如何啟動vue項目及vue語法組件化不同標簽應對的作用說明 提示:幫幫志會陸續更新非常多的IT技術知識,希望分享的內容對您有用。本章分享的是node.js和vue的使用。前后每一小節的內容是存在的有:學習and理解的關聯性。【幫幫志系列文章】&…

思考:(linux) tmux 超級終端快速入門的宏觀思維

tmux 工具集合 GitHub - rothgar/awesome-tmux: A list of awesome resources for tmux 要點: 習慣性思維的變換與宿主機之間的雙向復制、粘貼手動備份全部窗口,以及還原自定義窗格提示信息TPM 插件的安裝思想別名 在有些場景里,可能無法…

Python實例題:Python協程詳解公開課

目錄 Python實例題 題目 課程目標 課程內容規劃 1. 課程開場(5 分鐘) 2. 基礎概念講解(15 分鐘) 并發與并行: 線程與進程: 3. Python 協程的實現方式(20 分鐘) 生成器實現…

AI時代的數據可視化:未來已來

你有沒有想過,數據可視化在未來會變成什么樣?隨著人工智能(AI)的飛速發展,數據可視化已經不再是簡單的圖表和圖形,而是一個充滿無限可能的智能領域。AI時代的可視化不僅能自動解讀數據,還能預測…

強化學習PPO算法學習記錄

1. 四個模型: Policy Model:我們想要訓練的目標語言模型。我們一般用SFT階段產出的SFT模型來對它做初始化。Reference Model:一般也用SFT階段得到的SFT模型做初始化,在訓練過程中,它的參數是凍結的。Ref模型的主要作用…

邊緣計算從專家到小白

“云-邊-端”架構 “云” :傳統云計算的中心節點,是邊緣計算的管控端。匯集所有邊緣的感知數據、業務數據以及互聯網數據,完成對行業以及跨行業的態勢感知和分析。 “邊” :云計算的邊緣側,分為基礎設施邊緣和設備邊緣…

Windows:Powershell的使用

文章目錄 零、格式化輸出命令1、Format-List(別名:fl) 一、服務管理SC命令二、軟件管理命令三、權限管理命令1、Get-Acl2、Set-Acl 總結 零、格式化輸出命令 1、Format-List(別名:fl) 可通過管道符傳遞對象…

實現在h5中添加日歷提醒:safari喚起系統日歷,其它瀏覽器跳轉google日歷

需求:點擊按鈕后,將設定的一些信息插入到系統日歷的日程安排中。 調研過程 先google了一段時間,了解該需求大概的實現方式。可以創建日歷文件,在點擊的時候下載該日歷文件,看起來還比較復雜,并且由于不具…

【Bluedroid】藍牙 HID 設備服務注冊流程源碼解析:從初始化到 SDP 記錄構建

本文圍繞藍牙 HID(人機接口設備)服務注冊流程,詳細解析從 HID 服務啟用、設備初始化、L2CAP 通道注冊到 SDP(服務發現協議)記錄構建的全流程。通過分析關鍵函數如btif_hd_service_registration、BTA_HdEnable、HID_Dev…

Win10無法上網:Windows 無法訪問指定設備、路徑或文件。你可能沒有適當的權限訪問該項目找不到域 TEST 的域控制器DNS 解析存在問題

目錄 一.先看問題 二.解決問題 三.補充備用 一.先看問題 Win08有網且已經加入域 Win10無網并且找不到域(說明:Win10我之前已經加入過域的,并且能夠上網,但每次在宿舍和教室切換校園網,就會導致只有Win10無網&#…

M0基礎篇之ADC

本節課使用到的例程 一、Single模式例程基本配置的解釋 在例程中我們只使用到了PA25這一個通道,因此我們使用的是Single這個模式,也就是我們在配置模式的時候使用的是單一轉換。 進行多個通道的測量我們可以使用Sequence這個模式。 二、Single模式例程基…