Oracle Connection Error After Successful Connection

[scottondata]

I am a little baffled here. I successfully connect to Oracle, preview the data, but as soon as I try to run the workflow, I get an error.

Preview Data:

Seconds later an error:

Error text: Error: Input Data (2): Error SQLDriverConnect: [Oracle][ODBC][Ora]ORA-12545: Connect failed because target host or object does not exist
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

I did nothing other than click onto the canvas after previewing the data.

[RolandSchubert]

Hi @scottondata ,

do you try to connect to a RAC?  If so, using OCI instead of ODBC and configuring a local listener could be a solution.  Doc ID 364855.1 in Oracle support provides some details.  

Best,

Roland