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

最新推荐文章于 2023-01-13 15:08:13 发布

转载最新推荐文章于 2023-01-13 15:08:13 发布 · 1.2k 阅读

文章标签：

#oracle #集群 #java #service #tcp #jdbc

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

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