asked on

ORA-12569: TNS:packet checksum failure - Oracle 10.2 to MySQL 5.0

I'm getting this error when tnsping-ing the SID defined below. The ODBC connection MySQLTDSN works. How do I resolve the error?

TNSNAMES.ORA entry:
MySQLTDSN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MyPC)(PORT = 3306))
)
(CONNECT_DATA =
(SID=MySQLTDSN)
)
(HS=OK)
)

SID Listener:
(SID_DESC =
(PROGRAM = hsodbc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(SID_NAME = MySQLTDSN)
)

ASKER CERTIFIED SOLUTION

schwertner

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

monosodiumg

ASKER

1,2 done. 3 tests OK.
4 ok
5: see below.
7, 8: as per post
9,10: done
11: falls over.

I should have specified that I am using XE and the TNSNAMES.ORA file sits in the instantclient folder:
TNS_ADMIN=C:\instantClient
PATH=C:\oraclexe\app\oracle\product\10.2.0\server\bin;...
There is no ORACLE_HOME variable.

file initmysqltdsn.ora in C:\oraclexe\app\oracle\product\10.2.0\server\hs\admin:
HS_FDS_CONNECT_INFO=MySQLTDSN
#HS_DB_NAME=titan
HS_FDS_TRACE_LEVEL=ON
HS_FDS_TRACE_FILE_NAME=HS_FDS_TRACE1

#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

schwertner

Thanks!