windows下oracle11g+sqlserver+odbc64配置

1、oracle11g+sqlserver2000+odbc64配置配置说明：1，环境描述中的黑色粗体，红色粗体，蓝色粗体内容在配置的时候要用到2，修改文件中的黑色粗体，红色粗体，蓝色粗体内容为要修改的部分，修改的值按颜色和环境描述相匹配3，黑色表格中的内容为新增内容1 环境描述1.1 Oracle11gIP地址：192.168.1.142Oracle根目录：F:appAdministratorproduct11.2.0dbhome_1Oracle端口：1521SID：orcl用户名：system密码：1234561.2 odbc64IP地址：192.168.1.142odbc配置根目录：F:ap

2、pAdministratorproduct11.2.0dbhome_1hsadmindns and SID：logistics1.3 Sqlserver2005IP地址：192.168.1.142数据库名：logistics用户名：sa密码：sa表：logis_view_stock_main_2 建立dns64位odbc 建立方法“在oracle 里的odbc配置和移植里，在odbc管理点 右键 属性 讲目标路径有c:windowssystem32odbcad32.exe改为C:WindowsSysWOW64odbcad32.exe，就可以添加32位的odbc数据源了，或者直接到相应的文件夹点

3、exe文件运行也一样。名称：logistics3 修改文件3.1 initlogistics.ora位置：F:appAdministratorproduct11.2.0dbhome_1hsadmin initlogistics.ora这个文件是配置连接sql server用的，文件组成结构是init+SID.ora，所以此处SID=logistics文件内容如下：# This is a sample agent init file that contains the HS parameters that are# needed for the Database Gateway for ODBC

4、# HS init parameters#HS_FDS_CONNECT_INFO =logisticsHS_FDS_TRACE_LEVEL =OFF# Environment variables required for the non-Oracle system#set =3.2 HS listener.ora位置：F:appAdministratorproduct11.2.0dbhome_1hsadmin listener.ora文件内容如下：# This is a sample listener.ora that contains the NET8 parameters that are

5、# needed to connect to an HS AgentLISTENER = (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.142)(PORT=1521) )SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (SID_NAME=logistics) (ORACLE_HOME=F:appAdministratorproduct11.2.0dbhome_1) (PROGRAM=dg4odbc)/*/固定的不要变动 ) )#CONNECT_TIMEOUT_LISTENER = 03.3 HS t

6、nsnames.ora位置：F:appAdministratorproduct11.2.0dbhome_1hsadmin tnsnames.ora内容如下：# This is a sample tnsnames.ora that contains the NET8 parameters that are# needed to connect to an HS Agentlogistics = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.142)(PORT=1521) (CONNECT_DATA=(SID=logistics)/*/跟

7、3.2配置的SID_NAME一致 (HS=OK) )3.4 listener.ora位置：F:appAdministratorproduct11.2.0dbhome_1NETWORKADMIN listener.ora增加如下内容SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl) (ORACLE_HOME = F:appAdministratorproduct11.2.0dbhome_1) (SID_NAME = orcl) ) (SID_DESC = (SID_NAME = master) (ORACLE_HO

8、ME = F:appAdministratorproduct11.2.0dbhome_1) (PROGRAM = dg4msql) ) (SID_DESC= (SID_NAME=logistics) (ORACLE_HOME=F:appAdministratorproduct11.2.0dbhome_1) (PROGRAM=dg4odbc) ) )3.5 tnsnames.ora位置：F:appAdministratorproduct11.2.0dbhome_1NETWORKADMIN tnsnames.ora增加如下内容内容：logistics= (DESCRIPTION = (ADDRES

9、S_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.142)(PORT = 1521) ) (CONNECT_DATA = (SID=logistics) ) (HS = OK) )到此5个文件全部修改完成，在oracle中创建和sql server的远程连接4 创建远程连接4.1 重启oracle监听由于之前修改了oracle的监听文件，所以要重新启动监听程序打开“控制面板”-“管理工具”-“服务”-找到名称格式为OraclexxxxxTNSListener的服务重启4.2 打开Oracle sql developer信息参考1.14.3 创建link在命令窗口中执行create database link logistics connect to sa identified by sa using logistics;注： create database link logistics的名字可以随意起比如 create