引用地址:http://www.xiyugu.com/eschool/programming/data/7730.html
?
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 =
??? (SERVER = DEDICATED)
??? (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 =(SERVER = DEDICATED)(SERVICE_NAME = bester)))
??? 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 =
??? (SERVER = DEDICATED)
??? (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 =(SERVER = DEDICATED)(SERVICE_NAME = bester)))