Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5746
  • Last Modified:

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)
     )
0
monosodiumg
Asked:
monosodiumg
  • 2
1 Solution
 
schwertnerCommented:
Possibly you miss some of these steps;
http://www.dba-oracle.com/t_connecting_sql_server_oracle.htm

Here is an article I wrote on Hetergeneous Services. In order to connect to SQL*Server from Oracle, you must do several things:

1. Install ODBC drivers for the SQL*Server database. The drivers are installed on your laptop or on
the server that contains the Oracle code tree.
2. Setup the ODBC connection on your laptop using the Windows ODBC Data Source Administrator
3. Test the ODBC drivers to ensure that connectivity is made to the non-Oracle database.
4. Ensure the Global_names parameter is set to False in the Oracle database.
5. Configure the Hetergeneous services. This consists of creating an initodbc.ora file within the Oracle
Oracle database installation.
7. Modify the Listener.ora file on the database installation to connect to the Oracle instance and ODBC drivers.
8. Modify the Tnsnames.ora file to point to the proper code tree.
9. Reload the listener
10. Create a database link on the Oracle installation.
11. Run a Select statement for the Oracle installation using the database link.
0
 
monosodiumgAuthor Commented:
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>
0
 
schwertnerCommented:
Thanks!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now