How to resolve this SSIS connctions issue

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

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

Posted 4-Aug-14 1:43am

Member 10990249

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Arvind Kumar Chaubey · Answer 1 · 2014-08-05T21:04:00

XML

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>