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:\app\Administrator\product\11.2.0\dbhome_1
SID:ldfc
端口:1521
oracle Database Gateway for Microsoft SQL Server 11.2.0.1.0
安装目录:F:\app\Administrator\product\11.2.0\dbhome_1
F:\app\Administrator\product\11.2.0\dbhome_1\dg4msql\admin下增加文件: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:\app\Administrator\product\11.2.0\dbhome_1
\network\admin\listener.ora
Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = F:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:F:\app\Administrator\product\11.2.0\dbhome_1
\bin\oraclr11.dll")
)
)
LDFC
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ldfc-server1)(PORT = 1521))
)
)
ADR_BASE_LISTENER = F:\app\Administrator
tnsnames.ora文件修改
tnsnames.ora Network Configuration File: F:\app\Administrator\product\11.2.0\dbhome_1
\network\admin\tnsnames.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)
)
)