Oracle|Oracle RAC JDBC connection string - multitude - 博客园 OracleRACJDBCconnectionstring-multit

完全正确
【Oracle|Oracle RAC JDBC connection string - multitude - 博客园】 https://stackoverflow.com/questions/1646630/what-is-the-correct-jdbc-url-to-connect-to-a-rac-database

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON) (ADDRESS=(PROTOCOL=TCP)(HOST=tst-db1.myco.com)(PORT=1604)) (ADDRESS=(PROTOCOL=TCP)(HOST=tst-db2.myco.com)(PORT=1604))) (CONNECT_DATA=https://www.it610.com/article/(SERVICE_NAME=mydb1.myco.com)(SERVER=DEDICATED)))

官方文档, 一如既往地冗长, 可靠
https://docs.oracle.com/database/121/HABPT/config_fcf.htm#HABPT5381

Oracle|Oracle RAC JDBC connection string - multitude - 博客园

文章图片

PoolDataSource pds = PoolDataSourceFactory.getPoolDataSource(); pds.setConnectionFactoryClassName("oracle.jdbc.pool.OracleDataSource"); pds.setUser("system"); pds.setPassword("oracle"); String dbURL = "jdbc:oracle:thin:@" + "(DESCRIPTION=" + "(FAILOVER=on)" + "(ADDRESS_LIST=" + "(LOAD_BALANCE=on)" + "(CONNECT_TIMEOUT=3)(RETRY_COUNT=3)" + "(ADDRESS=(PROTOCOL=TCP)(HOST=prmy-scan)(PORT=1521))"+"(ADDRESS=(PROTOCOL=TCP)(HOST= stby-scan)(PORT=1521)))" + "(CONNECT_DATA=https://www.it610.com/article/(SERVICE_NAME=oltpworkload)))" System.out.println("Url=" + dbURL); pds.setURL(dbURL);

文章图片

"jdbc:oracle:thin:@" + "(DESCRIPTION=" + "(FAILOVER=on)" + "(ADDRESS_LIST=" + "(LOAD_BALANCE=on)" + "(CONNECT_TIMEOUT=3)(RETRY_COUNT=3)" + "(ADDRESS=(PROTOCOL=TCP)(HOST=prmy-scan)(PORT=1521))"+"(ADDRESS=(PROTOCOL=TCP)(HOST= stby-scan)(PORT=1521)))" + "(CONNECT_DATA=https://www.it610.com/article/(SERVICE_NAME=oltpworkload)))"

文章图片

PoolDataSource pds = PoolDataSourceFactory.getPoolDataSource(); pds.setConnectionFactoryClassName("oracle.jdbc.pool.OracleDataSource"); pds.setUser("system"); pds.setPassword("oracle"); String dbURL = "jdbc:oracle:thin:@" + "(DESCRIPTION_LIST=" + "(LOAD_BALANCE=off)" + "(FAILOVER=on)" + "(DESCRIPTION=" + "(CONNECT_TIMEOUT=3)(RETRY_COUNT=3)" + "(ADDRESS_LIST=" + "(LOAD_BALANCE=on)" + "(ADDRESS=(PROTOCOL=TCP)(HOST=prmy-scan)(PORT=1521)))" + "(CONNECT_DATA=https://www.it610.com/article/(SERVICE_NAME=oltpworkload)))" + "(DESCRIPTION=" + "(ADDRESS_LIST=" + "(LOAD_BALANCE=on)" + "(ADDRESS=(PROTOCOL=TCP)(HOST= stby-scan)(PORT=1521)))" + "(CONNECT_DATA=https://www.it610.com/article/(SERVICE_NAME=oltpworkload))))"; System.out.println("Url=" + dbURL); pds.setURL(dbURL);

文章图片

这个第三方总结很简单, 看样子是第三方驱动厂商
https://support.tibco.com/s/article/JDBC-dbURL-when-using-failover-servers-with-Oracle
Resolution When creating the bootstrap use the following formats for the JDBC connection string.

Case 1: When using tibcosoftwareinc.jdbc.oracle.OracleDriver driver (Oracle (DataDirect)), JDBC URL field should contain:

jdbc:tibcosoftwareinc:oracle://:SID=AlternateServers=(:SID=)

Example URL:

jdbc:tibcosoftwareinc:oracle://host1:1521; ServiceName=orcl; AlternateServers=(host2:1521)

Case 2: When using oracle.jdbc.driver.OracleDriver (the native driver form Oracle), the JDBC URL field should contain:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=))(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=))(LOAD_BALANCE=yes)(CONNECT_DATA=https://www.it610.com/article/(SERVICE_NAME=)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180))))

Example URL:

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2) (PORT=1521))(CONNECT_DATA=https://www.it610.com/article/(SERVICE_NAME=orcl)))

See more information inOracle's documentation. Reference Oracle documentation:Configuring Fast Connection Failover for JDBC Clients