Linux下Oracle數據庫建立Informix的DBlink的步驟(二)

四、添加相應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/10.2.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

 (SID_LIST =

   (SID_DESC =

     (SID_NAME = PLSExtProc)

     (ORACLE_HOME = /u01/app/oracle/oracle/product/10.2.0/db_1)

     (PROGRAM = extproc)

   )

 (SID_DESC =

    (SID_NAME=infuse01)

    (ORACLE_HOME=/u01/app/oracle/oracle/product/10.2.0/db_1)

    (PROGRAM =hsodbc)

   )

  (SID_DESC =

    (SID_NAME=infuse02)

    (ORACLE_HOME=/u01/app/oracle/oracle/product/10.2.0/db_1)

    (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/10.2.0/db_1/network/admin/tnsnames.ora

# 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)

   )

 )