3Node、2DB的tnsname
注意事项
1． 每个db的tns配置至少有本db和catalog db信息
2．
3node、2db的tns设置
1． 每个db的tns配置至少有本db和catalog db信息
2．
3node、2db的tns设置
LISTENERS_S17R =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db302v)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db103v)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db102v)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db302v)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db103v)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db102v)(PORT = 1521))
)
S16R3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db302v)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = s16r)
(INSTANCE_NAME = s16r3)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db302v)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = s16r)
(INSTANCE_NAME = s16r3)
)
)
S16R2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db103v)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = s16r)
(INSTANCE_NAME = s16r2)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db103v)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = s16r)
(INSTANCE_NAME = s16r2)
)
)
S16R1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db102v)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = s16r)
(INSTANCE_NAME = s16r1)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db102v)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = s16r)
(INSTANCE_NAME = s16r1)
)
)
LISTENERS_S16R =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db302v)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db103v)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db102v)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db302v)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db103v)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db102v)(PORT = 1521))
)
S17R =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db302v)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db103v)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db102v)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = s17r)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db302v)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db103v)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db102v)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = s17r)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
S16R =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db302v)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db103v)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db102v)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = s16r)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db302v)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db103v)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db102v)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = s16r)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
S17R3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db302v)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = s17r)
(INSTANCE_NAME = s17r3)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db302v)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = s17r)
(INSTANCE_NAME = s17r3)
)
)
S17R2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db103v)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = s17r)
(INSTANCE_NAME = s17r2)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db103v)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = s17r)
(INSTANCE_NAME = s17r2)
)
)
S17R1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db102v)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = s17r)
(INSTANCE_NAME = s17r1)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = f6db102v)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = s17r)
(INSTANCE_NAME = s17r1)
)
)
catalog =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.100)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = catalog)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.100)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = catalog)
)
)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23490498/viewspace-677051/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
HP-UX基本管理
下一篇：
rhcs db的listener设置
请登录后发表评论
登录
全部评论
