oracle 异构服务
要从sql server抓资料到oracle 10g
下载安装gateways后
然后有配置了
F:\oracle\product\10.2.0\db_1\tg4msql\admin\inittg4msql.ora
文件配置:
HS_FDS_CONNECT_INFO=10.10.10.10.xiaoxiao ---这个地方要是sqlserver服务器的主机名
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER还有listener文件配置:SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC=
(SID_NAME=tg4msql)
(ORACLE_HOME=F:\oracle\product\10.2.0\db_1)
(PROGRAM=tg4msql) )
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1521))
)
)Tnsnames 文件配置
tg4msql=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST = 10.10.10.10)
(PORT = 1521)
)
(CONNECT_DATA=
(SID=tg4msql))
(HS=OK)
)在创建dblink 时出错拉
错误信息:ORA-12154: TNS: 无法解析指定的连线 ID
烦请各位牛牛指点弥经,感激不尽~~
要从sql server抓资料到oracle 10g
下载安装gateways后
然后有配置了
F:\oracle\product\10.2.0\db_1\tg4msql\admin\inittg4msql.ora
文件配置:
HS_FDS_CONNECT_INFO=10.10.10.10.xiaoxiao ---这个地方要是sqlserver服务器的主机名
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER还有listener文件配置:SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC=
(SID_NAME=tg4msql)
(ORACLE_HOME=F:\oracle\product\10.2.0\db_1)
(PROGRAM=tg4msql) )
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1521))
)
)Tnsnames 文件配置
tg4msql=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST = 10.10.10.10)
(PORT = 1521)
)
(CONNECT_DATA=
(SID=tg4msql))
(HS=OK)
)在创建dblink 时出错拉
错误信息:ORA-12154: TNS: 无法解析指定的连线 ID
烦请各位牛牛指点弥经,感激不尽~~
但在执行查询(select * from odb.ap_user@"xiaoxiao")
是出的错ORA-12154: TNS: 无法解析指定的连线 ID
select * from odb.ap_user@"xiaoxiao"中的双引号都去掉。
去掉也不行,
了连接中断的错误
但我也ping了sql serverDB是可以ping的通的