Showing posts with label Oracle client. Show all posts
Showing posts with label Oracle client. Show all posts

Thursday, November 25, 2010

Integrate Oracle 10g/11gr2 client or RAC RDBMS with 11gR2 Clusterware

The Single Client Access Name is a new feature that simplifies acces to a cluster database.
In versions proir to Oracle RDBMS 11.2, an entry in the tnsnames.ora file for a n-npde RAC database always referenced all nodes in the address_list section.
From Oracle RDBMS 11.2 the RAC databases can be covered with the SCAN method. A SCAN method is a hostname based method on 1 - 3 virtual IP-addresses based in the DNS of the organisation. The SCAN method solved an TNS ENTRY editing issue in the TNSNAMES.ORA, on actions of adding and removing nodes from the cluster.
SCAN method makes my life easier in managing the Oracle sqlnet configurations for the Oracle cluster databases.