ORA-12154 issue with Pipeline connection, works with other Connections

[DKHUghes55]

Hello Community,

I have an issue creating an Oracle Pipeline connction.  I use the Oracle database connector to copy data from the Copy Data assistanct.

When I use the database name and basic authentication I receive the error Database name not recognized. (ORA-12154)

How ever when I create one through the data gateway page using the same Database name, gateway and user authentication it works fine.

I have checked the TNSNames.ora file on the gateway server and could tnsping the database name.

The error indicates, to me, the pipeline creation is not looking at the TNS_ADMIN location on the gateway server.  Is there another place the Pipeline creation process is looking for the TNSNames.ora file?

Thanks,

DKHughes55

[v-mdharahman]

Hi @DKHUghes55,

Thanks for reaching out to the Microsoft fabric community forum.

You are correct, the Copy Data tool within the pipeline experience doesn't use the gateway context the same way the Data Gateway management page does. When creating the connection directly through a pipeline (especially with the Oracle connector in basic mode), the tool expects a fully qualified connection string, not just the TNS alias. This is why you're seeing the ORA-12154 error. As @GilbertQ has already responded to your query, kindly go through his response and check if the issue can be resolved.

I would also take a moment to thank @GilbertQ, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.

[GilbertQ · Accepted solution]

Hi @DKHUghes55 

I would recommend using the gateway to connect to Oracle server. This will ensure that you can consistently get the data. I have not seen anything in the past allowing you to configure the TNSNames.ora file.

[DKHUghes55]

HI GilbertQ,

I found the connection list for the gateways.  Thanks for your help.  Marking your response as Accept as Solution.

DKHughes55

[DKHUghes55]

Hi GibertQ

Thanks for your response to my question.  How do I then use that connection in a Pipeline Copy activity?

DKHughes55