oracle透明网关环境的建立

最新推荐文章于 2024-09-14 21:52:32 发布

fjnu105022004005

最新推荐文章于 2024-09-14 21:52:32 发布

阅读量268

点赞数

分类专栏： Oracle 文章标签： oracle sqlserver migration list database network

Oracle 专栏收录该内容

133 篇文章 0 订阅

订阅专栏

1、安装oracle 的transparent gateway 透明网关。
安装ORACLE 选择自定义安装，然后再选择安装透明网关，再进去选择安装FOR SQLSERVER 的组件。---www.bianceng.cn
2、修改 oraclehome/ora92/tgsmsql/admin/inittg4msql.orq 文件

HS_FDS_CONNECT_INFO="SERVER=YIRONG-NO1;DATABASE=jsoct"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
说明可以通过 ORACLE 工具中的migration WorkBench 进行配置。（过程中需要配置ODBC）

3、建立监听修改oracle 的 oraclehome/ora92/network/admin/listener.ora 文件。

# LISTENER.ORA Network Configuration File: F:/oracle/ora92/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yirong-no1)(PORT = 1521))
)

)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:/oracle/ora92)
(PROGRAM = extproc)
)

(SID_DESC =
(GLOBAL_DBNAME = ora9i2)
(ORACLE_HOME = F:/oracle/ora92)
(SID_NAME = ora9i2)
)

#连接 sqlserver
(SID_DESC =
(GLOBAL_DBNAME = tg4msql)
(PROGRAM = tg4msql)
(SID_NAME = tg4msql)
(ORACLE_HOME = F:/oracle/ora92)
)

)

4、修改TNS

TG4MSQL =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(CONNECT_DATA=(SID=tg4msql))
(HS=)
)

5、创建DBLINK 说明建立的用户名，密码要是 SQLSERVER 的用户名和密码
create PUBLIC DATABASE LINK oratoSql
CONNECT TO sa IDENTIFIED BY "lanwei"
USING 'TG4MSQL' ;

6、测试数据的是否正常检索。
Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1518385