Click here to Skip to main content
14,932,457 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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

1 solution

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>
   

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




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900