3 Replies Latest reply: Jul 25, 2012 9:36 AM by Kgronau-Oracle RSS

    Oracle 11g Gateway problem dg4ifmx for Open Suse 11.1

    940847
      help my

      initifmx.ora
      # This is a customized agent init file that contains the HS parameters
      # that are needed for the Database Gateway for Informix

      #
      # HS init parameters
      #
      HS_FDS_CONNECT_INFO=[172.16.1.101]:8202/ol_motor/vegacard
      HS_FDS_TRACE_LEVEL=ON
      HS_FDS_RECOVERY_ACCOUNT=vegacard
      HS_FDS_RECOVERY_PWD=*

      Link : "IFMX"
      Error : ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
      ORA-02063: preceding line from IFMX

      ifmx.trc



      Oracle Corporation --- THURSDAY MAY 31 2012 16:23:50.542


      Heterogeneous Agent Release
      11.2.0.3.0




      Oracle Corporation --- THURSDAY MAY 31 2012 16:23:50.542

      Version 11.2.0.3.0

      Entered hgogprd
      HOSGIP for "HS_FDS_TRACE_LEVEL" returned "DEBUG"
      Entered hgosdip
      setting HS_OPEN_CURSORS to default of 50
      HOSGIP returned value of "vegacard" for HS_FDS_RECOVERY_ACCOUNT
      HOSGIP returned a value for HS_FDS_RECOVERY_PWD
      setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG
      setting HS_IDLE_TIMEOUT to default of 0
      setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
      setting HS_NLS_NCHAR to default of "AL32UTF8"
      setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"
      setting HS_FDS_DATE_MAPPING to default of "DATE"
      setting HS_RPC_FETCH_REBLOCKING to default of "ON"
      setting HS_FDS_FETCH_ROWS to default of "100"
      setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
      setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"
      setting HS_FDS_PROC_IS_FUNC to default of "FALSE"
      setting HS_FDS_MAP_NCHAR to default of "TRUE"
      setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"
      setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"
      setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"
      setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"
      setting HS_FDS_QUERY_DRIVER to default of "FALSE"
      setting HS_FDS_SUPPORT_STATISTICS to default of "TRUE"
      setting HS_FDS_QUOTE_IDENTIFIER to default of "TRUE"
      setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"
      setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"
      setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"
      setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
      setting HS_FDS_DELAYED_OPEN to default of "TRUE"
      setting HS_FDS_WORKAROUNDS to default of "0"
      Exiting hgosdip, rc=0
      ORACLE_SID is "ifmx1"
      Product-Info:
      Port Rls/Upd:3/0 PrdStat:0
      Agent:Oracle Database Gateway for INFORMIX
      Facility:hsa
      Class:IFMX, ClassVsn:11.2.0.3.0_0011, Instance:ifmx1
      Exiting hgogprd, rc=0
      Entered hgoinit
      HOCXU_COMP_CSET=1
      HOCXU_DRV_CSET=171
      HOCXU_DRV_NCHAR=873
      HOCXU_DB_CSET=171
      HS_LANGUAGE not specified
      LANG=ru_RU.UTF-8
      HOCXU_SEM_VER=112000
      Entered hgolofn at 2012/05/31-16:23:50
      ODBCINST set to "/ora/orahome11/dg4ifmx/driver/dg4ifmx.loc"
      RC=-1 from HOSGIP for "LD_LIBRARY_PATH"
      LD_LIBRARY_PATH from environment is "/ora/orahome11/lib:/lib:/usr/lib:/usr/local/lib:/lib64:/usr/lib64:/usr/local/lib64"
      Setting LD_LIBRARY_PATH to "/ora/orahome11/dg4ifmx/driver/lib:/ora/orahome11/lib:/lib:/usr/lib:/usr/local/lib:/lib64:/usr/lib64:/usr/local/lib64"
      HOSGIP for "HS_FDS_SHAREABLE_NAME_ICU" returned "/ora/orahome11/dg4ifmx/driver/lib/libHGicu23.so"
      Entered hgolofns at 2012/05/31-16:23:50
      symbol_peflctx=0xe709fb74
      hoaerr:0
      Exiting hgolofns at 2012/05/31-16:23:51
      HOSGIP for "HS_FDS_SHAREABLE_NAME_INST" returned "/ora/orahome11/dg4ifmx/driver/lib/libodbcinst.so"
      Entered hgolofns at 2012/05/31-16:23:51
      hoaerr:28500
      Exiting hgolofns at 2012/05/31-16:23:51
      Failed to load ODBC library symbol: /ora/orahome11/dg4ifmx/driver/lib/libodbcinst.so(SQLGetPrivateProfileString)
      HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/ora/orahome11/dg4ifmx/driver/lib/libodbc.so"
      Entered hgolofns at 2012/05/31-16:23:51
      hoaerr:28500
      Exiting hgolofns at 2012/05/31-16:23:51
      Failed to load ODBC library symbol: /ora/orahome11/dg4ifmx/driver/lib/libodbc.so(SQLAllocHandle)
      Exiting hgolofn, rc=28500 at 2012/05/31-16:23:51
      Exiting hgoinit, rc=28500 with error ptr FILE:hgoinit.c LINE:420 FUNCTION:hgoinit() ID:Loading ODBC aray of function ptrs
      Entered hgoexit
      HS Gateway: NULL connection context at exit
      Exiting hgoexit, rc=0 with error ptr FILE:hgoexit.c LINE:110 FUNCTION:hgoexit() ID:Connection context
        • 1. Re: Oracle 11g Gateway problem dg4ifmx for Open Suse 11.1
          Kgronau-Oracle
          Did you specify in your listener.ora the LD_LIBRARY_PATH?
          For example:
          (SID_NAME=dg4ifmx)
          (ORACLE_HOME=/home/oracle/product/11.2.0.3/db_gtw)
          (ENV="LD_LIBRARY_PATH=/home/oracle/product/11.2.0.3/db_gtw/dg4ifmx/driver/lib:/home/oracle/product/11.2.0.3/db_gtw/lib")
          (PROGRAM=dg4ifmx)
          )

          => you need to make sure that you specified in the LD_LIBRARY_PATH the $ORACLE_HOME/dg4ifmx/driver/lib and ORACLE_HOME/lib directory.

          SIDE NOTE:
          If you have changed the listener, please STOP and START the listener again.

          Edited by: kgronau on May 31, 2012 4:15 PM


          Sorry, I forgot to ask: and what is your Informix database (please specify the full name and the version)?
          • 2. Re: Oracle 11g Gateway problem dg4ifmx for Open Suse 11.1
            Abdelouahab
            I had the following error when trying to connect to informix DB unsing Gateway :

            ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
            [Oracle][ODBC Informix Wire Protocol driver][Informix]36171 {HY000,NativeErr =
            -25571}[Oracle][ODBC Informix Wire Protocol driver]File not found '.odbc.ini'.
            {HY000,NativeErr = 1509}[Oracle][ODBC Informix Wire Protocol driver]Invalid
            attribute in connection string: ArraySize. {01S00}
            ORA-02063: preceding 2 lines from INFORMIXLN

            this is initdg4ifmx.ora :

            HS_FDS_CONNECT_INFO=IfmxHost:1433/test1150/val91
            HS_FDS_TRACE_LEVEL=OFF
            HS_FDS_RECOVERY_ACCOUNT=RECOVER
            HS_FDS_RECOVERY_PWD=RECOVER


            HS_FDS_TRACE_LEVEL=DEBUG
            HS_FDS_TRACE_FILE_NAME =dg4ifmx_trace.trc

            waiting for U thanks.