(备忘)plsql连接oracle 10g rac

来源：互联网发布：日本年轻人知乎编辑：程序博客网时间：2024/06/12 00:36

在tnsnames.ora中添加：(host ip皆为vip)

RAC =(DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.221)(PORT = 1521))    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.222)(PORT = 1521))    (LOAD_BALANCE = yes)    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = RAC.WORLD)    ))LISTENERS_RAC =(ADDRESS_LIST =    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.221)(PORT = 1521))    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.222)(PORT = 1521)))RAC2 =(DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.222)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = RAC.WORLD)      (INSTANCE_NAME = RAC2)    ))RAC1 =(DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.221)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = RAC.WORLD)      (INSTANCE_NAME = RAC1)    ))

在hosts中添加
各节点的IP及hostname，否则可能出现连不上服务器或找不到对象的错误