SCAN - Sample EZConnect and Thin JDBC Connect Strings

The main benefit of using SCAN is that you don't need to change connect string when adding or removing nodes in the 11gR2 Oracle cluster.  Below are few examples of how to connect to a database using SCAN.

sqlplus anguyen/an123@//lab-scan:1521/TOOLS_RAC

si01.an.com> oracle: sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Fri Jul 22 10:40:24 2011
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Enter user-name: anguyen/an123@//lab-scan:1521/TOOLS_RAC

sqlplus anguyen@\"lab-scan:1521/TOOLS_RAC\"


JDBC thin URL

jdbc:oracle:thin:@mydr-scan:1521/TOOLS_RAC