COPY ACTIVITY FROM MY LAKEHOUSE TO ORACLE DB

[DJMILES]

I want to move data from my lakehouse to my Oracle database in the cloud.


Error

Operation on target sampleSubscriberCopy failed: ErrorCode=OracleConnectionOpenError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to open the Oracle database connection. Source=Microsoft.DataTransfer.Connectors.OracleV2Core,''Type=Oracle.ManagedDataAccess.Client.OracleException,Message=ORA-12154: TNS:could not resolve the connect identifier specified,Source=Oracle Data Provider for.NET, Managed Driver,''Type=OracleInternal.Network.NetworkException,Message=ORA-12154: TNS:could not resolve the connect identifier specified,Source=Oracle.ManagedDataAccess,'

[v-yilong-msft · Accepted solution]

Hi @DJMILES ,

I noticed that your error message says “ORA-12154: TNS: could not resolve the connect identifier specified”.

This error usually occurs when an Oracle client cannot find the database it is trying to connect to. You can check out the official documentation below, which may be of help to you: ORA-12154 - Database Error Messages

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.