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: , ,
young teenie girls covered in cum
  • to fuck my girl
  • naked girls gone wild
  • cream pie anal sex orgy
  • sexy ebony suck cock Oral sex lesbians
  • kamsutra sex videos
  • black chicks on white guys gallery
  • Woodman streaming teen
  • fuck my girlfriend for cash pictures of young beautiful teen ass
  • amuteur curve ass gallery
  • very taboo sex video
  • young nude girls no ratings yet
  • free fulllength black sex vids india girls ass star buffy davis gallery
  • trixie teen anal
  • redhead anal fuck machine cumshot
  • japanese hardcore forced
  • smut slut video blowjob
  • pastie pics of diaper girls
  • fucker asian anal
  • big butts ass girl
  • 9012151021
  • user submitted homemade older mature videos
  • asian thumbs sexy plus size chicks vintage young nude pics
  • old young thumbs
  • mature saggy tit sex virgins of girls videos droid x retro amateur Teen lesbian orgys shaved pussy phhotos erotic Beautiful caley ass ravaged by a big black cock hiv transmission oral sex
  • nude with big pussy
  • real female orgasm free video Epic big boobs
  • girl farting videos
  • young girl bikini lingerie model pics ugly young hairy pussy movies
  • chyna whyte big black ass
  • twain sex video
  • free minutes movie monster
  • wwe diva pussy
  • famous reverse gang bang video
  • 8536390761
  • Girl pussy photos ebony women live webcams l pussy s work out make movies
  • topless beach lesbian
  • spreads pussy lips
  • free moviel giant dildos pussy
  • free erotic pics of sissies
  • mature business women xxx slave pussy caning
  • black lesbian grls
  • 1307207610
  • hot sexy native american indian babes Old man licking pussy
  • free puerto rican girls sex
  • little ladies fuck galleries
  • 9287258866
  • 2733932395
  • little girl sex home video
  • You spin me round orgy
  • facial free pics
  • australian teen pics
  • happy teen couples asking girlfriend to fuck a girl
  • hpv in young girls
  • femdom easting pussy
  • christina aguilera young girl
  • topless paki girls
  • boys abuse milfs pussy slutload Classic lesbian videos
  • Anal sex lubricants
  • black softcore movies
  • free anal sex stories or fiction
  • little girl and big dicks
  • young fucking girls tubes slut mature videos
  • free nude young jailbait videos
  • anime fuck videos lesbian bad girl tits seattle swingers seeking men foe sex erotic dancing
  • girl pictures in the stands
  • priyanka chorpa in bikini pictures
  • interracial pussy licking pictures
  • 7190929838
  • hairy fat black pussy
  • high society girls naked
  • top rate movies blacked wife tubes
  • Teen orgasm pics
  • stories of young girls getting fucked
  • lesbians with big boobs humping videos
  • amateur free streaming sex
  • free lesbian big boobs videos
  • free swingers homemade video
  • of girls having sex
  • free true wife sex stories
  • free muscle exotica splits video
  • petite teenage gangbang
  • fbb sex video
  • cum pussy blowjob tits tight shorts ass cheeks pussy shorts
  • naughty college school girls movies
  • Onyx black vagina finda
  • batman sex pics
  • laure manaudou pics naked
  • pics of beyounce ass
  • young teen photo models portal
  • free bikini face sitting movie galleries
  • movie statistics in japan
  • young scolla escaping reality blowjob in confessional video
  • 4125812107
  • closeups of little pussy
  • free amateur sex japanese
  • biggest tits videos
  • japan schoolgirl ass
  • 2247034725
  • fre teen couples fucking vids black cock babes
  • teens fuck on parents bed
  • white girl xxx
  • very young naked black teens
  • free amateur and home videos
  • couples seduce teens tanner
  • real teenage girls
  • black man with two dicks
  • pussy eating close up blonde
  • college volleyball ass pictures
  • teen hot myspace pics
  • rebecca romaine stamos pussy
  • muture ass pictures
  • Teen bodybuilding girls hot hardcore video thumbs old sex pictures
  • little school girls pussy witn dick
  • 867199777
  • sprite oral sex commercial
  • Hot ass in dress
  • i mature sex
  • black girl dancing with panties
  • search erotic massage vids
  • Real young black pussy
  • young leafs vids petite tits
  • asian lesbian flash movies
  • online free sex movie
  • hitachi orgasm pics young black brutal sex
  • Kari sweets nude photos
  • teen girls flashing thongs
  • young girls seeking older men
  • hardcore anal prn
  • japanes sex toys
  • position vids wife
  • drunk babes at party
  • young nude girl model art pics
  • Lesbians sex toys free amateur mile age xxx old men fuck fat girls
  • young female butt
  • mimom mature videos
  • arab girls
  • young niaeve girls free
  • stories of wife first lesbian
  • extremely hardcore stars
  • big black dick in white chicks
  • naked girl tied to
  • free video asian dildo sex
  • free famliy guy videos
  • young girls jugs
  • interacial mature fucks young boys
  • florida state bikini girl
  • blonde norwegian
  • anal latex fetish galleries
  • xxx fake boobs japanese wife swapping stories amateur wives hot fuck find
  • jamie foxx sex video
  • sexy blonde sucking dick girl orgasim whill masterbating video wife in rio lesbian
  • rough group pussy pounding
  • black teens girls getting fucked
  • pussy fingering onyou
  • young facials asian daughters
  • mature lesbian erotic stories tela teguila sex video tiny young naked teens free instrutional sex videos
  • ptetty asian girls
  • blonde creampies videos girl snowballing guy pics
  • cum squirting black pussy
  • sexy naked hot celeborty pictures of young girls nipples
  • 5738874404
  • janome sew petite machine
  • bikini pictures britney spears
  • interracial anal vids mommys big ass galleries
  • wasted naked girl on vid
  • black tits videos