Solved

Oracle connection dropping and loss of connection to the network

Posted on 2010-08-20
7
1,779 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
Surfing Is Meant To Be Done Outdoors

Featuring its rugged IP67 compliant exterior and delivering broad, fast, and reliable Wi-Fi coverage, the AP322 is the ideal solution for the outdoors. Manage this AP with either a Firebox as a gateway controller, or with the Wi-Fi Cloud for an expanded set of management features

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

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…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

749 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