问题描述

Oracle透明网关连接sqlserver，ora-01017

oracle11g 透明网关 连接 sqlserver2000

create database link DBFCSERVER
connect to sa
IDENTIFIED BY "ldfc"
using 'ldfc';

select sysdate from dual@DBFCSERVER;

提示 ORA-01017，用户名密码不对，用户名密码自己在sqlserver检测正确，请大家帮忙看看是什么原因

环境
197.168.0.20 计算机名：ldfc-server1

sql server2000
数据库名称：测试数据库
用户名：sa
密码：ldfc

Oracle11g datebase
安装目录：F:appAdministratorproduct11.2.0dbhome_1
SID:ldfc
端口：1521

oracle Database Gateway for Microsoft SQL Server 11.2.0.1.0
安装目录：F:appAdministratorproduct11.2.0dbhome_1

F:appAdministratorproduct11.2.0dbhome_1dg4msqladmin下增加文件：initldfc.ora
HS_FDS_CONNECT_INFO=[197.168.0.20]//林甸房产
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER

listener.ora文件修改

listener.ora Network Configuration File: F:appAdministratorproduct11.2.0dbhome_1

networkadminlistener.ora

Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = F:appAdministratorproduct11.2.0dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:F:appAdministratorproduct11.2.0dbhome_1

binoraclr11.dll")
)
)
LDFC
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ldfc-server1)(PORT = 1521))
)
)

ADR_BASE_LISTENER = F:appAdministrator

tnsnames.ora文件修改

tnsnames.ora Network Configuration File: F:appAdministratorproduct11.2.0dbhome_1

networkadmintnsnames.ora

Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

LDFC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ldfc-server1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ldfc)
)
)

解决方案

解决方案二：

没看到这个配置与SQLServer的任何关联
而且
HS_FDS_CONNECT_INFO=[197.168.0.20]//林甸房产 也没配数据库。
你dblink中配置的using "ldfc"应该是oracle自己的数据库，不是SQLServer
再检查检查配置文件吧