In this Document
APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterExalogic Elastic Cloud X4-2 Half Rack Information in this document applies to any platform. PURPOSE11gR2 Grid Infrastructure (CRS) introduced Single Client Access Name (SCAN) to simplify client access to database services, this article is going to explain whats SCAN and how it works. SCOPEIntended audience will be DBAs who is installing/upgrading to 11gR2 Grid Infrastructure or support analyst who is supporting stated product. DETAILSSCAN Concepts
Common Questions Regarding SCANThe following is a list of commonly asked questions regarding SCAN: How can we configure the SCAN and SCAN listener?During Typical installation, you are prompted to confirm the default Single Client Access Name (SCAN), which is used to connect to databases within the cluster irrespective of which nodes they are running on. If you change the SCAN from the default, then the name that you use must be globally unique throughout your enterprise. SCAN VIP and the corresponding SCAN listener works like a pair, when SCAN VIP fails over to other node, the corresponding SCAN listener will also be failed over to the same node. When SCAN VIP fails over happens, it will always select a node with least running SCAN VIP, i.e., if SCAN VIP runs on node1, node2 and node3 of a 4-node cluster, if node3 goes down, the SCAN VIP and corresponding SCAN listener will be failed over to node4 as the other two nodes already have one SCAN VIP running on each node. Also we can use 'srvctl' to add/modify the scan resource and the listeners. Please refer to "Real Application Clusters Admin and Deployment Guide" or Note 1053147.1 for more information.
Do we still need to configure local listeners on each node?Yes, you would need to configure independent local listeners for each node. SCAN listeners are not replacements for the node listeners. How does SCAN work ?
$ SRVCTL STATUS SCAN_LISTENER
SCAN Listener LISTENER_SCAN1 is enabled SCAN listener LISTENER_SCAN1 is running on node TEST1 SCAN Listener LISTENER_SCAN2 is enabled SCAN listener LISTENER_SCAN2 is running on node TEST2 SCAN Listener LISTENER_SCAN3 is enabled SCAN listener LISTENER_SCAN3 is running on node TEST3
Instead of DNS or GNS, Can we use '/etc/hosts' to resolve SCAN?Oracle strongly recommends that you do not configure SCAN VIP addresses in the hosts file. But if you use the hosts file to resolve SCAN name, you can have only one SCAN IP address. Can we use the previous method (Using VIP) for client connection?Clients can continue to access the cluster in the same way as with previous releases. Vips are still used internally, and can still be used for connections. But Oracle strongly recommends that clients accessing the cluster use the SCAN. Clients using the SCAN can also access the cluster using EZCONNECT. Is it mandatory to use SCAN?It's highly recommended to use SCAN unless there's strong business reason preventing it from being used. Is it supported to remove SCAN?SCAN is an elementary part of 11gR2 Grid Infrastructure, it's not supported to remove SCAN. Is it recommended to use COST feature?As a Best Practice, Oracle recommends using the COST feature to restrict instance registration with SCAN listeners as part of your standard listener configuration. Refer to note 1340831.1 for more details. Demo
TEST.ORACLE.COM = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=SCAN-TEST.ORACLE.COM)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=11GR2TEST.ORACLE.COM)))
TEST.ORACLE.COM = (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=TEST1-vip.ORACLE.COM)(PORT=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=TEST2-vip.ORACLE.COM)(PORT=1521))) (CONNECT_DATA=(SERVICE_NAME=11GR2TEST.ORACLE.COM)))
REFERENCESNOTE:1053147.1 - 11gR2 Clusterware and Grid Home - What You Need to KnowNOTE:887471.1 - PRVF-4664 PRVF-4657: Found inconsistent name resolution entries for SCAN name NOTE:972500.1 - How to Modify SCAN Setting or SCAN Listener Port after Installation NOTE:975457.1 - How to Troubleshoot Connectivity Issue with 11gR2 SCAN Name |
Grid Infrastructure Single Client Access Name (SCAN) Explained (文档 ID 887522.1)
最新推荐文章于 2021-04-03 01:27:38 发布