RAC single client access name

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.