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 hardcore streaming movies
  • pussy lickin teens
  • erotic stiletto pics
  • pretee bikini movies
  • mature shemale on girl
  • couples in phoenix az
  • sexy and naked images videos
  • topl pics teens
  • invite friend ffm video
  • naked picture of katie pery
  • amateur girls webcam video
  • free videos of hot babes
  • drunk wife sex ideas
  • tara moon anal video
  • wifes hairy pussy
  • busty blond handjob video
  • brazilian girls amatuer you
  • long tongue pussy lick
  • teen flashing
  • wife lesbian vid
  • pink wet hot wife sex
  • Black lesbians
  • naked naughty amateur girls
  • teen kasia hardcore video
  • slumber party with boys and girls
  • tiny teens free video
  • real son fuck pics
  • white girl ass
  • sexy mature nj women in nj
  • mature pussy with s
  • sexy amateur girls dancing and stripping
  • marvel video
  • best sex in movies
  • bouncing sexy breasts
  • asian slut video trailers
  • Ann hathaway sex scenes
  • japanese shemale videos
  • Pauline hanson nude pic
  • teenie girl panties
  • shemale hentai video free
  • yong girls videos
  • flashing vagina video
  • asian girl slapped his dick
  • Movie sex live
  • teeny weeny bikini gap
  • Porn black lesbians
  • black toy movies
  • sexiest words to call a girl
  • puffy tit bikini teens
  • shemale and female sex tube
  • maori girl pics
  • young teens research topics
  • free sex anal video
  • huge breasts gallery
  • blonde teen thin
  • Girls lick boobs
  • amateur self photo nude pics
  • vs human sex videos
  • lithuania videos
  • ebony teen sex stories
  • teen asian galleries bikini
  • dp anal tube
  • Indian boobs shows
  • cute blond bikini girls
  • teen sex thumb or gallery
  • hardcore free fake celeb
  • dvd amsterdam video netherlands
  • awsome teen sex video galleries
  • group sex tpics
  • teen titan sex stories
  • amateur group sex gallery
  • different shaped pussy
  • Hot and sexy girl video
  • Rock girls sex
  • oily anal sex videos
  • fuck that young virgin pussy
  • college video girls nude
  • naked young boys
  • the blue girl videos
  • hermaphodite sex pics
  • sex desire low after orgasm
  • louisville manor xxx
  • video bottle inside pussy
  • movie scene asian babe
  • nice lesbians kissing tits
  • Hot xxx nude
  • loose pussy teens
  • all black amateur movies
  • ji young baek sex tape free
  • teen lesbians at school
  • self pussy licking story
  • sexxy girl c ips
  • spank fuck that ass free movies
  • homemade mature videos
  • stockings sex thumb galleries
  • slut pussy close up
  • videos of black guys naked
  • huge cock sex big butt
  • anal gallery
  • most viewed video on internet sex
  • columbia girls xxx
  • free hardcore fuckin
  • young teenage pussy photos
  • brutal school girl fuck
  • jenna jameson pussy lick
  • Bad sexy girl
  • Angelina nude sex
  • ecstasy asian star
  • sexy teens nude photos
  • pictures of ahsoka tano naked
  • small breasted young girls
  • free amateur creampie movie
  • teen girls tied up video
  • black perky tit lesbians
  • petite teen sex gallery
  • anal sex chilli
  • first paid girl fuck
  • amateur video tied
  • naked pictures of tiffany amber theisen
  • he was stretching her pussy
  • Vanessa anne hudgens nude pic
  • video stars
  • Swollen itchy vagina
  • free lesbian huge tits videos
  • watch young girls govt charged
  • homemade videos fake tits
  • mycra pac long petite
  • sites using flash video
  • riley steele free videos
  • free fuck movies
  • Nude horny girl
  • Hot chicks with tits
  • peter cook video
  • erotic teens in fishnets
  • closeup pussy picture
  • asian impales pussy with dildo
  • pink shirt big boobs two girls
  • free videos young nude teen girls
  • true teen video
  • oral sex fears
  • screaming orgasm girls
  • flash cream video
  • teen forced anal creampie
  • feet galleries asian
  • on the beach oral sex
  • sexy lesbo cumshots
  • like im fucking the girl
  • wife flashing panties stories
  • Horny ass licking
  • couples sex class denver
  • fucking friends mom videos
  • can hardcore sex cause vaginal problems
  • Jennifer lopez naked pics
  • teen nude photo art gallery
  • hot men younger girls
  • naked girls showing there moves
  • real dominican girl fuck
  • off the boat asian
  • wife sex watch stories drunk
  • inflatable sex doll video
  • Lil sexy girls
  • asian model big boobs asian sex
  • graphic female orgasm videos
  • how to eat pussy natalie
  • free sex videos of fashion models
  • free xxx black dick mpegs
  • fuck my young ass
  • young topless model galleries
  • cleaner anal sex
  • very sexy teenage girls kissing
  • black booty teen
  • free real young teenage videos
  • hot mature eating pussy
  • pics of young filipina girls
  • ebony tranny ass videos
  • ass fuck da ho
  • movie orphan girl foster western
  • orlaith mcallister pussy
  • pussy peek shy
  • juicy danish pussy
  • analingus tubes
  • xxx pubic girls
  • pierced pussy girl squirting
  • unlimited free video web cams
  • Sweet little teen pussy
  • girls flashing compilation
  • school girl handjob compilation tube
  • free small breasted sex movies
  • nude photos of japanise girls
  • best teen thong amateur
  • the best fucking sex videos
  • horny lesbian teen
  • the paris hilton sex videos
  • dry anal video
  • asian girl smoking
  • sexy teens with bubble butts
  • Avatar sex videos
  • Jesica simpson nude pics
  • Closeup vagina pics
  • Best tits gallery
  • black cocks fucks white wives
  • wife loves pantyhose sex