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: , ,
  • asian enjoys movie
  • Indian aunties pussies
  • ebony lesbian strapon
  • black boobs australian
  • male using sex toy video
  • best full scene sex movie
  • Pictures of ebony girls
  • nude african girl galleries
  • real hot young girls
  • free sex gallery sites
  • free hugh cock anal
  • japanese junior idols bikini
  • teen group sex videos
  • blonde pussy wet
  • nude naked sexy photos tit pussy
  • spread pussy yoga stretches poses
  • Hot girl in shower naked
  • erotic free hardcore
  • ass hook galleries
  • my sisters pussy richard
  • greek goess of beauty having sex
  • email naked girls
  • movie thumb galleries
  • pussy org viedo
  • naked uncensered pics of hot olympians
  • gorgeous girls with hairy pussy
  • Croatian girls sex
  • asian girl cunts
  • tighest pussy amatuers
  • wild women and wild girls asian
  • black panther marvel pics
  • teen girl orgasims
  • spread pussy red tube
  • true teen babes picc
  • innocent teens gallery
  • eating little girl pussy pics
  • amateur interracial home videos
  • real naked girls under
  • white girls nipples
  • mature women spandex panties tgirl
  • teenage girl bible studies
  • big black ebony tits
  • Hot pin up girl
  • Persian girls xxx
  • mature xrotica demo sex
  • top ebony start
  • Hot sports girl
  • free bestial movies canada
  • hairbrush handel in a girls ass
  • fuck sleeping streaming video
  • Teen taking big cock
  • lesbians fucking young guy
  • free view movies
  • naked bald pussy pics
  • pics of naked cops
  • Granny movies sex
  • korean slut for black cock
  • young girls in little bikinis
  • teen twins fuck
  • free lesbian pussy movies
  • mature nude beach videos
  • heavy petting sex videos
  • final fantasy girls pictures
  • asian girl old man
  • barely legal black lesbian whores
  • tube teen free movies
  • forced celebrity sex in movies
  • school girl eskimo
  • black lesbian ass sex
  • free amateur all natural boobs video
  • naked sandra bullock
  • anal arab free movies
  • young teen cream pie eaters
  • xxx hoes mature
  • Bouncing tits movies
  • orgasm girl moan
  • danish amateur lesbians
  • young girls beach naked
  • Forced anal sex videos
  • Vaginas mas grandes
  • mayre lesbian on young tube
  • lesbian threesome bed double fisting
  • Teen blonde lesbians
  • extremely loose pussy lips
  • rihanna topless pics
  • girl pics
  • mature sexy mammas and daughters
  • hairy pussy hardcore
  • amateur college girl movies
  • schoolgirl uniform babes
  • voyeur movies
  • free nude skinny teen girl galleries
  • teen couple first fuck
  • xxx late night girls
  • brazillian wax pussy
  • best in black
  • muscled asian school girl pics
  • teen boys fuck durnk grils
  • Hot girls getting wedgies
  • tiny teen young video
  • interracial anal pics gallery
  • asian full
  • hard core teen pussy
  • beauiful womens pussy pictures
  • How to kiss a short girl
  • girlfriend recorded her orgasm for me
  • male star with a pussy
  • Closeup vagina pictures
  • Lesbian horny girls
  • teen blond bitch
  • ashlynn brooke fre movies
  • free made movies
  • office girl sex pics
  • Girl caught masturbating on camera
  • online star videos
  • petite women fucked
  • muscle contractions of an orgasm videos
  • free erotic lesbian spanking
  • shy girl shows tits on webcam
  • Adult hard sex
  • lick pussy pic
  • Hot chicks with big breasts
  • xxx shemale s
  • swinger party sex
  • top couples movies
  • michelle monaghan video big tits
  • amateur wife cam video
  • arab babes tube
  • Naked lesbian gallery
  • young malaysian for free
  • Cum shot pictures
  • safe flash video
  • sex teens sweden
  • Brown indian pussy
  • erotic black white photography oral sex
  • young guitar japan magazine
  • free videos ebony squirt
  • free movie theme sex movies
  • wet pussy china
  • Girl fucking video
  • sexy black girls naked
  • really young video
  • mature street sex tube
  • free young emo girls pussies
  • free erotic videos and sories
  • wife watching me suck
  • perfect tits petite
  • rolling stone topless pics
  • misty mundae pussy
  • free pics mature couple hardcore
  • butt fucking anal sex
  • old men younger girls
  • asian and lesbian
  • redhead cock pics
  • amauter fuck video
  • sex videos hub shemale
  • black and asian men fucking
  • breasts pussy video
  • Sex bed hot
  • free xxx shemale fucking men pictures
  • teen abed pics
  • incredibly sexy milf blowjob on amateur
  • free sex lingere gallery
  • naked bulma pictures dragonball z
  • free indian homemade sex movies
  • xxxbig tit video
  • william a black
  • cocksucker shemale girl
  • stocking wife videos
  • i free movies
  • hair black girls
  • oral sex guide
  • give me free pussy
  • fuck a moms hairy pussy
  • fuck teen filipina girls
  • b exploited black teen
  • tan teen gallery pics
  • free aisan blowjob videos
  • ebony girls being fucked gy
  • jason statham sex video
  • bi sexual photos mmf
  • little girl cartoon
  • elimination before anal sex
  • tiny sexy bikini pics
  • do my wife movies
  • pteen bikini model
  • free penny flame threesome videos
  • tall blonde cheerleader sex
  • reluctant wife threesome
  • hot to suck your own dick
  • naked pics of korean women
  • Pretty girl in french
  • Black lesbians lick pussy
  • little black slim naked girls
  • Inside the female vagina
  • naked girl msn
  • skinny young teen fucks
  • Funny poems for teens
  • Flavor of love girls nude
  • preganet anime sex movies
  • girls party dress pattern
  • free amateur dick pics
  • movies searsh
  • Asian sex movie
  • girls with breasts tits showing
  • hot girls strip and lick pussy
  • lesbian moms sex with teen daughter
  • ma petite maison
  • white girl takes an anal pounding
  • girl fingering guys ass
  • teen blowjob for cash
  • brandy farmer pics
  • guy accidentally fuck girls ass vid
  • Young asian nude girl
  • teen girl bulimia case study
  • photo girl japan
  • pussy love you
  • very young little girl teens videos
  • my boobs are so big video
  • petite sex spankwire
  • latina girl sex movies
  • big dick to fuck
  • black sex pix
  • self pics nude teen petite
  • mature hairy gallery
  • Ass licking whores
  • Richard gere sex scene
  • Girls sex bed
  • asian teen sex galleriws
  • petite pale girls
  • free analysis of young goodman brown
  • Porn blonde girl
  • slut wife having sex
  • spandex sex video videos
  • erotic japanese bathhouse painting
  • latina teens bikini
  • amateur free videos
  • nude women ass sex
  • free wet pussy and video
  • full length videos milfs huge tits
  • pussey expsed pictures unshaved closeup
  • redtube asian girls
  • fucking a teenage asian
  • girls pantie fingering
  • black cars gino movie
  • nudist beauty contest young girls
  • jennys blowjob pics
  • eat lesbian pussy
  • girls do gdp crystal
  • strawberry blonde videos
  • threesome pokemon
  • japan girl kissing videos
  • movie driverless black car
  • tube blowjob sex amateur
  • hardsex girl jerking off brother
  • leggy beauties gallery
  • black cock unprotected sex unfaithful
  • teen drag queen gallery housing
  • Asian naked girls
  • College girl masturbation
  • assparade girls pics gallery
  • free young pussy pictures
  • video sex latinas
  • straw blonde teen
  • nude young girls boys
  • Black chick lesbian
  • big black dick in mature
  • asian superstars xxx
  • lesbian anal strapon sex videos
  • upclose female orgasm video
  • hardcore stocking pics
  • ghost sex video
  • free long monster animated sex vids
  • white shemale movie galleries
  • bestial anal sex
  • nude sexy russian girls
  • red ass ladyboy movies
  • japanese softcore torrent
  • erotic club girls
  • free toon simpsons movies
  • bouncy boobs video
  • boy hardcore sex
  • cougar lesbians
  • real homeade ebony videos free
  • the sexiest interracial video
  • casual petite dresses
  • Indian sex websites
  • Girl licks her pussy
  • japanese anime girl pictures
  • retro blowjob gallery