oracle透明网关同一台机器,oracle透明网关

oracle9i与sqlserver2005在同个机器,并且机器名为ce1d379e086e4ea

OS:SERVER2003

sqlserver2005 数据库实例名zb 用户 sa 密码sa oracle9i 数据库实例名zb

1 在%oracle_home%\tg4msql\admin\下新添加initsqlserver2005.ora

内容如下

HS_FDS_CONNECT_INFO="SERVER=ce1d379e086e4ea/IP;DATABASE=zb"

HS_FDS_TRACE_LEVEL=OFF

HS_FDS_RECOVERY_ACCOUNT=RECOVER

HS_FDS_RECOVERY_PWD=RECOVER

修改%oracle_home%\network\admin\下listener.ora

在SID_LIST_LISTENER下添加如下内容

(SID_DESC =

(GLOBAL_DBNAME = tg4msql)

(PROGRAM = tg4msql)

(SID_NAME = sqlserver2005)

(ORACLE_HOME = D:\oracle\ora92)

)

--

SID_DESC =

(SID_NAME = kss)

(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)

(PROGRAM = tg4msql)

)

)

2 重新启动listener

lsnrctl stop start

成功

修改%oracle_home%\network\admin\下tnsnames.ora

3 添加如下内容

sql =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = ce1d379e086e4ea)(PORT = 1521))

)

(CONNECT_DATA =

(SID = sqlserver2005)SID=SID_NAME=KSS

(HS=OK)

)

)

4 数据源的配置。

用sys登陆sqlplus给我dbcxbj数据库的dbcxbj用户赋予create public database link权限

用dbcxbj登陆sqlplus创建public database link

create public database link orasql connect to sa identified by sa using 'sql';

创建成功

查看sqlserver2005里zb数据库student表内容

select * from student@orasql;

SQL> select * from student@orasql;

select * from student@orasql