目前361版本RAC的环境为:
10.47.222.81 rac1、10.47.222.83 rac2、10.47.222.80 rac3
客户端应用程序必须通过其VIP进行连接,方便oracle实现failover:
|
Node |
Interface name |
Type |
IP Adress |
|
rac1 |
rac1 |
Public |
10.47.222.81 |
|
rac1 |
rac1-vip |
Virtual |
10.47.222.197 |
|
rac1 |
rc1-riv |
Private |
192.168.0.1 |
|
rac2 |
rac2 |
Public |
10.47.222.83 |
|
rac2 |
rac2-vip |
Virtual |
10.47.222.198 |
|
rac2 |
rc2-piv |
Private |
192.168.0.2 |
|
rac3 |
rac3 |
Public |
10.47.222.80 |
|
rac3 |
rac3-vip |
Virtual |
10.47.222.199 |
|
rac3 |
rac3-piv |
Private |
192.168.0.3 |
单节点DB环境为10.47.225.45。
不同类型的应用连接方式修改如下:
通过TNS连接DB的应用程序,可以直接修改nsname,ora来实现连接RAC DB,如:
zx10_47_225_45 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac3-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER = on)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = zxin)
(FAILOVER_MODE=
(TYPE=select)
(METHOD=basic))
)
)
这样连接方式有SDF、双中心standby、应用中创建的DBlink等,修改上面红色部分为具体的VIP
OCI 包含使用OCCI的C++应用程序、使用ODBC启动驱动程序的C应用程序、使用
JDBC的JAVA应用程序、使用 OLEDB 驱动程序的 VB 应用程序、Pro*C 应用程序等,该类连接方式都是通过连接串连接访问数据库,需要修改连接串中的url,修改如下
String url="jdbc:oracle:thin:@(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac3-vip)(PORT = 1521))
(LOAD_BALANCE = yes)(FAILOVER = ON)(CONNECT_DATA =(SERVER = DEDICATED)
(SERVICE_NAME = zxin)(FAILOVER_MODE=(TYPE = SELECT)(METHOD = BASIC))))";
包括SLCS,OMM,统计服务器等,修改上面红色部分为具体的VIP。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/25801738/viewspace-702435/ ,如需转载,请注明出处,否则将追究法律责任。