ORACLE 11G Load Balancing test

Source: Internet
Author: User

In the

Oracle 11g R2, the features of the scan (single Client Access Name) are introduced. The advantage of this feature is that between the database and the client, added a layer of virtual service layer, is called the scan IP and scan IP Listener, in the client only need to configure the scan IP TNS information, through the scan IP Listener, connected to the background cluster database. This will not affect the client regardless of whether the cluster database has operations to add or remove nodes.
the process by which clients connect to a DB instance via scan IP is: client---scan listener, local listener, local instance
There are 2 ways to use Scan:
1, Define the domain name in DNS.
2, DHCP customization is implemented through the Oracle-provided grid naming Server (GNS).
If you do not want to use the above 2 methods, you can modify the hosts file of 2 servers, add scan-cluster.localdomain    172.16.0.75. This approach is not recommended by Oracle because this method can only define one SCAN IP.
Load Balancing:
On the server side, remote_listener default is set to scan Listener
on the client, Tnsnames.ora is configured as follows:
RAC =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP) (HOST = Scan-cluster.localdomain) (PORT = 1521))
   (Connect_data =      (SERVER = dedicated)
      (service_name = RAC)
  ))  

Client connection mode
$ sqlplsu/@RAC
Ezconnet Connection still applies to scan
$ sqlplus/@scan-cluster.localdomain:1521/rac

ORACLE 11G load Balancing test

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.