Solved

Oracle connection dropping and loss of connection to the network

Posted on 2010-08-20
7
1,765 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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Envision that you are chipping away at another e-business site with a team of pundit developers and designers. Everything seems, by all accounts, to be going easily.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

919 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

15 Experts available now in Live!

Get 1:1 Help Now