11g查询sqlserver数据使用透明网关
创建网关监听,端口号1522
===================================================================================================
数据库监听文件
D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
(SID_DESC =
(SID_NAME = dg4msql)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = dg4msql)
)
数据库TNS文件
D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
DG4MSQL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.77.127)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = dg4msql)
)
(HS = OK)
)
===================================================================================================
网关监听文件
D:\product\11.2.0\tg_1\NETWORK\ADMIN\listener.ora
SID_LIST_LISTENER =
(SID_LIST =
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余2页未读,立即下载