Troubleshooting Oracle Link Server Issue

Posted in: Technical Track

If you remember, I posted some tips about troubleshooting Link Server issue for Oracle earlier. Today, I will be adding one more tip to the list. In other words, I will extend Troubleshooting Oracle Link Server.

A few weeks back, a developer reached out to me needing assistance with an Oracle Link Server. The issue for him was that whenever he executed T-SQL against Oracle Link Server, the SQL Server was giving him the error OLE DB provider “OraOLEDB.Oracle” for linked server “XXXXXX” returned message “Cannot start more transactions on this session.” I connected to the server using SSMS and checked the permissions, Link Server, and Provider configuration – nothing was changed. Then what could have caused this error? I will need to RDP to the box to find the answer.

After asking some questions, I came to the realization that developers do not have direct access to the box and were using Citrix to connect to the SQL Server box. Therefore, they would not have any idea of what was going on with the physical box. As a DBA, I had privileges to RDP the development box. As soon as I logged in, I noticed that the box was running out of space. The drive that was running out of space was hosting:

  • User Profiles
  • TempDB
  • & UserDB, which they were using for ETL purpose for Oracle

And, as expected, once I reclaimed some space, everything was back to normal.

Regards,
Hemantgiri S. Goswami

Interested in working with Hemantgiri? Schedule a tech call.

About the Author

I am a Database Administrator by profession, and a student of a university called life by heart. I am open and willing to learn things as it comes and is interest to me. I am passionate about SQL Server, photography, reading and sharing. During my professional life, I have privileged to work with some great a-like-minded people from whom I learnt a lot, technical as well as soft skills; I am trying and will continue to share what all I have learnt over the years by connecting a-like-minded via many technological forums.Currently, I'm Lead Database Consultant @Pythian. I have close to 17 years of experience, about which 15 years as hard core DBA. I have been a Microsoft SQL Server MVP for four years, and a published author of the book - SQL Server 2008 High Availability; a book for SQL Server DBA aspirants, System Administrators and Developers, it provides step-by-step information to get you through the installation of various SQL Server High Availability options like Clustering, Replication, Database Mirroring and Log Shipping. Sounds interesting, read more about me at http://www.sql-server-citation.com/p/about-me.htmlSpecialties: IT Project Management, SQL Server High Availability, Performance Tuning I have worked on IT Project Management using latest tools like Six Sigma, PMP and ITIL.Keep in touch with me: Twitter: https://twitter.com/ghemant Facebook: https://www.facebook.com/SQLServerCitation

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *