Wednesday, October 26, 2016

Example of JDBC THIN and THICK client: Oracle 11g/12c with SCAN IP

THIN Client:
jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = vip_db1.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = vip_db2.com)(PORT = 1521)) (LOAD_BALANCE = ON)(FAILOVER = ON))
(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = SERVICE_NAME.COM)(FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC))))

Thick Client:

SERVICE_NAME.COM =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SCAN_NAME.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = SERVICE_NAME.COM) ) )

No comments:

Post a Comment