Dear all,
I have oracle database 10.2.0.5 and MySQL 5.3 on windows environment. all are 64bits.
i want to connect to MySQL. i do the following
configure Listner.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID\_DESC =
(SID\_NAME = PLSExtProc)
(ORACLE\_HOME = C:\\oracle\\product\\10.2.0\\db\_2)
(PROGRAM = extproc)
)
(SID\_DESC =
(GLOBAL\_DBNAME = ORCL)
(ORACLE\_HOME = C:\\oracle\\product\\10.2.0\\db\_2)
(SID\_NAME = ORCL)
)
(SID_DESC=
(SID\_NAME = mysql)
(ORACLE\_HOME = C:\\oracle\\product\\10.2.0\\db\_2)
(PROGRAM = HSODBC)
(ENVS=LD\_LIBRARY\_PATH = C:\\oracle\\product\\10.2.0\\db\_2\\LIB)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oradev.hct.org)(PORT = 1521))
)
configure tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oradev.hct.org)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
mysql=
(DESCRIPTION =
(ADDRESS=(PROTOCOL=TCP)(HOST= 10.153.103.5)(PORT=1521))
(CONNECT_DATA=
(SID=mysql)
)
(HS=OK)
)
create initodbc.ora file in hs folder
HS_FDS_CONNECT_INFO = mysql
HS_FDS_TRACE_LEVEL = OFF
restart the listner,
tnsping
C:\Users\Administrator>tnsping mysql
TNS Ping Utility for 64-bit Windows: Version 10.2.0.5.0 - Production on 08-NOV-2
015 13:02:52
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
C:\oracle\product\10.2.0\db_2\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS=(PROTOCOL=TCP)(HOST= 10.153.103.5)
(PORT=1521)) (CONNECT_DATA= (SID=mysql)) (HS=OK))
OK (0 msec)
create the odbc connection for Unicode
the test is successful
now I create the dblink
create public database link mysql connect to cssDBTeam identified by oracle using 'mysql';
then try to select from a table inside MySQL database
SQL> select * from appeal@mysql;
select * from appeal@mysql
\*
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from MYSQL
how could I fix it?
thank you.