Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ORA-12592: TNS:bad packet or REB_REPSER ORA-03113: end-of-file on communication channel Expand / Collapse
Author
Message
Posted Friday, January 18, 2013 2:49 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 12, 2014 9:17 AM
Points: 93, Visits: 275
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
Post #1408773
Posted Friday, January 18, 2013 11:10 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
Root cause of the issue is that the connection is timing out.
Check sqlnet_timeout settings.


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #1409028
Posted Sunday, January 20, 2013 11:14 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 12, 2014 9:17 AM
Points: 93, Visits: 275
thanks for your help . will try to increase the timeout and see what happen for the query and see what happen
Post #1409292
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse