Trying to connect MySQL and Oracle
815422Nov 17 2010 — edited Nov 17 2010Hi all,
i´m tryng to create a dblink between Oracle 10.2.0 and MySQL,
when when i try using sqlplus i obtain this error:
SQL> SELECT * FROM issues@mysqldb;
SELECT * FROM issues@mysqldb
*
ERROR en lÝnea 1:
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 MYSQLDB
This is my configuration:
-----
C:\oracle\product\10.2.0\db_1\hs\admin\initmysqldb.ora
----------------------------
HS_FDS_CONNECT_INFO = hsqldb
HS_FDS_TRACE_LEVEL = 0
HS_FDS_TRACE_FILE_NAME = mysqldb.trc
HS_OPEN_CURSORS=300
HS_AUTOREGISTER = TRUE
------
C:\oracle\app\oracle\product\10.2.0\server\NETWORK\ADMIN\listener.ora
--------
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oracle\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = mysqldb)
(ORACLE_HOME = C:\oracle\app\oracle\product\10.2.0\server)
(PROGRAM = mysqldb)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = MAQUETAXPHP7880)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = MAQUETAXPHP7880)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
-----
C:\oracle\app\oracle\product\10.2.0\server\NETWORK\ADMIN\tnsnames.ora
---------
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = MAQUETAXPHP7880)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
mysqldb =
(DESCRIPTION=
(ADDRESS= (PROTOCOL= tcp)
(HOST= MAQUETAXPHP7880)
(PORT= 1521)
)
(CONNECT_DATA =
(SERVICE_NAME= mysqldb)
)
(HS = OK)
)
-------
sqlnet.ora
------------
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH = (TNSNAMES,ONAMES,HOSTNAME)
-------
lsnrctl status
-------
C:\Documents and Settings\Administrador>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-NOV-2010 10:40:40
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Conectßndose a (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
ESTADO del LISTENER
------------------------
Alias LISTENER
Versi¾n TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Fecha de Inicio 16-NOV-2010 13:47:24
Tiempo Actividad 0 dÝas 20 hr. 53 min. 15 seg.
Nivel de Rastreo off
Seguridad ON: Local OS Authentication
SNMP OFF
Servicio por Defecto XE
Parßmetros del Listener C:\oracle\app\oracle\product\10.2.0\server\network\admin\listener.ora
Log del Listener C:\oracle\app\oracle\product\10.2.0\server\network\log\listener.log
Recibiendo Resumen de Puntos Finales...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MAQUETAXPHP7880)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8095))(Presentation=HTTP)(Session=RAW))
Resumen de Servicios...
El servicio "CLRExtProc" tiene 1 instancia(s).
La instancia "CLRExtProc", con estado UNKNOWN, tiene 1 manejador(es) para este servicio...
El servicio "PLSExtProc" tiene 1 instancia(s).
La instancia "PLSExtProc", con estado UNKNOWN, tiene 1 manejador(es) para este servicio...
El servicio "XEXDB" tiene 1 instancia(s).
La instancia "xe", con estado READY, tiene 1 manejador(es) para este servicio...
El servicio "XE_XPT" tiene 1 instancia(s).
La instancia "xe", con estado READY, tiene 1 manejador(es) para este servicio...
El servicio "hsodbc" tiene 1 instancia(s).
La instancia "hsodbc", con estado UNKNOWN, tiene 1 manejador(es) para este servicio...
El servicio "xe" tiene 1 instancia(s).
La instancia "xe", con estado READY, tiene 1 manejador(es) para este servicio...
El comando ha terminado correctamente
-------
tnsping mysqldb
-------
C:\Documents and Settings\Administrador>tnsping mysqldb
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-NOV-2010 10:44:13
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Archivos de parßmetros utilizados:
C:\oracle\app\oracle\product\10.2.0\server\network\admin\sqlnet.ora
Adaptador TNSNAMES utilizado para resolver el alias
Attempting to contact (DESCRIPTION= (ADDRESS= (PROTOCOL= tcp) (HOST= MAQUETAXPHP7880) (PORT= 1521)) (CONNECT_DATA = (SERVICE_NAME= mysqldb)) (HS = OK))
Realizado correctamente (20 mseg)
-------
I don't find the problem.Thanks for your help.