informix db安装在机器A:redhat5+informix9.4
oracle db和gatways安装在一台机器B:redhat5+oracle11gR2
gatways安装目录:$ORACLE_HOME/dg4ifmx配置$ORACLE_HOME/dg4ifmx/admin/initdg4ifmx.ora
HS_FDS_CONNECT_INFO=机器A:PORT/SERVICE_NAME/DBNAME
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER配置$ORACLE_HOME/network/admin/listener.ora
LISTENER=
  (DESCRIPTION_LIST=
    (DESCRIPTION=
      (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))
      (ADDRESS=(PROTOCOL=TCP)(HOST=机器B)(PORT=1521))
    )
   )
SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (PROGRAM=dg4ifmx)
      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME=dg4ifmx)
     )
  )
ADR_BASE_LISTENER=/u01/app/oracle配置$ORACLE_HOME/network/admin/tnsnames.ora
dg4ifmx=
  (DESCRIPTION=
    (ADDRESS=(PROTOCOL=TCP)(HOST=机器B)(PORT=1521))
    (CONNECT_DATA=(SID=dg4ifmx))
    (HS=OK)
  )修改.bash_profile,在LD_LIBRARY_PATH中添加dg4ifmx的路径
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/dg4ifmx/driver/lib:....然后在ORACLE DB里创建database link
create public database link lnk_ifx connect to "username" identified by "pwd" using 'dg4ifmx';执行:
select * from "table_name"@lnk_ifx;
报错:
ora-28545:连线至代理服务器时,Net8诊断发生错误
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063:在2lines之前,自lnk_ifxlistener.log错误提示:
TNS-12518:TNS:listener could not hand off client connection
  TNS-12547:TNS:lost contact
    TNS-12560:TNS:protocol adapter error
      TNS-00517:Lost contact
        Linux Error:32:Broken pipe
直接执行命令dg4ifmx报错:
oracle@机器B$dg4ifmx
dg4ifmx:error while loading shared libraries:/u01/app/oracle/product/11.2.0/db_1/lib/libagtsh.so:cannot restore segment prot after reloc:Permission denied