Oracle SCAN and converting from a single entry SCAN to DNS SCAN
Oracle SCAN and converting from a single entry SCAN to DNS SCAN
In the article you will have a look at the steps to modify SCAN configuration while converting your SCAN from a single entry residing in /etc/hosts to a SCAN based on 3 DNS entries. SCAN was introduced in 11.2 and allows a single name to be used for the clients to connect to the RAC cluster. SCAN load balances across the node listeners to connect to the instance that provides the best quality of service for a service. SCAN provides a transparency of the cluster structure as follows:
- You can add remove cluster nodes without modifying SCAN
- You can connect to a database without prior information on which cluster nodes the database is running
In the article an assumption is made that Oracle GI 11.2.0.X is installed and running using SCAN defined in /etc/hosts as shown below.
192.168.2.71 oel-cluster.gj.com oel-cluster
Oracle 11.2.0.3 is used for the testing the steps.
Continue reading
-
Archives
- February 2017 (1)
- November 2016 (1)
- October 2016 (1)
- May 2016 (2)
- March 2016 (3)
- December 2014 (2)
- July 2014 (1)
- June 2014 (6)
- May 2014 (5)
- February 2014 (1)
- December 2012 (2)
- November 2012 (8)
-
Categories
-
RSS
Entries RSS
Comments RSS