• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1826
  • Last Modified:

Oracle connection dropping and loss of connection to the network

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
KathysFriend
Asked:
KathysFriend
1 Solution
 
slightwv (䄆 Netminder) Commented:
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
 
KathysFriendDBAAuthor Commented:
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
 
KathysFriendDBAAuthor Commented:
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
j_coreilCommented:
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
 
KathysFriendDBAAuthor Commented:
It was his network driver - it had to be updated to a newer version.

0
 
my2boysCommented:
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
 
slightwv (䄆 Netminder) Commented:
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now