weblogic rac十g 配备ha

最新推荐文章于 2025-08-09 23:20:16 发布

liangdiwei

最新推荐文章于 2025-08-09 23:20:16 发布

阅读量375

点赞数

CC 4.0 BY-SA版权

文章标签： weblogic service linq server oracle hibernate

本文链接：https://blog.youkuaiyun.com/liangdiwei/article/details/5021790

本文介绍如何配置和使用Oracle Real Application Clusters (RAC)与Oracle WebLogic Server 10.3。主要内容包括设置服务器端tnsnames.ora文件、创建测试脚本test.sh和test.sql来验证连接，以及创建两个节点的数据源和多数据源。

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

How-To Configure and Use Oracle Real Application Clusters (RAC) with Oracle WebLogic Server 10.3

要点

服务器端tnsnames.ora

HASERVICE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = apemrac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = apemrac2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYHASERVICE.apemrac.au.oracle.com)
)
)

test.sh

#!/bin/sh
count=0
while [ $count -lt 5 ] # Set up a loop control
do # Begin the loop
count=`expr $count + 1` # Increment the counter
sqlplus -s juser/juser@HASERVICE @test.sql
done

test.sql

col "Instance" format a20
col "Host" format a20
col "Service Name" format a20
select sys_context('userenv', 'instance_name') "Instance",
sys_context('userenv', 'server_host') "Host",
sys_context('userenv', 'service_name') "Service Name"
from dual

/
exit;

Creating the required Data Sources

Create Data Source #1 for first Node
Here let’s connect to the first instance in our RAC node that will be "orcl1" with an URL as following example.

jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = apemrac1-vip)(PORT = 1521))

(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = MYHASERVICE.apemrac.au.oracle.com)

(INSTANCE_NAME = orcl1)))

Create data Source #2 for second Node
Repeat the steps above but this time select the second node in the RAC cluster. This data source will be called "Node2DS" and once again be targeted to the managed server "lemon"

jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = apemrac2-vip)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.apemrac.au.oracle.com)
(INSTANCE_NAME = orcl2)))

Create the Multi Data Source
<jdbc-connection-pool-params>
<test-frequency-seconds>5</test-frequency-seconds>
</jdbc-connection-pool-params>
<jdbc-data-source-params>
<jndi-name>jdbc/racDS</jndi-name>
<algorithm-type>Load-Balancing</algorithm-type>
<data-source-list>Node1DS,Node2DS</data-source-list>