August 2, 2010 at 7:07 pm
I am currently working on sql server2008 and trying to fetch data from oracle 10.2 . when i right click on my linked server and click test connection it is success. Also when i m trying to fetch data my open query then also its is working . but when i am working ir with a procedure it works half the way and then give error timeout ORA-12170 error. Same procedure is working on sql server 2005 . data is very large and it takes 30 minutes minimum is this a problem. i have oracle also in providers.and checked active inprocess. I am not able to get out of this issue.
August 3, 2010 at 6:58 am
scottichrosaviakosmos (8/2/2010)
I am currently working on sql server2008 and trying to fetch data from oracle 10.2 . when i right click on my linked server and click test connection it is success. Also when i m trying to fetch data my open query then also its is working . but when i am working ir with a procedure it works half the way and then give error timeout ORA-12170 error. Same procedure is working on sql server 2005 . data is very large and it takes 30 minutes minimum is this a problem. i have oracle also in providers.and checked active inprocess. I am not able to get out of this issue.
Ask your Oracle DBA to check sqlnet.ora configuration file looking at SQLNET.INBOUND_CONNECT_TIMEOUT, SQLNET.SEND_TIMEOUT and SQLNET.RECV_TIMEOUT parameters. Chances are larger values are needed.
_____________________________________
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.Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply