Upgrade to Pro — share decks privately, control downloads, hide ads and more …

RAC single client access name

RAC single client access name

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

3115a782126be714b5f94d24073c957d?s=128

oracle4engineer

February 09, 2021
Tweet

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
  15. None
  16. Our mission is to help people see data in new

    ways, discover insights, unlock endless possibilities.