Troubleshooting Oracle Link Server Issue

Posted in: Microsoft SQL Server, 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.

Hemantgiri S. Goswami

Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

Data Platform Consultant
I am a Database Administrator by profession, and a student at a university called life by heart. I am passionate about SQL Server, photography, reading and sharing. Currently, I'm Data Platform Consultant @Pythian. I have been a Microsoft SQL Server MVP for four years, and a published author of the book - SQL Server 2008 High Availability. Keep in touch with me on twitter @hemantgirig

No comments

Leave a Reply

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