偶看新闻拳皇2002风云手机版:Linux下Oracle數據庫建立Informix的DBlink的步驟(一)
来源：百度文库 编辑：偶看新闻 时间：2024/04/24 19:50:49
現在實際工作中，在不同類型的DB間建立連接非常廣泛，像我們會在ORACLE數據庫中使用INFORMIX數據庫中的資料，也相當於ORACLE內部DBLINK的含義，隻是要從其它類型的數據庫抓取資料，這種’DBLINK’建立起來就有點復雜，下面我們以在ORACLE建立到INFORMIX的LINK為例，列以下簡單步驟：
環境如下：
OS: Red Hat Enterprise Linux AS release 4 (Nahant Update 2)
ORACLE: Oracle Database
INFORMIX: IBM Informix Dynamic Server Version 9.40.FC7
使用INFORMIX驅動組件: clientsdk.2.90.UC4.LINUX.tar
一、首先，在裝有ORACLE DB的服務器上安裝INFORMIX的驅動程式
[oracle@test infor] $mdir /u/infor
[oracle@test infor] $groupadd –g 200 informix
[oracle@test infor] $useradd –g 200 –G Informix –d /u/infor Informix
[oracle@test infor] $chown –R Informix:Informix /u/infor
釋放clientsdk.2.90.UC4.LINUX.tar,並安裝相應程式:
[oracle@test infor]$ ls
bin csdk.ini doc gls.rpm installclientsdk lib release
clientsdk.2.90.UC4.LINUX.tar csdk.jar etc hua.tar installesql message.rpm RUN_AS_ROOT.clientsdk
clientsdkcontent.rpm demo gls incl install_rpm msg
[oracle@test infor]$ pwd
/u/infor
二、編輯配置文件/etc/odbc.ini
[oracle@test infor]$ cat /etc/odbc.ini
[Infdrv1]
Driver=/u/infor/lib/cli/iclis09b.so
Description=IBM INFORMIX ODBC DRIVER
Database=ds
LogonID=FKPCB
pwd=FKPCB
Servername=on_tcp90
CursorBehavior=0
CLIENT_LOCALE=zh_TW.big5
DB_LOCALE=zh_TW.big5
TRANSLATIONDLL=/u/infor/lib/esql/igo
\n
[ODBC]
;uncomment the below line for UNICODE connection
;UNICODE=UCS-4
\n
Trace=0
TraceFile=/tmp/odbctrace.out
InstallDir=/u/infor
[Infuse1]
Driver=/u/infor/lib/cli/iclis09b.so
Description=IBM INFORMIX ODBC DRIVER
Database=ds
LogonID=ODBCMMS
pwd=mms1688
Servername=on_tcp99
CursorBehavior=0
CLIENT_LOCALE=zh_TW.big5
DB_LOCALE=zh_TW.big5
TRANSLATIONDLL=/u/infor/lib/esql/igo
\n
[ODBC]
;uncomment the below line for UNICODE connection
;UNICODE=UCS-4
\n
Trace=0
TraceFile=/tmp/odbctrace.out
InstallDir=/u/infor
(當配置多個INFORMIX服務時，也要配置如下文件:
在/etc/services文件尾部加入以下部分即可
# Local services
on_tcp99_srv 9099/tcp)
三、編輯配置文件/u/infor/etc/sqlhosts
[oracle@test etc]$ cat sqlhosts
#********************************************************************
#
# IBM INC.
#
# PROPRIETARY DATA
#
# Licensed Material - Property Of IBM
#
# "Restricted Materials of IBM"
#
# IBM Informix Client SDK
#
# (c) Copyright IBM Corporation 2002. All rights reserved.
#
# Title: sqlhosts.demo
# Description:
# Default sqlhosts file for running demos.
#
#*******************************************************************
cdr129 group - - i=129
on_tcp129 onsoctcp 10.188.131.183
on_shm129 onipcshm informix on_shm129_srv g=cdr129
cdr90 group - - i=90
on_tcp90 onsoctcp 10.134.98.73
on_shm90 onipcshm chnhsdb1 on_shm90_srv g=cdr90
cdr69 group - - i=69
on_tcp69 onsoctcp fklntwn on_tcp69_srv g=cdr69
on_shm69 onipcshm fklntwn on_shm69_srv g=cdr69
cdr190 group - - i=190
on_tcp190 onsoctcp test1 on_tcp190_srv g=cdr190
on_shm190 onipcshm test1 on_shm190_srv g=cdr190
cdr99 group - - i=99
on_tcp99 onsoctcp 10.130.14.15 on_tcp99_srv g=cdr99
on_shm99 onipcshm 10.130.14.15 on_shm99_srv g=cdr99