dear all,
i need your help, i want to access mysql database from oracle ,when i try to connect mysql database from oracle database i m getting the error shown below,kindly help your help will be appreciated,thanks in advance.
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 LINK2MYSQLTEST
oracle db:11.2.0.3 enterprise edition
os:win 7 64 bits
mysql connector odbc:64 bit
mysql db:5.1.19
os:win 2008 64 bit
odbc configuration on oracle server:
------------------------------------
data source name:test
tcp/ip server:ip address of mysql server
port :3306
user:oracle(mysqluser)
password:oracle
database:test
LISTENER.ORA:
--------------
# listener.ora Network Configuration File: D:\app\new_db\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_ORCLDB =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCLDB)
(ORACLE_HOME = D:\app\new_db)
(SID_NAME = ORCLDB)
)
(SID_DESC =
(ORACLE_HOME = D:\app\new_db)
(SID_NAME = tst)
(PROGRAM = dg4odbc)
)
)
ADR_BASE_NEWORCLDB = D:\app\new_db\log
ORCLDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
TNSNAMES.ORA:
-----------------------
TSTLINK=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST= localhost)(PORT=1521))
)
(CONNECT_DATA=(SID= tst))
(HS=OK)
)
inittest.ora($ORACLE_HOME/hs/admin)
------------------------------------
HS_FDS_CONNECT_INFO = test
HS_FDS_TRACE_LEVEL = OFF
dblink created from oracle to mysql:
------------------------------------
sql>create public database link link2mysqltest connect to "oracle" identified by "oracle" using 'TSTLINK';
sql>select * from "test"@link2mysqltest;
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 LINK2MYSQLTEST
kindly help.
thanks & regards.