如何解决此SSIS连接问题 [英] How to resolve this SSIS connctions issue

问题描述

我有一个MSBI应用程序。现在我们正在将这个应用程序从一个网络迁移到另一个网络。

在这里我们有一个SSIS包，我们从Oracle获取数据并通过SQL Agent JOB加载到Teradata。



现在我们在工作开始时遇到错误。



错误是：



描述：SSIS错误代码DTS_E_OLEDBERROR。发生OLE DB错误。错误代码：0x80004005。 OLE DB记录可用。来源：Microsoft OLE DB Provider for OracleHresult：0x80004005描述：ORA-12545：连接失败，因为目标主机或对象不存在。结束错误错误：2014-08-01 15：27：25.03代码：0xC020801C



结束错误DTExec：程序包执行返回DTSER_FAILURE（1）。开始于：3：26：47 PM完成时间：下午3:27:25经过：37.518秒。包执行失败。步骤失败。





你能不能请我帮我解决这个问题。





来自：
Madhan

解决方案

 
此问题似乎来自Oracle Rac。尝试以下步骤，看看这是否有帮助。 
 
 1）在本地tnsnames.ora中为每个节点创建LOCAL_LISTENER和REMOTE_LISTENER条目。 
 
 2）更新数据库中的LOCAL_LISTENER和REMOTE_LISTENER参数。 
 
 3）确保你的听众在做
 
 lsnrctl服务<  监听器   名称 > ;  

I have one of MSBI Application . now we are migrating this Application from one Network to another network.
In this we have one SSIS package and we are fetching data from Oracle and loading into Teradata through SQL Agent JOB.

now we were getting Error with job when job was started.

The error is :

Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "ORA-12545: Connect failed because target host or object does not exist ". End Error Error: 2014-08-01 15:27:25.03 Code: 0xC020801C

End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:26:47 PM Finished: 3:27:25 PM Elapsed: 37.518 seconds. The package execution failed. The step failed.


Could you please anybody give me solution to resolve this issue as soon as possible.


From:
Madhan

解决方案

Hi,

This issue seems to be from Oracle Rac. Try below steps and see if this helps.

1) Create LOCAL_LISTENER and REMOTE_LISTENER entries in your local tnsnames.ora for each node.

2) Update the LOCAL_LISTENER and REMOTE_LISTENER parameters in your database.

3) Make sure your listener picks both services while doing

lsnrctl services <Listener Name>

这篇关于如何解决此SSIS连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！