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: , ,
  • free egorized porn vids
  • japanese amateur girl galleries free
  • factory girl sex
  • celebritys sex video
  • black girls prn
  • couples teachig teens
  • girls who want anal
  • hairy ass girl shitting
  • best hardcore sex video
  • lightspeed videos boobs
  • teen jerk off mpeg videos
  • free ebony nylon pictures galleries
  • Japan girls naked
  • Hottest lesbians videos
  • Nude amateurs teens
  • show your wifes butt
  • mature nipples pictures
  • video and daughter porn
  • Nude pictures of myself
  • black erotic woman
  • lesbian sex free no credit card
  • nude pussy pictures
  • lesbian anal sec
  • senior amateur nude women videos
  • free nude sex movie
  • asian shemale gallerys
  • highschool girls sex tape
  • cowgirl babes nude
  • Teen fucking trailer
  • gogreen fuck nude sex gogreen
  • Hot girls in tank tops
  • porn valley movie
  • free porn teen girls
  • hien camera sex movies
  • mother daughter sex pics stories
  • louise british girl naked walk
  • mature huge tits young stud
  • free black hair porn
  • asiann lesbian porn
  • free lesbo pussy
  • fuck the latino free amateur porn
  • free anal toy vids
  • trailer trash girls ready to fuck
  • girls swallowing cum videos
  • The movies nude
  • naked girls in short skirts
  • phat ass white girl porn
  • kelly rightsell petite playmates nursery
  • girls showering in bikini
  • girls one guy fuck
  • christmas dress for teen age girls
  • sexy girls in jogging pants
  • Pink kiss girl
  • erotic stories litle girls
  • asian ass movies
  • sexy mixed race girls
  • girls fucking with black men
  • ex orida cops wife porn video
  • youg pictures porn tube
  • descriptive oral sex poems
  • mature blojobs videos
  • japanese nude chicks
  • pictures of fingering females
  • chubbey naked girl
  • Strapon sex pictures
  • free pov blowjob videos
  • old lick pussy lesson
  • school teen sex
  • Free voieur teen
  • pics of amature cumshots
  • sex funny porn video
  • free naked anal sex
  • cheating college girl sex tubes
  • pocha girls japan
  • teen threesome schoolgirl videos
  • anal sex diagram
  • amateur twinks naked pics
  • Big fake boobs pics
  • strong black women divorce interracial statistics
  • venessa lengies ass pics
  • redtube mommy porn videos
  • mature lesbian vid free
  • college girls dicked porno photos
  • naked indiana girl
  • full video ghetto gagger skyy black
  • im kardashian naked pics
  • black ass pussy videos
  • all teen sex sits
  • latina sex threesome
  • free interracial porn video updates
  • exotic ebony pics
  • italian hardcore sex photos
  • anal sex fear
  • black dicks and white cicks
  • the predator movie porn
  • xxx mature cum facials
  • married couples seduce teens jessica valentino
  • Photos of nude ladies
  • Giant pussy videos
  • free mature cunt lip pics
  • video comdon sex
  • young ammature school girls fucking
  • latino erotic videos
  • redtube hot mature girls
  • hard amateur sex videos
  • video cute tiny young girl
  • shaved pussy shaved dick is great
  • g girls with sexy asses
  • young sexy couples having hardcore sex
  • Hot girl car wash
  • Big tits anal movie
  • shows pussy in public
  • black teen amateur video
  • free short erotic sex stories
  • girls fuck on kitchen table
  • interracial jail sex
  • shemale webcam huge cumshot
  • teens fun peachy galleries
  • grabbing a girls ass
  • Xxx girl sex video
  • tube porn extreme xxx
  • shemale pictures big cock
  • bikini girls on jet ski
  • young teen girls nude monique
  • brazilian teen facial galleries
  • squirt girls amateur
  • porn xtreme xxx insertion fat
  • beauty like a train wreck pictures
  • erotic lesbian kiss video movies
  • Teens with pigtails fucking
  • free sex fuck
  • amateur picture posting websites
  • tranny porn movies stars
  • th ward boyz and pussy
  • vivica rayy analyze that ass
  • wife panty flashing stories
  • asian anne pussy
  • young asian models in thongs
  • xhampster teen has sex in public
  • free celeberty porn pictures
  • wife for shemale
  • anal sex party video
  • mature lesbian ejaculation
  • mom teen girl fuck
  • black ghetto girls free pictures
  • nurse titty fuck porn
  • sex fuck movies aebn
  • amateur sex bed xlips
  • pictures of dance hall girls
  • free black boy gallery
  • Teen gangbang thumbs
  • hot mothers free videos sex
  • teen drunk sex videos
  • peeping japan girls
  • military wife cheating sex video
  • download mpeg porn video
  • Fuck that tight pussy
  • sexy threesome letters free
  • download free long sex movies
  • jennifer elison pussy
  • N dubz sex video
  • Two sex girls
  • black girls forced to fuck
  • short chubby amateur videos
  • wives pictures naked
  • free petite women sex videos
  • asian egg and rice video
  • free nude hairy miff pussy pics
  • sex video hip hop
  • amateur interracial cuckold porn free videos
  • xxx sexy young girls
  • teaching girls about gods beauty plan
  • Small teen tit
  • anime porn videoi
  • pictures of sexy lesbian breasts
  • free black sex movies pictures
  • stolen homemade sex videos
  • What do girls masturbate to
  • amateur videos of girls wet pussy
  • Hottest fucking girls
  • Teenage girls sex video
  • hot euro asian girls
  • big boobs anime lesbians
  • Scarlett johansson lesbian sex
  • ebony tube xxx
  • Kiss between boy and girl
  • black babes to eat
  • asian ameture teens youporn
  • la petite merveille
  • dies little fuck girl
  • men watch wive fuck
  • sexy young girls legs images
  • Youngest teen lesbians
  • asian japan jungle sex stories
  • bad girls nude sex
  • moms gissing young girls
  • alabama teen beauty pagent pierson
  • erotic nnude women free video
  • japanese young girls
  • porn hub ebony site
  • mature xxx hardcore vids
  • anal mature boy video
  • young pamela anderson topless
  • sex and teens videos
  • girls vs mature
  • Squirting teen pics
  • tinkerbell sex gallery
  • quality porn movie review
  • free sonic the hedgehog porn videos
  • young girls in pink panties
  • obama girl bikini zone
  • pussy hair color survey
  • a top teen girls porn
  • ll mini pussy
  • white cock asian girl
  • black porn stream
  • long nails hardcore sex
  • tamil actress shreya sex movies
  • sleeping girls sex movies
  • female self suck vids
  • black spunk pussy
  • amateur pictures wives girlfriends
  • vannesa hudgens naked pics
  • girls who want cam sex ays
  • Malay girl fuck
  • Ebony bbw girls
  • girl masterbating to porn
  • lipstick and pussy
  • The vagina video
  • legless girl fuck
  • mandy lightspeed hardcore partying
  • free fuck fest video
  • porn bad girls club
  • firm breasts pics
  • veronika simons blonde pussy video
  • Xxx boy girl
  • asian fuck video free
  • country girls flashing
  • horny teenaged girls
  • long school girl sex movies
  • young young sex pics
  • fatty porn pictures free
  • young teens having orgasm
  • paulina in focus girl sybian video
  • Tight panty teens
  • or butt sexual eduion
  • high quality hardcore gallery
  • Huge breast xxx
  • Spanish girls fucked
  • asian forced pussy
  • tan teen naked
  • Hot girl jpg
  • teens fuck thier s xxx
  • typical asian girl appearance
  • Sex lesbians kiss
  • hot naked petite women
  • videos cum on tits
  • tokyo japan harley davidson dealership
  • blow jobs pussy
  • ebony nerd porn
  • matureand young boy videos
  • holly madison naked pics
  • group sex agories
  • free porn full video ebony
  • lesbian orgasm scenes
  • young teens ass fingering videos
  • british girl sucking black cock xvideo
  • buckwild black girls free video
  • eat pussy how to
  • bookstore sex free porn movies
  • Wwe girls naked pics
  • sex japan free
  • women blackmaild and forced to fuck
  • teen dress sex
  • hot long anal porn videos
  • young school teen
  • Peach girl kiss
  • innocent girls stripped naked
  • emma watson anal porn
  • Male masturbation tech
  • vids of married couples making love
  • Hot girls indonesia
  • amateur adult video submissions
  • phat black booty flame porn
  • high hell babes pics
  • anal pantyhose pictures
  • hot latina sex movies
  • underground erotic sex stories
  • amateur fuck porn star
  • voir video porno amateur
  • fucking young gallery
  • teen gorgeous booty fuck
  • pussy butt boobs
  • sexy horny girls kissing
  • young female japanese porn star
  • mam and son porn videos
  • large boobs movies
  • sexy mature dildo
  • girls having panty sex
  • meet girls for sex in ohio
  • soft warm hairy pussy
  • Indian sex hot
  • free teen titans sex
  • wife pics index
  • asian big boobs beautiful pictures
  • cute little young porn girl virgin
  • sexy black ass being fucked
  • young virgin asian girls porn
  • amazing teen amateur tubes
  • Conflict theory on teen pregnancy
  • free thumbnails pictures of women butts
  • sucking shemale dicks
  • big tits thumbnail sex pictures
  • south african fuck videos
  • busty ebony girl
  • free female erotic movies watch
  • group sex asian
  • ebony sucking white cock pics
  • I want to watch sex movie
  • asian train porn fuck suck
  • latine porn facefucking facial
  • monster cock dick tits
  • from behind sex videos
  • Living with big boobs
  • cute girl gets fuck
  • naked very skinney teens
  • tits sex mature women free pics
  • ass xxx gallerie
  • Lesbian girl photos
  • young babysitter pussy
  • hardcore anal sex free sites
  • milking breasts pictures
  • Kristin kreuk nude pics
  • ameture young teen video
  • Big boobs of aunty
  • blonde porno stars
  • milf sex pictures
  • free videos sex chick een
  • huge black tits deepthroat
  • Girls naked masterbating
  • busty blonde teen fucking
  • young asian teen girls fucking
  • picture two black guys fighting
  • amai lui porn galleries
  • why lesbians love porn
  • girls on dicks
  • Nude videos of salma hayek
  • kinky hardcore sex big tits latinas
  • gangbang sex pictures
  • girl sex thumbs gang bang
  • young free porn gallery
  • free lesbian mature seduces young lesbian
  • lesbian sex experiment
  • cute blonde teen fuck
  • college girl tricked into sex porn
  • xrated stories oral sex
  • fat guy young girls
  • minor girls fucking videos
  • hot girls bent over naked
  • youngest teen sex movies only
  • nice pussy videos
  • very ripe latino pussy
  • ebony girl squirting
  • dairy queen little blonde girl
  • bald pussy videos free
  • young and fucked girls
  • teen porn pics torrent
  • how to have sex with girls
  • mature moms first anal
  • girl spanked naked front and back
  • naked black girls wight man
  • anime lesbians pussy
  • japanese girl masami pics
  • inexpensive teen girl furry jacket
  • rough teens fuck
  • mature young sex movies
  • closeup of a girls asshole
  • mature wives stockings
  • streaming ebony videos
  • petite teen o porn
  • ecrete amateur video
  • cosby girl turned pornstar
  • young black girl scarred by burns
  • pregnant girl pictures
  • exploited teens sex fucking
  • suck my pussy good
  • teen girls lesbian bikini video
  • long oral sex wife blowjobs
  • perfect pussy lips close up
  • Lesbian office girls
  • thin girl pics
  • ebony pussy that loves white cock
  • euro teen fuck trip
  • anal fuck sites
  • petite c cock
  • sexy asian cristal
  • teen couples sex tube
  • homemade teen ass fucking vids
  • Hot girl striping naked
  • old wives erotic pics