2 Replies Latest reply on Aug 9, 2010 5:07 AM by Kgronau-Oracle

    ORA-28500: connection from ORACLE to a non-Oracle system

    carmonamejias.c
      Hi, I need to connect to a OWB mysql database, but when making a query in sql plus sends me this error.

      ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
      [Generic Connectivity Using ODBC][H006] The init parameter
      <HS_FDS_CONNECT_INFO> is not set. Please set it in init<orasid>.ora file.
      ORA-02063: preceding 2 lines from MYSQLINK

      listener.ora
      # listener.ora Network Configuration File: C:\oraclebi\db\network\admin\listener.ora
      # Generated by Oracle configuration tools.

      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
           (SID_NAME = PLSExtProc)
           (ORACLE_HOME = C:\oraclebi\db)
           (PROGRAM = extproc)
      )
           (SID_DESC =
           (SID_NAME = MYSQL)
           (ORACLE_HOME = C:\oraclebi\db)
           (PROGRAM = hsodbc)
      )
      )
      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = bi.oratechla.com)(PORT = 1521))
      )
      )


      tnsnames.ora

      # tnsnames.ora Network Configuration File: C:\oraclebi\db\network\admin\tnsnames.ora
      # Generated by Oracle configuration tools.

      BISE1DB =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = bi.oratechla.com)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = bise1db)
      )
      )

      EXTPROC_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      )
      (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
      )
      )

      OTCL_MORDOR =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.31.210)(PORT = 1620))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = TEST)
      )
      )


      MYSQL =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = bi.oratechla.com)(PORT = 1521))
      (CONNECT_DATA =
      (SID = MYSQL))
      (HS = OK)
      )


      inithMYSQL.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 = MYSQL
      HS_FDS_TRACE_LEVEL = off

      #
      # Environment variables required for the non-Oracle system
      #
      #set <envvar>=<value>

      system dsn --> MYSQL

      databaselink
      CREATE PUBLIC DATABASE LINK mysqlink CONNECT TO "oracle" IDENTIFIED BY "oracle" using 'ejemplo';
      Database link created.

      select * from empleado@mysqlink;

      ERROR at line 1:
      ORA-12154: TNS:could not resolve the connect identifier specified

      or

      ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
      [Generic Connectivity Using ODBC][H006] The init parameter
      <HS_FDS_CONNECT_INFO> is not set. Please set it in init<orasid>.ora file.
      ORA-02063: preceding 2 lines from MYSQLINK

      tnsping


      C:\Documents and Settings\Administrator>tnsping MYSQL

      TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 06-AUG-2
      010 06:31:57

      Copyright (c) 1997, 2005, Oracle. All rights reserved.

      Used parameter files:
      C:\oraclebi\db\network\admin\sqlnet.ora


      Used TNSNAMES adapter to resolve the alias
      Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = bi.orate
      chla.com)(PORT = 1521)) (CONNECT_DATA = (SID = MYSQL)) (HS = OK))
      OK (30 msec)
        • 1. Re: ORA-28500: connection from ORACLE to a non-Oracle system
          BelMan
          See this link

          step by step for windows
          http://www.scribd.com/doc/3146805/Oracle-Heterogeneous-Configuration-for-MySQL-with-ODBCOLEDB
          or for unix or linux
          http://www.idevelopment.info/data/Oracle/DBA_tips/Heterogeneous_Services/HETERO_2.shtml
          • 2. Re: ORA-28500: connection from ORACLE to a non-Oracle system
            Kgronau-Oracle
            Use the setup failing with
            ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
            [Generic Connectivity Using ODBC][H006] The init parameter
            <HS_FDS_CONNECT_INFO> is not set. Please set it in init<orasid>.ora file.
            ORA-02063: preceding 2 lines from MYSQLINK


            There is a typo in the name of you gateway init file. You posted the content of inithMYSQL.ora but the naming is init<SID>.ora which is in your case initMYSQL.ora.

            In addition please keep in mind HSODBC has been desupported since 2008 and when starting a new configuration you should use the follow up product dg4odbc (Database Gateway for ODBC) V11.