oracle集群url配置

oracle集群中plsql和java程序连接方式非集群中plsql连接配置:

  DB1_193 =

  (DESCRIPTION =

  (ADDRESS_LIST =

  (ADDRESS = (PROTOCOL = TCP)(HOST = 59.208.39.193)(PORT = 1521))

  )

  (CONNECT_DATA =

  (SERVICE_NAME = bester)

  )

  )

  非集群中java连接的url

  url=jdbc:oracle:thin:@127.0.0.1:1521:bester

  oracle集群中plsql连接配置:

  db_1_2 =

  (DESCRIPTION =

  (ADDRESS = (PROTOCOL = TCP)(HOST = 59.208.39.193)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 59.208.39.195)(PORT = 1521))

  (LOAD_BALANCE=yes)

  (CONNECT_DATA =

 

  (SERVICE_NAME = bester)

  )

  )

  oracle集群中java程序连接的url

  datasource.url=jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST =59.208.39.193)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST =59.208.39.195)(PORT = 1521))(LOAD_BALANCE=yes)(CONNECT_DATA =(SERVICE_NAME = bester)))

原文地址:https://www.cnblogs.com/wsy0202/p/12956203.html