oracle集群中plsql和java程序连接方式

引用地址：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)))

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)))