Archive

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.

Symptoms:

  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:
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\SynAttackProtect

    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:
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\SynAttackProtect

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

Fix:

  1. Downloaded a packet sniffer; wireshark (the best I’ve used so far): http://www.wireshark.org/download.html
  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.

Rodger

Categories: Development, Oracle Tags: , ,
  • watch free porn videos online french
  • Sex incest price
  • video
  • free online teen girls porn videos
  • video
  • reality bites moulin rouge girls online
  • costa rica pussy pic
  • hot ebony videos online
  • video
  • transexual shemale online download
  • young girls in bathing costumes
  • free online lesbian group sex movies
  • hiv online video for teens
  • porn videos free online watching
  • horror movies online porn
  • video
  • sex videos at no cost
  • free online porn videos new
  • free online porn videos redtube
  • video
  • amateur muscle buys free pics
  • free online reality porn videos
  • porn vidoes onlinevideos
  • free online shemale video sites
  • watch movies online free erotic
  • plus size sexy farm girl costume
  • free online fingering videos
  • online porn videos free instant
  • mail order girls asian
  • sale womens petite
  • video
  • buy barbara dares movie harem girls
  • ebony xxx online vids
  • hardcore sex videos jizzonline
  • soft porn video online sybian
  • watch free online japanese cartoon porn
  • watch free online girl pink teenage
  • video
  • asian school girl costume
  • Asian teen mgp
  • free home costume sex videos
  • video
  • diaper sex videos online free
  • video
  • video
  • video
  • costa rica teens girls
  • video
  • watch online free indian sex videos
  • cheap mes oral sex toys
  • free online photos mature sexy ladies
  • young teen porn online for free
  • video
  • video
  • hiv online video for teens
  • erotic stories online lesbian
  • Watch sex and the city movie online
  • discount petite spring dresses
  • free online teen stripping porn videos
  • video
  • free online sex videos teens
  • mail order petite jeans size chart
  • pictures of naked costa rica women
  • free online digimon porn gallery
  • girl from greece movie costume
  • video
  • katie price stolen sex video
  • free online hardcore sex videos
  • cheapest prices hot latin pussy adventures
  • online blonde sex movies
  • blonde youmg teencum
  • free online loving sex video
  • video
  • teens halloween costumes for girls
  • fake tits online video
  • free vids of girls in costumes
  • costume ideas for teen girls
  • watch black love movies online freee
  • hard sex videos free online
  • lesbian mgp girls milfs
  • couples sharing online adult videos
  • free online porn girls having orgasms
  • video
  • asian teen lbfm mgp
  • video
  • rosaleen young schoolgirl
  • porn costume movies
  • oral video free online
  • video
  • online videos sex
  • free online amateur hardcore porn
  • real girls naked movies online
  • babes in naughty costumes pictures
  • video
  • huge nipples farmgirls
  • regular sex online movies
  • watch black girls get fucked online
  • online mature nude videos
  • video
  • video blonde shows online heat
  • americas next top pornstar online video
  • erotic online videos for women
  • free erotic movies stream online
  • ebony lesbian video online
  • video
  • video
  • free online fuck team video
  • watch free anal videos online
  • Public sex online
  • girls black bratz costume
  • online teen webcam
  • free hardcore porn mpges online
  • watch online free young girls porn
  • video
  • japanese girls for sale
  • video
  • larg object in pussy online
  • love sex videos online
  • lesbian porn free online videos
  • free online videos interracial kissing
  • free online pakistani hardcore porn videos
  • nude young costa rican girls
  • sexy erotic halloween costumes
  • tudor petite watch off sale
  • porn pics of katie price
  • watch asian sex movies online
  • buying porn movies online
  • free online sex video red heads
  • online free fuck video
  • video
  • online lesbian porn free
  • football player girl teen halloween costumes
  • free teen sex tapes online
  • Dress up sexy girls online
  • video
  • free webcam sex online private
  • Sex and the city full movie watch online
  • free online teen sex videos
  • older men fuckimg young girls
  • video
  • where to buy vintage porn movies
  • full lenth porn movies online
  • video
  • free online streaming sex videos
  • naked souls movie online
  • petite bateau baby clothing on sale
  • teen girls halloween costumes
  • watch free mature videos online
  • free online handjob movies
  • video
  • backstabbing bitches porn videos online
  • petite scrubs for sale nj
  • sexy costumes for large breasts
  • free online ass gaping videos
  • harcore fuck free xxx online
  • free porn videos watch online
  • video
  • Watch sex and the city the movie online
  • Sex teens online
  • bikini sale teen
  • free porn online video high definition
  • free online pictures of erotic massages
  • hot chicks in costumes having sex
  • video
  • costume sex partys
  • pussy pumping torture free online
  • Watch lesbian porn online
  • sex slave video watch online
  • hot asian lesbians online
  • video
  • online streaming porn tube asian
  • free ebony porn movies online
  • free online teens exposed porn videos
  • free online big dick porn
  • freexxx farmgirls movies porn
  • video
  • online gallery of russian teen girls
  • free online mature women xxx movies
  • free online screaming pain porn movies
  • full teen porn movies online
  • shemale fucks girls watch free online
  • free porn videos of virgins online
  • video
  • farmgirls having sex with s
  • video
  • sexy black girl videos online
  • free erotic sex stories online
  • video
  • young girls shoes wholesaler
  • free online videos of panties porn
  • Indian sex movie online
  • video
  • Sexy girls online
  • free indian sex online movies
  • watch free hardcore porn online
  • girlfriends sister porn video online
  • free girls gone wild video online
  • costume sex free pictures
  • american porn magazine online videos free
  • buy sexy black dress
  • Chinese sex movies online
  • free hentai online sex videos
  • cartoon free online porn video
  • better sex video free online
  • hairy pussy mgp
  • free porn online video high definition
  • sexiest babes imgaes
  • view online teen sex
  • colombia girl sex mgp
  • video
  • video
  • sex video mgp thumbs
  • video
  • milkmaids porn farmgirls sex
  • beautiful milf mature pussy hairy online
  • xxx black anal for free online
  • video
  • black porn online video
  • wild fucking free mgp movies amateur
  • black chics eatimg pussy
  • oral sex how to video online
  • indian porn video online site
  • video
  • wife order to suck cock audio
  • girl teenager halloween costumes
  • video
  • free online amatuer sex picture forum
  • free online softcore movies
  • best online porn videos
  • online porn movies for women
  • amateur porno stream online
  • group sex sites online wa
  • watch sex movies free online
  • petite cotton clothing sale
  • erotic porn free online for women
  • sex video online free
  • free online nude teen sex videos
  • video
  • best watching sex video online
  • free full video online lesbian porn
  • free online erotic videos
  • video
  • japanese black pine wholesale
  • free online passionate sex videos
  • online teenage girl porn site
  • buying amateur teen sex vids
  • hardcore videos online free
  • sexy businesswomen lesbians porn free online
  • young sex videos online
  • buy hardcore movies online xxx boxxx
  • buy dvds german mature xxx
  • sexy pin up girl halloween costumes
  • asian sex slaves sale gallery
  • complete sex movie online
  • buy softcore porn videos
  • video
  • video
  • girls black history costume
  • hot porn videos online
  • video
  • online sex slave forum webcam
  • video
  • video
  • video
  • video
  • teen titans nude free online videos
  • video
  • watch free online lesbian strapon sex
  • girl teen halloween costume wolf
  • online free movies sex
  • cheap naughty xxx babes
  • video
  • asian dvd movie wholesaler
  • free online anal videos
  • free too watch porn movies online
  • video
  • video
  • watch free porn videos online free
  • video
  • online sex reality show
  • online sex slave videos
  • watch free lesbian porn channels online
  • costume sex videos free
  • video
  • farmer and farmgirl sex
  • free online porn galleries
  • video online pornstar
  • watch online sex movies full
  • video
  • free online amature anal videos
  • rated x couples porn online videos
  • video
  • free pornstar online porn movies
  • free online porn movie redtube
  • video
  • video
  • video
  • free video little caprice cumshots
  • priceless girlfriend naked birthday
  • free asian sex video online
  • porn for couples online
  • beauty queens sextape online
  • amateur video my japanese wife cumminmg
  • free online porn vids flash player
  • costume porn online video
  • direct online porn video
  • free online porn girls having orgasms
  • online celebs sex videos
  • young teenies costume fuck
  • free online sleeping porn videos
  • free online sex vids
  • free online pictures of erotic mesages
  • asian teen pee mgp
  • video
  • free porn pics and vids online
  • free online porn movie tube
  • video
  • video
  • free online sex hardcore fucking videos
  • free online videos i porn
  • reality buy my wife porn tube
  • buy videos of way couples
  • free online sex party porn
  • free online pics of gie sex
  • free softcore adult movies online
  • online watch for sex movies
  • free online painful fucking porn movies
  • anal sex videos online
  • video
  • where to buy max hardcore videos
  • sex costume webcam
  • video
  • video
  • youngest teen porn online free
  • free online young porn videos
  • teen asian ass pee mgp
  • video
  • Jordan katie price nude pics
  • video
  • watch soft porn movies online fee
  • shemale with female videos online
  • free online porn mature movies
  • hollywood softcore online movies
  • virgin fuck movies free online
  • island caprice studio asian videos
  • fake naked pictures of megyn price
  • free oral sex video online
  • sexy cheap bikini
  • freee online erotic sex novels
  • free videos online about porn experts
  • free online video of sleeping beauty
  • girl in bumble bee costume video
  • video
  • mature sex free online tv
  • online free video indian sex sites
  • free asian porn online browsing
  • cheap petite size clothes
  • free online oldmen sex movies
  • video
  • full girls gone wild movies online
  • mature japanese maple trees for sale
  • free teen porn sex videos online
  • porn movie online video
  • video
  • video
  • free adult videos for couples online
  • found wife has fuck buy
  • sex positions pictures online
  • free porn video streaming online
  • video
  • video
  • porn videos onlines
  • ebony family porn online free
  • free black anal movies online
  • erotic massage online video free
  • video
  • video
  • free online porn girls
  • free online teen lesbian porn
  • online full length porn movies
  • free erotic stories online schoolgirls
  • video
  • free online xxx hardcore videos
  • video
  • video
  • video
  • free dating wives fuck buy
  • lesbian online sex videos
  • farmer wants a wife video online
  • girls shrek sleeping beauty costume
  • online movies downloads from japan
  • free online girl masturbating videos
  • video
  • video
  • teeny anal online watch now
  • video
  • video
  • video
  • video
  • free public group sex videos thumger