- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle DBlink connection problems on HP VM
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-19-2008 03:37 PM
тАО06-19-2008 03:37 PM
Oracle DBlink connection problems on HP VM
After creating a dblink, most normal queries work, such as "describe", or "select count", or "select * where rownum < 100". However, on queries where there is a significant amount of data transferred (such as a whole table), the connection sometimes hangs.
After running a network sniff, the (virtual) interfaces are exhibiting odd behavior. For example, there are cases of an acknowledgment (ack) sent 2 hours after the last data transmission.
This is very difficult to diagnose since the problem is very inconsistent. It works about 80% of the time, but then it fails, despite an underutilized CPU and network.
Has anyone seen problems like this, and does anyone have any suggestions?
Also, this problem has persisted across application (Oracle 9i), o/s (Tru64), and hardware (Alpha server) upgrades.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-24-2008 08:52 AM
тАО06-24-2008 08:52 AM
Re: Oracle DBlink connection problems on HP VM
This is quite weird. At the database server level, it really does not make any distinction between the type of interfaces.
Can you reproduce the problem easily?
Can you test the same with another oracle database which is not on an VM?
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-24-2008 09:22 AM
тАО06-24-2008 09:22 AM
Re: Oracle DBlink connection problems on HP VM
I was hoping someone had seen similar behavior. Part of the problem is that we are seeing a cascade of symptoms - where one error is causing another.
MORE INFO: After looking at the sniffer trace in greater detail, it appears the root problem is centered around a session that hangs after data transmission has begun. That is, we have a successful transmission, and the next session (5 hours later) starts just like the previous one and is looking normal, but then suddenly the guest server starts acknowledging the same packet/frame (a total of 10 times). Shortly after this, the guest and host server both time out, but the don't really drop the session, and it becomes "plugged" for the next session - 5 hours later.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-24-2008 09:25 AM
тАО06-24-2008 09:25 AM
Re: Oracle DBlink connection problems on HP VM
I've seen it too. It was a problem in getting data from a legacy machine using an 8i client to a 9i database. We NEVER resolved it, except by getting rid of the legacy machine. When we traced it, we saw exactly what you're seeing now. We ran code in debug mode with debuggers, etc, and could never figure out what it was waiting on, it looked good to us. Like you said, it was intermittent, but happened often enough to cause problems. However, it seemed to be independent of query return sizes.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-24-2008 12:15 PM
тАО06-24-2008 12:15 PM
Re: Oracle DBlink connection problems on HP VM
Thanks again.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-24-2008 03:38 PM
тАО06-24-2008 03:38 PM
Re: Oracle DBlink connection problems on HP VM
Considering that you've ruled out (????) your OS / network level delays.
What does the oracle session waits show on both sides? Do you have TOAD or a similar interface to browse sessions? If so check what the waits are, as that might give you a clue, whether there is something on the database which is causing excessive waits (log file sync / Enqueue / ... ).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-26-2008 07:28 AM
тАО06-26-2008 07:28 AM
Re: Oracle DBlink connection problems on HP VM
What they did in the end was make a custom ftp file transfer between the boxes and changed the process to batch oriented. This was to avoid using sqlnet. I was a good enough fix until we got rid of the legacy server just a few months later, and provided a more cumbersome, but more robust data exchange. We also considered ftp, using our own socket exchanges, etc. Since the programmers were already familiar with using nfs solutions for other old legacy database interchanges, they put in just one more to get us over the hump.