Oracle- Data Gateway-Power Automate Connector- Error

Submitted by leader on Mon, 11/03/2025 - 11:30

Here is the error in Power Automate:
Test connection failed. Details: Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA inner exception: Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA clientRequestId: 5d4ab5a5-d136-81dd-e0ab-ab62dd76e609

 

Here is what it should look like:

Example of a Oracle details
Server: Serveraddress.com
PORT: PORT
SID: SID

Syntax for the below server field:
ServerAddress.com:PORT/SID
***Note: do not include HTTP in the server name.

Blog Type: