Pushpakumara Mahagamage
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/dbhom e_1)
)
( SID_DESC =
(SID_NAME = myodbc5)
(ORACLE_HOME = /u01/app/oracle/product/11 .2.0/dbhom e_1)
(PROGRAM = dg4odbc)
(ENV=LD_LIBRARY_PATH=/expo rt/home/or acle/app/u nixodbc-2. 2.14/lib:/ u01/app/or acle/produ ct/11.2.0/ dbhome_1/l ib)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oramob.local)(PORT = 1521))
)
ADR_BASE_LISTENER = /u01/app/oracle
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
)
( SID_DESC =
(SID_NAME = myodbc5)
(ORACLE_HOME = /u01/app/oracle/product/11
(PROGRAM = dg4odbc)
(ENV=LD_LIBRARY_PATH=/expo
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oramob.local)(PORT = 1521))
)
ADR_BASE_LISTENER = /u01/app/oracle
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER