Linked Server to MySQL 5 from Oracle 11G R2

Posted on 2014-08-12
Last Modified: 2014-08-25
Hi Experts,

I have to configure linked server to Mysql from Oracle i have already read articles on internet and edit, all accessory files. it seems there is a issue with my listner.ora file. SID_LIST_LISTENER for MY SQL is myodbc5.  please correct my Listner file.

        (ADDRESS = (PROTOCOL = TCP) (HOST = oramob.local) (PORT = 1522))
        (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1526))

     (SID_DESC =
        (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    ( SID_DESC =
        (SID_NAME = myodbc5)
        (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
        (PROGRAM = dg4odbc)

    (ADDRESS = (PROTOCOL = TCP)(HOST = oramob.local)(PORT = 1521))

ADR_BASE_LISTENER = /u01/app/oracle
    LVL 5

    Assisted Solution

    by:Sanjeev Labh
    I think just by configuring the listener it might not be sufficient. For connecting to hetrogenous database Oracle needs some gateway. ODBC provides the right gateway. So, the listener configuration would have to be done alongwith the ODBC connection.

    I think the below article provides a right example for your case. Try it out probably this should help.
    LVL 24

    Accepted Solution


    You will have to download and install the Oracle Gateway for the heterogeneous db connections. It's not included in the database install.

    The gateway can be downloaded here
    or folllow the links (see all ) for your OS.

    The Gateway manual can be found here

         Tomas Helgi
    LVL 7

    Author Closing Comment

    by:Pushpakumara Mahagamage

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now