Jdbc datagaurd问题

Question

为了实现两台服务器的高可用性，我在Oracle数据库中实现了datagaurd，并将jdbc设置配置为连接Jboss应用程序服务器，以始终连接主数据库实例。

如果我使用以下字符串：

<connection-url>
jdbc:oracle:thin:@(DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=<ip1>)(PORT=<port>))(ADDRESS=(PROTOCOL=TCP)(HOST=<ip2>)(PORT=<port>)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME
= MYDB)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))))</connection-url>

当我执行切换/文件切换时，ip1处于关闭状态，ip2处于启动状态。如果我在列表中首先指定ip2，那么就会得到一个连接(就像我尝试连接到ip2时所期望的那样)。但是，当我首先放置ip1时，我得到的错误与我试图直接连接到的错误相同

java.util.concurrent.ExecutionException: java.lang.RuntimeException:
java.sql.SQLException: ORA-01033: ORACLE initialization or shutdown
in progress

Answer 1

Data Guard与RAC的推荐连接URL如下所示。您能确保使用正确的连接URL吗？

jdbc:oracle:thin:@(DESCRIPTION = (FAILOVER=on)
     (CONNECT_TIMEOUT= 15) (RETRY_COUNT=20) (RETRY_DELAY=3)
       (ADDRESS_LIST =
           (LOAD_BALANCE=on)
           (ADDRESS = (PROTOCOL = TCP) (HOST=primary-scan) (PORT=1521)))
      (ADDRESS_LIST =
             (LOAD_BALANCE=on)
             (ADDRESS = (PROTOCOL = TCP) (HOST=secondary-scan) (PORT=1521))) 
      (CONNECT_DATA= (SERVICE_NAME = gold-cloud-service-name)))