Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 at 0:33
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.