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

最新推荐文章于 2024-09-02 07:45:24 发布

jiangping403

最新推荐文章于 2024-09-02 07:45:24 发布

阅读量1.2k

点赞数

文章标签： oracle 集群 java service tcp jdbc

本文详细对比了Oracle集群中和非集群中PL/SQL与Java程序的连接配置，包括DB1_193、jdbc连接URL以及RAC_DB的设置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

oracle集群中plsql和java程序连接方式非集群中plsql连接配置：DB1_193 =,(DESCRIPTION =,(ADDRESS_LIST =

　　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连接配置：

　RAC_DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.46.2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.46.4)(PORT = 1521))
(LOAD_BALANCE = off)
(FAILOVER = yes)
)
(CONNECT_DATA =
(SERVICE_NAME = sms139_service)
(FAILOVER_MODE = (TYPE = SELECT)
(METHOD = BASIC)

)
)
)

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

http://database.ctocio.com.cn/460/9242960.shtml