Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Oracle connection dropping and loss of connection to the network

Posted on 2010-08-20
7
Medium Priority
?
1,815 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 77

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 your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
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 77

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

Threat Trends for MSPs to Watch

See the findings.
Despite its humble beginnings, phishing has come a long way since those first crudely constructed emails. Today, phishing sites can appear and disappear in the length of a coffee break, and it takes more than a little know-how to keep your clients secure.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Getting to know the threat landscape in which DDoS has evolved, and making the right choice to get ourselves geared up to defend against  DDoS attacks effectively. Get the necessary preparation works done and focus on Doing the First Things Right.
In this article, WatchGuard's Director of Security Strategy and Research Teri Radichel, takes a look at insider threats, the risk they can pose to your organization, and the best ways to defend against them.
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…

618 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