Single Client Access Name (SCAN), a new feature of Oracle Database 11g RAC databases, will save DBAs some time and effort when they are changing the structure of their RAC databases.
The ability to have a single connection setting for client systems to use when connecting to a RAC database is a new feature of Oracle Database 11g Real Application Cluster (RAC) databases. An important advantage of a Single Client Access Name (SCAN) is not having to update client connection information (such as TNSNAMES.ora) every time you add or remove nodes from an existing RAC cluster.
SCAN automatically provides both failover and load balancing of connects, where the new connection will be directed to the least busy instance in the cluster by default. Furthermore, Clients use a simple EZconnect string and JDBC connections can use a JDBC thin URL to access the database, which is done independently of the physical hosts that the database instances are running on.
Read the full story at Database Journal:
Single Client Access Name (SCAN) for Oracle Database 11g RAC
Back to DBAsupport.com
