oracle 通过obdc sqlserver
ms server 2003 Oracle 10.2.0.1.0连接ms sql server 2005
1、控制面板--管理工具--obbc数据源管理器 系统DSN 中增加名称为 sjck 的DSN,并测试成功。
2、复制F:\oracle\product\10.2.0\db_1\hs\admin\inithsodbc.ora,新建F:\oracle\product\10.2.0\db_1\hs\admin\initsjck.ora,initsjck.ora内容为:
HS_FDS_CONNECT_INFO = sjck
HS_FDS_TRACE_LEVEL = 0
3、在F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora 文件中
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
------增加
(SID_DESC =
(GLOBAL_DBNAME = sjck)--测试时不增加这句,一直不成功,不清楚是什么原因
(SID_NAME = sjck)
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(PROGRAM = hsodbc)
)
------------
)
4、在F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora文件中增加
sjck=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)) # HOST= ORACLE IP
(CONNECT_DATA=(SID=sjck))
(HS=OK)
)
5、重启监听分别 执行 lsnrctl stop lsnrctl start lsnrctl status。
6、在plsql中新建连接
CREATE PUBLIC DATABASE LINK sjck
connect to "id" identified by "password"
using 'sjck';
测试连接
select * from dw_area@sjck
ms server 2008 oracle 11.2.0连接ms sql server 2005
1、同上。
2、复制F:\app\Administrator\product\11.2.0\dbhome_1\hs\admin
\initdg4odbc.ora,新建F:\app\Administrator\product\11.2.0\dbhome_1\hs\admin
\initdg4sjck.ora,initdg4sjck.ora内容为:
HS_FDS_CONNECT_INFO = sjck
HS_FDS_TRACE_LEVEL = 0
3、在F:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora 文件中
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
)
------增加
(SID_DESC =
(GLOBAL_DBNAME = sjck)--测试时不增加这句,一直不成功,不清楚是什么原因
(PROGRAM = dg4odbc)
(SID_NAME = dg4sjck)
(ORACLE_HOME = F:\app\Administrator\product\11.2.0\dbhome_1)
)
------------
)
4、在F:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora文件中增加
sjck =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) #HOST = oracle ip
)
(CONNECT_DATA =
(SID = dg4SJCK)
)
(HS = OK)
)
5、重启监听 执行 lsnrctl stop lsnrctl start lsnrctl status。
6、在plsql中新建连接
CREATE PUBLIC DATABASE LINK sjck
connect to "id" identified by "password"
using 'sjck';
测试连接
select * from dw_area@sjck
转自:http://blog.csdn.net/andycode/article/details/8109722
posted on 2017-02-28 09:40 fendoudexiaoniao 阅读(311) 评论(0) 编辑 收藏 举报