Link to home
Start Free TrialLog in
Avatar of Pushpakumara Mahagamage
Pushpakumara MahagamageFlag for Sri Lanka

asked on

Linked Server to MySQL 5 from Oracle 11G R2

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.

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

SID_LIST_LISTENER_REMOTSDV =
  (SID_LIST =
     (SID_DESC =
        (SID_NAME = REMOTSDV)
        (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)
        (ENV=LD_LIBRARY_PATH=/export/home/oracle/app/unixodbc-2.2.14/lib:/u01/app/oracle/product/11.2.0/dbhome_1/lib)
        )
   )

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

ADR_BASE_LISTENER = /u01/app/oracle
SOLUTION
Avatar of Sanjeev Labh
Sanjeev Labh
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Tomas Helgi Johannsson
Tomas Helgi Johannsson
Flag of Iceland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Pushpakumara Mahagamage

ASKER

Thanks