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: , ,
  • submissive wife erotic stories
  • human sex position video
  • do girls really like anal
  • extra hardcore porn
  • young teen voyeuers amateur free
  • pornstar yuri komuro pictures
  • Mutual masturbation female
  • xxx asian babe ass
  • teen babes pics gallery
  • big juicy black tits
  • grampa oral sex on gramma
  • twi lek girls porn
  • hot sexy white babes pics
  • couples caught in the sex act
  • girls hair pulled while ass fucked
  • teen couples video galleries
  • japanese tv reality shows
  • big black cocks white chicks
  • shaved brunette hot free video
  • amateur girl gets fucked
  • Zac efron sex pictures
  • angelina jolies sex scene video
  • video sex matuer
  • pussy dolls xxx
  • two girls and a dick
  • old man bangs teen girl
  • crazy bitch stripper video
  • free xxxbbw amateur pics
  • watch other men fuck my wife
  • s ass picture
  • young petite pics
  • Best way to lick pussy
  • gary colemans wife leaked pictures
  • Masturbation home page
  • hardcore sex hardcore movies
  • tan shaved dick
  • blistered butt movies
  • bottomless girls pics
  • big phat pussy and ass
  • women with very small breasts xxx
  • Naked sexy grannies
  • couples seduce the babysitters porn
  • free deep throat bbw sex movies
  • big butt bbw porn sites
  • worlds best breasts pics free
  • teen sex with russian milf
  • ideal teens sex party
  • fuck me and my mom video
  • Fun graphis for teens
  • Sex hard photos
  • eve longoria topless photo galleries
  • webcam pictures girls
  • young blonde boy
  • Sex latina video
  • girls with toys x xx porn
  • sexy feet on pussy
  • cute anal movie gp
  • black teen taking a shower
  • water orgasm movies free
  • latin women breasts videos
  • tiny teen interracial tube
  • free hardcore lesbo movies
  • blow job sex housewife movie
  • blonde big tits black cock
  • Sexy and nude girl
  • free naked teen pictures
  • eldres fuck tube videos
  • nudes young girls and boys
  • naked jewish girls
  • young babes pussy pix
  • mature breasts videos
  • ass music videos
  • hot blonde lesbian movies
  • petite females and cortisol
  • sex blonde ass
  • super dick porn pictures
  • porn movies free thumbnails
  • Sex black girl video
  • young beauty nude
  • Amateur cum swallowers
  • free pics black gang bang
  • carttoon girl porn
  • driveway black picture
  • girls and s fuck
  • My sexy girl
  • black ass fucking and gagging
  • long streaming sex videos
  • facial compilation video
  • girls being abducted on video
  • webcam girls site
  • videos x extrait film amateur
  • Kristina anapau sex scene
  • pornstar masturbation videos
  • sexy milf anal hot
  • sexy asian chicks stripping on video
  • nn teen girls video
  • bikini milf video
  • amateur online club wives
  • inari vachs pussy toy
  • x nude sexy bikini lingerie topless
  • stacy dash sex video
  • naturism young couples gallery
  • handjob into pussy
  • Fucking the ass
  • girls fingering them selvs
  • pakistani girls sex videos
  • you porn lesbian in car
  • naked girls animation
  • ebony porno star name list
  • Amateur teen pics
  • Indonesia sex movies
  • petite softball teen loves sex
  • mature rides younger
  • big tits teachers sex ed
  • Tiny girl fuck
  • hot couples sex videos
  • Show girls boobs
  • chicks choking on dick
  • Hairy pussy cutties
  • anime show sex movie
  • massage parlor girls video
  • hottie teen pics
  • ebony black orgy
  • Girls mooning ass
  • holland hardcore sex
  • teens lesbo fun blonde pussy
  • naked pics of kelly kelly
  • japanese pain porn flash movie
  • wife swapping party pictures
  • big black clits xxx
  • girls taking huge cock anal
  • porn pics of girl teens
  • big pussy orgasm video
  • pictures of japaneese girls
  • pussy cock piercings
  • very young naked lesbian
  • shes too young movie cast
  • sex movie post directories
  • blonde tight teen slutload
  • tight pussy hentai
  • Fucking bloody pussy
  • mature young babe
  • puerto rican girls interracial
  • lesbian hardcore porn stories
  • girls with tattooed butts
  • real amatuer girlfriend porn
  • try asian teens video
  • sex charges davidson county nc
  • natalie black hq pics
  • boys very young videos
  • japanese on black cock
  • all black hardcore
  • Madonna nude photo
  • ugly girls nice boobs
  • young looking but legal sex tubes
  • tied down teen sex cideos
  • fuck yemeni girl
  • Teen savannah shower
  • sarah fergeson naked naked royal pictures
  • free videos of ass to mouth
  • blow job fuck pussy cunt
  • free lesbian dominatrix porn mature young
  • jiggly black tits
  • teen upskirts school girl
  • young college couple fuck
  • Sex images of trisha
  • best nurse porn movies
  • girl lick dick clean
  • teen girl cumshot movies
  • insane blowjob movies
  • lb girl naked
  • nude high school girl anal mpegs
  • ggirls having sex
  • waitress movie gang group sex slutload
  • Srilankan hot girls
  • jennae dess sex video
  • girl with pencils in pussy
  • most hardcore porn vids
  • wow blood elfs naked picture
  • very sexuall pictures of girls
  • black teens giving head
  • girls nipples in tee shirts
  • young free ass gallery
  • redhair pussy tits porn video free
  • blonde fucking free movies
  • horrny young teens
  • savannah free porn vids
  • tiny blonde teens sex thumbs
  • youngest tiny pussy
  • good white pussy
  • young blonde teens braces fucked
  • Big tit galleries
  • black asian armoires
  • amateur screaming orgasm videos
  • how to orgasm give video
  • pussy squirting torrent
  • Pretty girl why
  • lisa nobles sneed likes anal sex
  • asian girl with big boobs
  • sexy anime girl virgins sex
  • pics gallery trailer perfect ass
  • shemale spunking pics
  • videos eva angelina camella lick
  • spurting orgasm video
  • porn stars free pics movies
  • sexy asian granny
  • Parent directory orgy
  • the petite cafe new jersey
  • japanese very young girls
  • spy naked woman pics
  • famous pictures and farmer and wife
  • free porn video houston
  • online movie japan
  • girls dirty feet videos
  • young bubble utt babes
  • asian anal fuck videos
  • mr chews asian beaver porn
  • my girlfind sex
  • modeling sign up for young teens
  • red head bikini pictures
  • white cock into mommies pussy
  • Fuck girl pics
  • girls shitty ass
  • pornstar samie sparks videos
  • public fuck party
  • naked in movie time duratio
  • girls with both dick and pussy
  • bikini sheer galleries
  • Billie piper sex scenes
  • two hot girls naked
  • rate my wet pussy
  • black male cocks pics
  • black beauty being nursery
  • handjob by doctor free video
  • teen swim sex video
  • crazy wild girls videos
  • free milf handjob gallery
  • fat amateur porn girls
  • spandex porn videos
  • free hairy pussy retro video galleries
  • teen erotic travels
  • girls having sex with aniamls
  • famous young black male actors
  • bgi tits sucking dick
  • celebrity nude sex photos and movies
  • weing party porn
  • finger wife pussy sleep
  • young girl tricked into fucking
  • milk and speculum in pussy
  • Accidental interracial creampie
  • Marge simpson naked porn
  • black mellon tits gallery
  • naughty allie blowjob videos
  • harry potter naked free pics
  • big boob hardcore sex
  • mega gang bang porn
  • paled her tight ass movie
  • Naked pregnant girl
  • free xxx porn no credit card
  • pussy only pics
  • hardcore wierd and extreme sex
  • nice naked girls outdoors no porn
  • softball girls suck dick
  • Japan nude in public
  • family porn xxx
  • ass licking girls and men
  • playing with young teens dick
  • japanese old and young lesbian sex
  • free videos girls in underwear
  • naked mixed sower movie
  • greatest sex scenes in movies
  • Nude katrina kaif videos
  • free tary young teen sex pics
  • deep fingering pussy close ups
  • anal gaping assholes videos
  • free porn fucking a sleeping girl
  • candid black teens
  • ebony cherokee pornstar
  • free britney spears fake sex video
  • real boobs pictures only galleries
  • asian girls anal sex galleries
  • Rear entry sex pictures
  • little girl in japanese
  • naked young uniform wearers
  • black teen thong models
  • sissy blowjob gallery
  • Young blond pussy
  • i dont lick your girlfriend lyricks
  • rico strong in ebony dymes videos
  • hairy red pussy
  • g strings babes pictures
  • Ejaculating inside the vagina
  • busty brunettes movies
  • sexy super skinny chicks
  • petite anal sluts in public
  • girl celebrities sexy
  • sex ass ass
  • tiny young babe sexy
  • Tamil sexy teens
  • teen black grils
  • thick white girl pics
  • really young girls girls pussy
  • girls sexy pets s
  • black vaion porn tube sex
  • Massive cock tiny pussy
  • eva porn videos
  • hentai girls getting anal
  • lesbian beats up and fuck lesbian
  • hrny mature pussy
  • free amateur young teen porn
  • girls drunk and naked
  • jessica burciaga naked pics
  • asian large breasts nude video
  • Teen titans feet
  • anal xxx free videos
  • erotic halloween costume pictures
  • pictures of the envirment of japan
  • high school teacher fuck movie
  • pussy with a baseball bat
  • women clothes stripped off fuck video
  • free young pinoy sex videos
  • sexy photo girls
  • Lesbian big breast
  • japan wife swinger video
  • rough teen fucking threesome
  • bound movie tits
  • girl big tits thong fucked
  • georgina smith sex movie
  • free hardcore stag movies
  • teen girls thogs
  • wifes home sex video
  • blonde teen orgasme squirt
  • over and pussy
  • girl loose virginity video
  • anal asian tubes
  • horny girls and huge dicks
  • review showtime petite rotisserie
  • Chris brown nude pictures
  • Pamela david nude video
  • Norwegian girl porn
  • nn hot teen girls
  • tia carrere naked pics
  • free english sex movie site
  • teenage girls pissing vids
  • rough sex painful anal sex
  • galleries mature movies
  • panties and skirts and young girls
  • sexy blonde anal
  • sexy asian creampie
  • young ebony girl posing nude
  • gag asian porn
  • white girls taking large black dick
  • petting your mature neighbors pussy stories
  • teen schoolgirl ass
  • pics at beach of girls
  • pumped pussy fucking free
  • my wife sucked my dick
  • young teen orgasm sybian
  • chicks want dick
  • asian lesbian orgasms
  • free pics sexy naked hunks studs
  • triple anal porn
  • nude wife free pics beach outside
  • moms suck that dick
  • Naked girls in the woods
  • gersman wild swingers video
  • xxxtube sex site
  • tight perfect ass pics
  • Black teen getting anal
  • sexy boy shorts girl poster
  • Teens gang bang
  • connie vannett pussy
  • petite crochet sweater
  • lisa sparxxx screw my wife
  • naked naughty busty girls
  • mums teaching to fuck pics
  • Haley paige interracial
  • suck your own penis pics
  • next door moms amateur porn pics
  • pleasuring a girl without sex
  • wife swapping porn videos
  • free videos of asian females masterbating
  • jezebelle bond bikini cavegirl
  • open asian pussy
  • erotic pictures of blowjobs