Oracle Database Discussions

Hi,

I'm trying to access MYSQL from ORACLE.

I just created the DSN and the connections works.

My listener.ora is the next:
LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 5.2.1.143)(PORT = 1521))
)
)


SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = MYSQL)
(ORACLE_HOME = C:\Oracle\BD11gR1\product\11.1.0\db_1)
(PROGRAM = dg4odbc)
)
)

The tnsnames.ora is:
MYSQL =
(DESCRIPTION=
(ADDRESS= (PROTOCOL= TCP)(HOST= expsashpxp.usersad.everis.int)(PORT= 1521))
(CONNECT_DATA =
(SERVICE_NAME= MYSQL)
)
(HS = OK)
)

and the initdg4odbc.ora is:
HS_FDS_CONNECT_INFO = MYSQL


The oracle server is io Windows XP, and de mysql is on Ubuntu server.

I create the dblink (CREATE DATABASE LINK MYSQL
CONNECT TO "user"
IDENTIFIED BY "pass"
USING 'MYSQL'; ) and whe I do select 1 from dual@MYSQL I get the next error:

ORA-28545: error diagnosticado por Net8 al conectar a un agente
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: 2 lines precediendo a MYSQL

Anybody may help me?

Thanks, and sorry for my english level.

Edited by: user8984874 on 06-abr-2011 1:23