2009-10-29 12:07:06| 分类: oracle RAC技术 | 标签: |举报 |字号大中小 订阅
在默认rac安装完成后,数据库会生成根据数据库名称的tnsnames服务,但该服务目前在测试中并不能实现透明故障切换,
如:
[oracle@rac1 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.1/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
DEVDB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.wanmo.com)(PORT = 1521))
(CONNECT_DA
(SERVER = DEDICATED)
(SERVICE_NAME = devdb)
(INSTANCE_NAME = devdb2)
)
)
DEVDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.wanmo.com)(PORT = 1521))
(CONNECT_DA
(SERVER = DEDICATED)
(SERVICE_NAME = devdb)
(INSTANCE_NAME = devdb1)
)
)
DEVDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.wanmo.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.wanmo.com)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DA
(SERVER = DEDICATED)
(SERVICE_NAME = devdb)
)
)
LISTENERS_DEVDB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.wanmo.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.wanmo.com)(PORT = 1521))
)
EXTPROC_CONNECTION_DA
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DA
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
评论