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: , ,
  • mr big dicks foursome
  • big tit anal teens
  • youny teen pussy pics
  • free young girl sex films
  • amateur selfshot video
  • asian sexy guys photos
  • nake girl asian
  • naked girl in suana
  • free xxx teen mvies
  • black pussy padgeant
  • pussy xxx sex
  • crack heads haveing anal sex crack
  • free young teens sexy video
  • naked girl in ducktape
  • fuck machine galleries
  • suzie carina interracial video
  • video young couple having sex
  • interracial massage bath
  • naked girls pool party
  • white wive black lover
  • pov titty fuck compilation video
  • erotic stories lesbian first time
  • old hairy teen chucky pussy
  • naked amateur wives girlfriends
  • chubby free tits video
  • i saw my little sisters pussy
  • sexy amateur sites
  • ms preety pussy by plies
  • Cristina ricci sex scenes
  • big tits anal sex pics
  • sexual therapy retreat for couples
  • amateur mature adult couples video
  • big black couples hardcore sex pictures
  • black camel toe pics
  • nude teen beauty newsletter
  • beauty queens gallery
  • celeb blowjob galleries
  • naughty girls flashing on spring break
  • share good hardcore videos
  • sex scenes swingers
  • free view of sex videos
  • naked toon lesbians
  • xxx young firts timers
  • close up pussy moviesw
  • black leather girls photo gallery
  • teen fuck whore
  • teen girls pussy for sale
  • free amateur video of nude women
  • Hot crazy sex
  • very very young teen lesbian galleries
  • pictures of men who have tits
  • teens topless pics
  • Bizarre sex movies
  • tori black anal dildo sex
  • naghty teen girls
  • pierce pussy tube
  • black graphy powered by phpbb
  • chord changes petite fleur
  • teen pageant nude gallery
  • monster ladyboy cocks fucking girls
  • Xxx indian pussy
  • wired for sex home video
  • free video preveiws
  • ebony galllery
  • Lesbian nude pictures
  • Tips on swallowing cum
  • do girls like blowjob
  • japanese girl stripped groped
  • amazonian tribe sex pics
  • glamour girls galleries
  • interracial home videos free
  • hot european pics
  • redhead pigtail teen sex
  • pictures wife slut
  • aline facial movie
  • erotic stories showing off wife
  • free butt massage sex
  • young boys nursing old tits
  • girls picture boards
  • Tiffany teen free prono
  • black male movie stars
  • footsie video sex
  • gauage movies
  • cum hungry star videos
  • young girl sighs lyrics
  • black women who fuck white guys
  • interracial asian websites
  • vivian porto shemale movies
  • gangsta thug eat my pussy
  • anal gangbang pics
  • art model teen girls erotic
  • sexual fantasy seductive erotic
  • Girl next door ass
  • teen nurse fuck
  • littlle teen squirters video
  • girls kissing girls video tubes
  • puffy nipples hairy pussy
  • free naked real teen girls
  • historias en el cuartel movie
  • reality sex video model vol
  • Balloon sex video
  • rate girl breasts
  • Pretty girls shitting
  • black capitalism a quantitative analysis
  • microfiber petite womens jackets
  • hot ass asian pussy lesbos
  • latin girl with big ass
  • is oral sex safe
  • naked andrews espn video
  • barely tits video
  • cecilia cheung naked pictures
  • super hot naked video
  • fucked up girl pics
  • boys and young girls sex thumbs
  • wives watch fuck
  • hot llesbians licking pussy
  • ugly pussy at campsite pictures
  • sex video post upload
  • black ass nigga
  • sexo anal con latinas
  • top animated sex movies
  • deutsche studen bei einer sex party
  • new video cherokee d ass
  • girl seduced by lesbian sex photos
  • free sexy naked teens videos
  • good pussy pictures
  • naked girl hottub
  • rwal amateur
  • blonde anal gy
  • Crazy girls fucking
  • pics your girls
  • sex joke picture
  • girls pointy nipples
  • free shemale webcam video
  • movies farce
  • search site hardcore
  • free babe closeup hardcore pics
  • milking breasts videos
  • Nude models
  • kim kardashian sex video metacafe
  • mexicon girls that like to fuck
  • ethnic sex party
  • Charisma carpenter nude pics
  • handjob amateur moviez
  • young chubby amateur blowjobs
  • free teen tight pants pics
  • hardcore lesbian s m
  • Xxx sex extrem
  • mature petite women nude
  • lick her
  • black asshole pics
  • woman sex wrestling video
  • ts shemale glamour hub
  • gag deep throat pics
  • youngest art models girls
  • best bikini gallery photos
  • free sex hardcore stories
  • Ass sexy photo
  • treatment inverted nipples teen girls
  • little white girls black
  • katrin kozy boobs video
  • hardcore hairy movies
  • egg plant pussy
  • threesome rules wife friend
  • fat penis and anal orgasm
  • sexy young lesbian pictures
  • prep ass far anal sex
  • discount petite tweed
  • free dana delaney fuck video
  • asian sex massage kihei maui
  • women seduce young girl
  • asain naked pics
  • cute little asian girls in action
  • naked teen gangbang videos
  • gunslinger girl pictures
  • orgasm while sleep vid galleries
  • Man sex girls
  • jasmine black star shoe size
  • free asian nurses video
  • pictures young men seduce older women
  • free mature christmas movie
  • free adult blowjob video
  • black dirty girl
  • kissing transexuals ass pounding
  • a lot like love naked pictures
  • dreamwiz cgiworld young girls nude
  • young girls queefing
  • Heidi klum nude photos
  • Sexy college girls dancing
  • cheerleader gang bang hazing video
  • mature granny xxx
  • proper pussy licking
  • girlfriend secret sex tapes
  • Hindi movie sex
  • dildo in pussy and gets orgasm
  • s fuck young daughters
  • abba girls naked
  • big tit blonde lesbian parents
  • teen girls object penatration
  • Big breasted blond
  • cute petite teen thong
  • very hot video
  • free black upskirts pics
  • girls gone wild fuck video
  • black slaves sex
  • orgasm teenie jelsoft enterprises ltd
  • outdoor pussy fucking video
  • free largest black sex movies
  • japan lisban