Unable to connect to Oracle table using Studio (Connection String Issue?)

Help Studio
, ,
1

Hi team,
I have an RPA process that extracts data from ORACLE tables. When I try to connect, I see the following error.

image
image1390×804 189 KB

FYI - I’ve a couple of processes with SQL tables and I have not had any issues connecting, the way to do the connection looks like different for the oracle one. Could you please give me guidance on how to do the connection?

Thanks a lot for your help!
Sisay

2

@Sisay_Dinku I hope this steps help you

The image you sent appears to be a screenshot of a UiPath Studio workflow encountering an error related to the connection to a database source. The error message mentions “ERROR [08001] [Microsoft][ODBC Oracle Wire Protocol driver] Connection refused. Verify Host Name and Port Number.”

Here are some troubleshooting steps you can follow to resolve the connection error:

1. Verify Database Connection Details:

  • Host Name and Port: Double-check that the hostname and port number you’ve entered in the “Connection String” property of the “Database Connect” activity are correct. Ensure they match the details of your Oracle database server.
  • Database Name: Make sure the database name specified in the connection string is accurate.
  • SID (if applicable): If you’re using a Single Instance Identifier (SID) for your Oracle database, verify that it’s correctly included in the connection string.

2. Check Oracle Client Configuration:

  • Oracle Instant Client: Ensure you have the appropriate Oracle Instant Client libraries installed on the machine running your UiPath Robot. These libraries provide the necessary drivers for connecting to Oracle databases. You can download the Instant Client from the Oracle website and install it based on your system architecture (32-bit or 64-bit) and Oracle database version.
  • ODBC Data Source (Optional): If you’re using an ODBC data source to connect to the database, verify that the DSN is configured correctly and points to the Oracle database server.

3. Firewall Rules:

  • Inbound Connections: Make sure the firewall on the Oracle database server allows inbound connections on the port used by Oracle (default is 1521). You might need to configure firewall rules to permit connections from the machine running your UiPath Robot.

4. UiPath Studio Configuration:

  • Connection String Format: Ensure the connection string format you’re using is compatible with the Oracle database driver and the method you’ve chosen (ODBC or native Oracle driver). Refer to UiPath documentation or the Oracle database driver documentation for specific connection string examples.

5. Test the Connection:

  • TNSNAMES.ora File (if applicable): If you’re using a TNS alias to connect to the database, verify that the TNSNAMES.ora file is configured correctly and points to the Oracle database server. You can test the TNS alias using tools like tnsping to confirm connectivity.

By systematically checking these aspects, you should be able to identify the root cause of the connection error and establish a successful connection between UiPath and your Oracle database.

If you’re still facing issues after trying these steps, consider searching UiPath forums or documentation for specific error messages or consulting an Oracle database administrator for further assistance.

3

Hi @mukesh.singh

Thank you so much for the very detailed information regarding to Oracle Connection String in UiPath Studio.
Here are the connection string syntaxes I was trying to use
FYI - insert_here represents the actual values I used when testing

“Data Source=(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=insert_here))(ADDRESS=(PROTOCOL=TCP)(HOST=insert_here)(PORT=1521)));Uid=insert_here;Pwd=insert_here” and which does not seem working for me.

Throwing the following error

image
image798×135 25.6 KB

Also, I tried to use the same

“Driver={Microsoft ODBC For Oracle};SERVER=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = insert_here)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = insert_here)));
uid=insert_heret;pwd=insert_here”

image
image894×122 56.6 KB

Also, I have a follow up question under #3 Firewall rules - [quote=“mukesh.singh, post:2, topic:739684”]
You might need to configure firewall rules to permit connections from the machine running your UiPath Robot.
[/quote]
Could you elaborate on how to configure that? Could you also share Connection String Syntax that you’d think may work?
Anyone can who had similar issues and go resolved could chime in and share.
Thanks a lot for your help!

Sisay

4

You need to open the port as per your connection string

image
image841×476 25.7 KB

https://manifold.net/doc/mfd9/open_a_firewall_port_for_oracle.htm

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.