环境是这样的:
192.9.200.8 WINDOWS SERVER 2008R2 + SQLSERVER 2008R2
192.168.2.97 LINUX+ORACLE R11两个服务器间通迅没问题192.9.200.8上的配置文件:
initdg4msql.ora:
HS_FDS_CONNECT_INFO=[192.9.200.8].MSSQLSERVER.EF2KWeb
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
listener.ora:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = naier-server)(PORT = 1523))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1523))
)
) SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=dg4msql)
(ORACLE_HOME=I:\product\11.2.0\tg_2)
(PROGRAM=dg4msql)
)
)
ADR_BASE_LISTENER = I:\product\11.2.0\tg_2ORACLE服务器上的配置文件:
tnsnames.ora:
dg4msql =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST=192.9.200.8)(PORT=1523))
(CONNECT_DATA =
(SID = dg4msql)
)
(HS=OK)
)
按这个配置,建立数据库连接 create public database link msoa connect to sa identified by "passwd" using 'dg4msql'
使用查询语句 select * from finfay@msoa 报错 ora-00942 表或视图不存在搞了一天了,不知道问题在哪?求大侠指点!谢谢
192.9.200.8 WINDOWS SERVER 2008R2 + SQLSERVER 2008R2
192.168.2.97 LINUX+ORACLE R11两个服务器间通迅没问题192.9.200.8上的配置文件:
initdg4msql.ora:
HS_FDS_CONNECT_INFO=[192.9.200.8].MSSQLSERVER.EF2KWeb
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
listener.ora:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = naier-server)(PORT = 1523))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1523))
)
) SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=dg4msql)
(ORACLE_HOME=I:\product\11.2.0\tg_2)
(PROGRAM=dg4msql)
)
)
ADR_BASE_LISTENER = I:\product\11.2.0\tg_2ORACLE服务器上的配置文件:
tnsnames.ora:
dg4msql =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST=192.9.200.8)(PORT=1523))
(CONNECT_DATA =
(SID = dg4msql)
)
(HS=OK)
)
按这个配置,建立数据库连接 create public database link msoa connect to sa identified by "passwd" using 'dg4msql'
使用查询语句 select * from finfay@msoa 报错 ora-00942 表或视图不存在搞了一天了,不知道问题在哪?求大侠指点!谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货