Posts Tagged ‘Oracle’

Oracle Gateway for SQL Server – General network error

February 28th, 2009 Comments off

Like many organizations, the company I work for needed to link an Oracle database to a SQL Server database. For various reasons I decided that we would use the Oracle database to pull data from the SQL Server rather than push the data from the SQL Server. This meant that an Oracle Gateway was necessary.

The Gateway install was painless and the setup was relatively easy. Within an hour I was running queries against the SQL Server through an Oracle database link. I set up various scripts to run autonomously in the early mornings and they were working flawlessly. The scripts were pulling entire tables and ran for between 3-5 hours.

After a few weeks the scripts began to fail intermittently with a “General Network Error” and a few weeks later the failure became constant. Below is an account of the fixes that were suggested to me by both the SQL Server DBAs, online resources, Oracle service reps and finally the steps I took to find the issue and the actual fix.


  1. Runtime before failure varies from between 1 and 30 minutes.
  2. Error:
    ERROR [NA000] [Microsoft][ODBC driver for Oracle][Oracle]ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Transparent gateway for MSSQL][Microsoft][ODBC SQL Server Driver]Error in row[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.

SQL Server:

  1. There are known issues with Microsoft’s Name Pipes Net-Library. This particular error has happened during SQL Server backup/restore operations, see KB827452.
    1. Make sure TCP/IP is enabled in the connection configurations screen so that the client can connect using TCP/IP rather than Named Pipes.
    2. Check the MDAC 2.8 version to see if it is 2.80.1045.0 or greater. You can find this value at registry entry: HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer.
  2. TCP/IP parameters in registry:

    1. KeepAliveTime=60000 (60 seconds)
    2. KeepAliveInterval=1000 (try every second)
    3. TcpMaxDataRetransmissions=60 (stop after 60 retransmissions)
  3. TCP/IP settings in the SQL Server Manager:
    SQL Server Configuration Manager -> SQL Server 2005 Network Configuration ->Protocols -> TCP/IP

    1. KeepAliveTime=60000 (60 seconds)
    2. KeepAliveInterval=1000 (try every second)
    3. TcpMaxDataRetransmissions=60 (stop after 60 retransmissions)

Oracle Gateway:

  1. In the gateway init file, inittg4msql.ora, add the following entry: HS_FDS_CONNECT_PROPERTIES=”timeout=’120′”. You can change the value, here 120, depending on your needs. This config value is not in Oracle documentation and is used to stop long running queries from losing connection.
  2. TCP/IP parameters in registry:

    1. KeepAliveTime=60000 (60 seconds)
    2. KeepAliveInterval=1000 (try every second)
    3. TcpMaxDataRetransmissions=60 (stop after 60 retransmissions)


  1. Downloaded a packet sniffer; wireshark (the best I’ve used so far):
  2. Filtered to see only traffic between the Gateway and the SQL Server.
  3. Ran the the script and monitored the traffic.
  4. I noticed a lot of lost packets and data retransmissions.
  5. At intermittant times there is a 30 second lag and the SQL Server reset the connection (the KeepAlive setting was still 30,000).
  6. I ran a ping test to the server with 5600 btye packet to see if this was a network layer issue:
    ping -t -l 5600 [ip addres]
  7. The test revieled 20-40% packet loss, which is unheard of.
  8. After contacting the Network team the SQL Server DBA was told to change a setting on the NIC.
    LinkSpeed/Duplex from Auto/Auto to Full/100

The NIC settings fixed the network issue and the scripts are passing with flying colors.

Hope this helps.


Categories: Development, Oracle Tags: , ,
  • e reader download for android
  • xperia arc s android games download
  • android latest version download
  • android download image from web
  • android download youtube videos offline
  • htc wildfire s android market download unsuccessful
  • my verizon android app download
  • android apps software download
  • download android market onto computer
  • games for download for android phone
  • google play apk download android
  • gameboy advance roms android download
  • android could not download error 498
  • android os download samsung galaxy
  • slide screen android free download
  • gps igo 2011 download android
  • alchemy download android for computer
  • kostenlos android downloaden
  • firefox for android download to pc
  • perfect keyboard android free download
  • rainbow 6 shadow vanguard android download
  • real player android download free
  • android market download apps to pc
  • htc android transfer photos
  • penetrate pro android app download
  • kindle ebook reader software for android
  • alk copilot 8 android download
  • minecraft for android phone download
  • android market download samsung galaxy s3
  • download gtalk for android tablet
  • android evo 4g driver download
  • lg android update download apps
  • pokemon gba roms for android free download
  • samsung android composite adb interface download
  • 4760827171
  • best app to download music on android
  • download flash player android free
  • download android asphalt 6 free
  • 2327365934
  • devil ninja 2 free download for android
  • download gameshark gba android
  • android apps apk file download
  • android music download apps legal
  • android download mode or recovery mode
  • android vpn apk download
  • android download file notification progress
  • android tablet driver download
  • android sdk tools version 4 download
  • dead space 2 free download android
  • swiftkey x free download for android
  • 2810274502
  • navigation android download apk
  • aplikasi android download video youtube
  • download de sons de armas para android
  • full tilt android app download
  • android sdk windows download free
  • android emulator for eclipse download
  • free rpg games download for android
  • 2go mobile download for android
  • android app download full music albums
  • android where are downloaded apk files stored
  • facebook untuk android download
  • free study bible download for android
  • top 10 android music download apps
  • air for android download apk
  • download all files dropbox android
  • android games apk download pc
  • download game revolt for android
  • aktualizacja androida lg gt540 pobierz
  • android jelly bean download free
  • 4782173999
  • android app download to computer
  • android market download x10 mini
  • android sdk windows vista download
  • android gingerbread samsung galaxy s download
  • quake 2 android full download
  • android fifa 10 wont download
  • android laptop software download
  • download film dari hp android
  • game download sites for android
  • speedx 3d android download apk
  • adobe create fillipino android download
  • download mp4 movies for android
  • gry android do pobrania za darmo
  • htc clock android download
  • turbo downloader android market
  • download status bar android
  • wpa calculator download per android
  • free bollywood songs download for android phones
  • free movie download sites for android tablet
  • speed download manager for android
  • mp3 cutter free download for android mobile
  • netflix for android tablet download
  • android app development and design download
  • 2556637336
  • android terminal reboot download mode
  • gameloft free download mobile games android
  • fast music downloader for android
  • download editor de fotos para android
  • android sdk download too slow
  • fight games heroes android download
  • download manager for android apk
  • diner dash 2 free android download
  • metal slug 3 download android gratis
  • android games download free for mobile
  • adobe air download for android
  • free online game downloads for android phones
  • free download android nokia c7
  • download internet explorer 8 for android mobile
  • my country game free download for android
  • how to download android market on tablet
  • free music download for android legal