火影战记八门凯美化版:Linux下Oracle數據庫建立Informix的DBlink的步驟(二)
来源:百度文库 编辑:偶看新闻 时间:2024/06/11 06:16:02
四、添加相應ODBC驅動進系統
[root@test ~]#cd /etc/ld.so.conf.d Enter
[root@test ld.so.conf.d]# cat informix.conf
/u/infor/lib/esql
[root@test ld.so.conf.d]#/sbin/ldconfig Enter
[root@test ld.so.conf.d]#ldd /u/infor/lib/cli/libifcli.so Enter
五、以上OK後,進行測試,看是否可以從INFORMIX中拉資料
[root@test ld.so.conf.d]# export INFORMIXDIR=/u/infor
[root@test ld.so.conf.d]# export DBCINI=/etc/odbc.ini
[root@test ld.so.conf.d]# isql -v infdrv1
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select count(*) from zx_file;
+------------------+
| |
+------------------+
| 1042 |
+------------------+
SQLRowCount returns -1
1 rows fetched
SQL> quit
[root@test ld.so.conf.d]#
六、以ORACLE帳號進入,配置相關ORACLE服務
[oracle@test etc]$ cd $ORACLE_HOME
[oracle@test db_1]$ cd hs
[oracle@test hs]$ cd admin
[oracle@test admin]$ ls
inithsodbc.ora initinfuse01.ora initinfuse02.ora listener.ora.sample tnsnames.ora.sample
[oracle@test admin]$ cat initinfuse01.ora
# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.
#
# HS init parameters
#
HS_FDS_CONNECT_INFO =Infdrv1
HS_FDS_TRACE_LEVEL = hsinf.trc
HS_FDS_SHAREABLE_NAME = /usr/lib/libodbc.so
#
# ODBC specific environment variables
#
set DBCINI= /etc/odbc.ini
#
# Environment variables required for the non-Oracle system
#
[oracle@test admin]$
[oracle@test db_1]$ cd network
[oracle@test network]$ cd admin
[oracle@test admin]$ ls
listener.ora samples shrept.lst sqlnet.ora tnsnames.ora
[oracle@test admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/oracle/product/
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/oracle/product/
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME=infuse01)
(ORACLE_HOME=/u01/app/oracle/oracle/product/
(PROGRAM =hsodbc)
)
(SID_DESC =
(SID_NAME=infuse02)
(ORACLE_HOME=/u01/app/oracle/oracle/product/
(PROGRAM =hsodbc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.182.4.65)(PORT = 1521))
)
)
[oracle@test admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/oracle/product/
# Generated by Oracle configuration tools.
HSMINF =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = 10.182.0.00)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = infuse01)
)
(HS = OK)
)
HSNINF =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = 10.182.0.00)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = infuse02)
)
(HS = OK)
)
ERPTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.188.00.00)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = erptest)
)
)