RAC single client access name

RACは複数ノードで構成されるクラスタ・データベースであるのに、なぜシングル・インスタンス構成と同じ接続記述子で接続可能であるかの説明です。

Transcript

1. Oracle Real Application Clusters 2020 6 17
2. Safe harbor statement Oracle Java Oracle Corporation Copyright © 2020, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted 2
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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) ) )
13. 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
14. 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
16. Our mission is to help people see data in new ways, discover insights, unlock endless possibilities.