Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
RAC single client access name
Search
oracle4engineer
PRO
February 09, 2021
Technology
2
570
RAC single client access name
RACは複数ノードで構成されるクラスタ・データベースであるのに、なぜシングル・インスタンス構成と同じ接続記述子で接続可能であるかの説明です。
oracle4engineer
PRO
February 09, 2021
Tweet
Share
More Decks by oracle4engineer
See All by oracle4engineer
【詳説】Oracle Data Guard Broker
oracle4engineer
PRO
0
4
Oracle Data Guard Brokerの管理と障害対応
oracle4engineer
PRO
0
2
Oracle Database で機械学習を始めよう! Oracle Machine Learning
oracle4engineer
PRO
1
140
OCI Data Integration技術情報 / ocidi_technical_jp
oracle4engineer
PRO
1
1.5k
ExaDB-D dbaascli で出来ること
oracle4engineer
PRO
0
1.8k
Oracle APEXの画面をファンシーにしよう!
oracle4engineer
PRO
2
170
Exadata Database Service on Dedicated Infrastructure(ExaDB-D) UI スクリーン・キャプチャ集
oracle4engineer
PRO
0
1.2k
Oracle Databaseのアップグレードと移行
oracle4engineer
PRO
0
79
OCI Oracle Database Services新機能アップデート(FY24Q3)
oracle4engineer
PRO
0
120
Other Decks in Technology
See All in Technology
エンジニアブランディングチームの KPI / KPI's of engineer branding team
chaspy
1
140
依存ライブラリはどこに?
takesection
0
110
オブジェクト指向宗教史
tanakahisateru
13
12k
匠MethodとRDRAとICONIXとDDDで実現する一気通貫オブジェクト指向開発
haru860
4
2k
AMLD 2024 - Build Your Own GPT
donlelef
1
260
.NETの非同期戦略とUnityとの相互運用
neuecc
2
2.4k
継続的テストモデルを実現するためにスリーアミーゴスを用いた10Xでのシフトレフトの事例
nihonbuson
3
160
8週連続ウェビナー_イチから学ぶFivetran
cmsuzu
0
160
Autify Company Deck
autifyhq
1
30k
OpenTelemetry実践 はじめの一歩
taxin
0
310
サービスメッシュ環境における OpenTelemetry 活用 / OpenTelemetry in Service Mesh
k6s4i53rx
2
830
データマネジメントを支える武器としてのメタデータ管理
10xinc
1
360
Featured
See All Featured
Pencils Down: Stop Designing & Start Developing
hursman
115
11k
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
185
15k
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
14
1.3k
10 Git Anti Patterns You Should be Aware of
lemiorhan
644
57k
Robots, Beer and Maslow
schacon
PRO
154
7.9k
The World Runs on Bad Software
bkeepers
PRO
60
6.6k
4 Signs Your Business is Dying
shpigford
174
21k
Intergalactic Javascript Robots from Outer Space
tanoku
266
26k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
153
14k
Practical Orchestrator
shlominoach
180
9.7k
How to name files
jennybc
62
92k
Designing on Purpose - Digital PM Summit 2013
jponch
109
6.4k
Transcript
Oracle Real Application Clusters 2020 6 17
Safe harbor statement Oracle Java Oracle Corporation Copyright © 2020,
Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted 2
Oracle Real Application Clusters (RAC) Oracle Grid Infrastructure Oracle Database
RAC Oracle Database Oracle Grid Infrastructure 2 Oracle Database Oracle Oracle Grid Infrastructure Oracle Grid Infrastructure • Oracle Clusterware • Oracle Automatic Storage Management • • Single Client Access Name • IP 3 Copyright © 2020, Oracle and/or its affiliates ASM ASM Clusterware Clusterware tnslsnr tnslsnr SCAN tnslsnr
Oracle Grid Infrastructure SCAN Oracle Grid Infrastructure 2 Oracle (
) • Oracle • IP ( VIP) Single Client Access Name(SCAN) • Oracle • SCAN IP (SCAN VIP) ( 3 ) • Oracle SCAN 4 Copyright © 2020, Oracle and/or its affiliates tnslsnr SCAN tnslsnr SCAN VIP n tnslsnr VIP Oracle Oracle 1 2
Oracle ( ) • Oracle • IP ( VIP) Oracle
VIP Oracle LOAD_BALANCE=ON FAILOVER=ON ( ON ) 5 Copyright © 2020, Oracle and/or its affiliates (DESCRIPTION = (LOAD_BALANCE=ON) (FAILOVER=ON) (ADDRESS = (PROTOCOL = TCP) (HOST = VIP1)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP) (HOST = VIP2)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = service_name) ) ) tnslsnr Oracle Oracle tnslsnr VIP 1 VIP 2 1 2
VIP VIP Oracle 6 Copyright © 2020, Oracle and/or its
affiliates tnslsnr Oracle Oracle tnslsnr VIP 1 VIP 2 1 2 tnslsnr Oracle VIP 1 VIP 2 1 2 1 OS ⇒ VIP 1 1 ⇒ VIP 1 VIP 1 VIP 1 TCP RST
Single Client Access Name (SCAN) SCAN SCAN VIP Oracle SCAN
SCAN Oracle Oracle SCAN SCAN 7 Copyright © 2020, Oracle and/or its affiliates tnslsnr Oracle Oracle tnslsnr VIP 1 VIP 2 1 2 tnslsnr SCAN VIP service1 service1
2 LOAD_BALANCE=ON (1) SCAN Oracle SCAN (2) Oracle 8 Copyright
© 2020, Oracle and/or its affiliates tnslsnr Oracle Oracle tnslsnr VIP 1 VIP 2 1 2 service1 service1 (DESCRIPTION = (LOAD_BALANCE=ON) (FAILOVER=ON) (ADDRESS = (PROTOCOL = TCP) (HOST = nodevip1) (PORT = 1521)) (ADDRESS = (PROTOCOL = TCP) (HOST = nodevip2) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = service1) ) ) tnslsnr SCAN VIP
Single Client Access Name (SCAN) Oracle SCAN 9 Copyright ©
2020, Oracle and/or its affiliates tnslsnr Oracle instance1 Oracle instance2 tnslsnr VIP 1 VIP 2 1 2 tnslsnr SCAN VIP service1 service1 tnslsnr service1 instance1 instance2
Single Client Access Name (SCAN) SCAN 10 Copyright © 2020,
Oracle and/or its affiliates tnslsnr Oracle instance1 Oracle instance2 tnslsnr VIP 1 VIP 2 1 2 tnslsnr SCAN VIP service1 service1 tnslsnr service1 instance1 instance2
Single Client Access Name (SCAN) SCAN 11 Copyright © 2020,
Oracle and/or its affiliates tnslsnr Oracle instance1 Oracle instance2 tnslsnr VIP 1 VIP 2 1 2 tnslsnr SCAN VIP service1 service1 tnslsnr service1 instance1 instance2
Single Client Access Name (SCAN) DNS 1 SCAN SCAN VIP
12 Copyright © 2020, Oracle and/or its affiliates 1 2 tnslsnr scanvip1 tnslsnr tnslsnr scanvip2 scanvip3 (DESCRIPTION = (LOAD_BALANCE=ON) (FAILOVER=ON) (ADDRESS = (PROTOCOL = TCP) (HOST = scanvip1) (PORT = 1521)) (ADDRESS = (PROTOCOL = TCP) (HOST = scanvip2) (PORT = 1521)) (ADDRESS = (PROTOCOL = TCP) (HOST = scanvip3) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = service_name) ) ) scanhost scanvip1 scanvip2 scanvip3 (DESCRIPTION = (LOAD_BALANCE=ON) (FAILOVER=ON) (ADDRESS = (PROTOCOL = TCP) (HOST = scanhost) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = service_name) ) )
SCAN 13 Copyright © 2020, Oracle and/or its affiliates 1
2 tnslsnr VIP 1 VIP 2 1 2 VIP 1 TCP RST tnslsnr scanvip1 tnslsnr scanvip1 SCAN SCAN VIP SCAN SCAN VIP
Single Client Access Name (SCAN) (RAC ) 14 Copyright ©
2020, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted 1 2 tnslsnr vip1 1 2 tnslsnr scanvip1 tnslsnr tnslsnr scanvip2 scanvip3 (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = scanhost) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = service_name) ) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = vip1) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = service_name) ) ) RAC
None
Our mission is to help people see data in new
ways, discover insights, unlock endless possibilities.