Solved

Oracle connection dropping and loss of connection to the network

Posted on 2010-08-20
7
1,759 Views
Last Modified: 2012-10-10
Ever since Wednesday June 9th, when a guy in our office tries to access large amounts of data from his pc to an external Oracle database via VPN between our corporate server and their corporate server
- the original fetch works fine - so he sees the first rows of data.  If he enters ctrl-end to fetch all of the data - his computer gets tied up -
eventually dies and he loses all connection to the network - groupwise, lan, etc.  The only way to recover from this is to power it off and restart.
He has been doing this for more than 10 years and nobody seems to remember a change that happened in early June.

He did at one point get the following error messages from Oracle
ORA-03135, connection lost contact
ORA-01041, internal error.  hostdef extension doesn't exist.
I do suspect that his connection is being dropped between the original fetch and the followup fetch.

I have done the following and discovered:
- it only happens when he access the DSS database via VPN - all local database fetches work fine.
- it doesn't pertain to his id - his id works from my pc and my id doesn't work from his pc.
- it is not software related  - it behaves the same with SQLdeveloper, SAS, Cognos, etc.
- it is not ODBC related - it behaves the same when using the Oracle Native Driver.
- it is not related to the version of the Oracle client he is using - I tested it out with two versions that we have here.
- I had his pc rebuilt and it still behaves the same.
- I moved his pc to my desk - and it still behaves the same.
- He tested it out on other pcs in the office and only one behaves the same.
- We traced the queries - one good and one failed and from the fireall all is the same for both, same service ports and same rules.
- Our ips are on the same subnet.

Has anyone experienced anything like this before?  I don't know what else to try.
0
Comment
Question by:KathysFriend
7 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33487810
When you moved the pc to your desk, did you still use the VPN software or were you connected directly to the LAN?

I'm thinking it might be a VPN timeout issue but I'm not a network person.
0
 

Author Comment

by:KathysFriend
ID: 33487822
I had our firewall guy trace a query that worked and one that didn't we are using the exact same firewall rules and ports and the SQLNet service is using a timeout of 24 hours.  We have the same network cards and drivers.  

The Oracle database is Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
and we have tried this with the 9.2 and 10.2 clients - both work for me neither one works for him.
0
 

Author Comment

by:KathysFriend
ID: 33487830
We both have to go through the same VPN - I successfully retrieved ~ 1.3 million rows back on our test today - he only got to 4200 when his network connection died.
0
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 
LVL 2

Expert Comment

by:j_coreil
ID: 33488805
I would check and ensure you are using the same listener. Within 11i, I've seen scenarios where different TNS entries behave differently because they were connecting to either different listeners or the same listener in different ways. It's actually a known bug.

Send both tnsnames entries so I can review them. Also send the listener.ora file if you feel comfortable.
0
 

Accepted Solution

by:
KathysFriend earned 0 total points
ID: 33703718
It was his network driver - it had to be updated to a newer version.

0
 

Expert Comment

by:my2boys
ID: 38483768
Hi, can you elaborate more on the network driver update that had to be done?  Do you mean he had to upgrade his Oracle Client?
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38484501
my2boys,

Welcome to the site.  Only Experts that have participated in this question and the original asker will be able to respond to your post.

Since this question is over two years old, if you have a similar problem and are looking to have it resolved, please ask a new question and our Experts will be more than happy to assist you.

You can even reference the link to this question and state that you are having a similar problem and need additional information.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
I recently attended Cisco Live! in Las Vegas, a conference that boasted over 28,000 techies in attendance, and a week of hands-on learning hosted by a solid partner with which Concerto goes to market.  Every year, Cisco displays cutting-edge technol…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now