Java Connect oracle DataBase TNS

Question

我想连接Oracle DB。

我的.ora：

AUTACSRV120000, AUTACSRV120000.world =
    (DESCRIPTION = 
        (ADDRESS_LIST = 
            (FAILOVER = ON)
            (LOAD_BALANCE = OFF)
            (ADDRESS = (PROTOCOL = TCP)(HOST = infra-dbaas01.noe.rct.fr)(PORT = 1521))
            (ADDRESS = (PROTOCOL = TCP)(HOST = infra-dbaas02.pcy.rct.fr)(PORT = 1521))
        )
        (LOAD_BALANCE = YES)
        (CONNECT_DATA = 
            (SERVER = DEDICATED)
            (SERVICE_NAME = AUTAC_fes.dbaas.rct.fr)
        )

当我想要连接时，我使用

jdbc:oracle:thin:@AUTACSRV120000, AUTACSRV120000.world

结果：

Exception in thread "main" java.sql.SQLRecoverableException: Erreur d'E/S: Inval
id connection string format, a valid format is: "host:port:sid"

但是如果我将.ora编辑为

AUTACSRV120000 =
    (DESCRIPTION = 
        (ADDRESS_LIST = 
            (FAILOVER = ON)
            (LOAD_BALANCE = OFF)
            (ADDRESS = (PROTOCOL = TCP)(HOST = infra-dbaas01.noe.rct.fr)(PORT = 1521))
            (ADDRESS = (PROTOCOL = TCP)(HOST = infra-dbaas02.pcy.rct.fr)(PORT = 1521))
        )
        (LOAD_BALANCE = YES)
        (CONNECT_DATA = 
            (SERVER = DEDICATED)
            (SERVICE_NAME = AUTAC_fes.dbaas.rct.fr)
        )

并使用

jdbc:oracle:thin:@AUTACSRV120000

连接正常

我没有权利离开文件编辑。

Answer 1

可能有两种选择: 1)使用类似于此处(Java JDBC - How to connect to Oracle using Service Name instead of SID)的服务名称进行连接，但我只能使用一台主机来测试这一点。因此，在您的示例中: DB将是: jdbc:oracle:thin:@//infra-dbaas01.noe.rct.fr:1522/AUTAC_fes.dbaas.rct.fr

2)我们可以使用这里提到的连接描述中的TNS条目：https://docs.oracle.com/cd/B28359_01/java.111/b31224/jdbcthin.htm

    String connString = "jdbc:oracle:thin:@(description=(address_list=
   (address=(protocol=tcp)(port=1521)(host=prodHost)))
(connect_data=(INSTANCE_NAME=ORCL)))";
  OracleDataSource ods = new OracleDataSource();

ods.setURL(connString);
ods.setUser("scott");
ods.setPassword("tiger");
Connection conn = ods.getConnection();

Answer 2

JDBC Thin connection仅支持一个TNS别名。因此，您不能提供"jdbc:oracle:thin:@AUTACSRV120000，AUTACSRV120000.world“。您应该只尝试使用一个TNS别名。