Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have created linked connection in SQL and by which I am connecting Oracle server using OLE DB provider "OraOLEDB.Oracle".

SQL Server = 2008 R2 Oracle = 10g

Normally, When I am executing Insert or Select query it works fine, but some times the same query does not execute well and failure. Same query If I execute again then it works fine.

The Error message is as below.

The OLE DB provider "OraOLEDB.Oracle" for linked server "ABC" could not INSERT INTO table "[ABC]..[M_SCM].[MY_TBL]". err src line: 23 SP_MY_PROCEDURE

Can any one suggest the cause of the issue? and let me know if any solution.

share|improve this question
are you using RAC on the Oracle side? have you setup the connection string correctly? – Nick Kavadias Nov 28 '13 at 14:05
@Nick, I am using Linked Connection not using RAC. and connection sting is correctly written. It is executing as per expectation daily but once in a month it fails thats why I want to fix this issue as my process is in automation. – Nitin Vijay Dec 27 '13 at 5:53
in that case my best guess is that there's a firewall somewhere between the hosts closing the connection after a timeout. – Nick Kavadias Jan 3 '14 at 0:33

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.