Linked server querying error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Working with Oracle » Linked server querying error

Linked server querying error

Rate Topic

Display Mode

Topic Options

Author

Message

rayan98

Posted Thursday, January 17, 2013 4:03 PM

SSC Journeyman

Group: General Forum Members
Last Login: Saturday, April 06, 2013 12:57 PM
Points: 89, Visits: 220

Hi guys, recently i need to start to look after some of the linked server query . i got a instance of SQL 2005 and linked over to oracle server. i can run the pl-sql on the server without a problem (the query returns 200000 rows) on sql plus* in my local machines (the result come back within 25 sec) , when i ran the same query through linked server, it has no responses for about 25 minutes and sometimes it came back the error messages .

here are the followings :
OLE DB provider "OraOLEDB.Oracle" for linked server "REB_REPSER" "ORA-03113: end-of-file on communication channel

OLE DB provider "OraOLEDB.Oracle" for linked server "REB_REPSER" returned message "ORA-12592: TNS:bad packet".

but if i run a query which return less than 3000 rows, it brings the result back without a problem .

i have look into different options on linked server setting (and i tried to modify the timeout) without any luck.

anyone came across this error before ? and how do you solve it ? or where should i start ?

please let me know if you require any more information ?

i really appreciated with all your help

many thanks

Post #1408655

« Prev Topic | Next Topic »

Permissions