How to connect to ORACLE Database

Help
,
23

Connecting UiPath with Oracle

  1. Go to the following link and download the 32-bit client. Make sure to download the client of the same version as Oracle DB. (In this case, it was 12.1.0.2.0)
    https://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-2297732.html
  2. Install the downloaded client.
    From the installation options, choose InstantClient.
  3. It will probably be installed under C:\app\Adminstrator\product\12.1.0
  4. Create a tnsnames.ora file with the following data:
    auto_claims=
    (DESCRIPTION=
    (ADDRESS=(PROTOCOL=TCP)(HOST=10.x x.xxx)(PORT=1521))
    (CONNECT_DATA=
    (SERVICE_NAME=auto_claims)
    )
    )
    Where,
    auto_claims = Service name
    10.x.x.xxx = Host name
    1521 = Port
  5. Place the tnsnames.ora file under C:\app\Adminstrator\product\12.1.0\client_3
  6. Create an environment variable TNS_ADMIN with the value C:\app\Adminstrator\product\12.1.0\client_3
  7. Add the following to path envrionment variable if not already added:
    C:\app\Adminstrator\product\12.1.0\client_3
  8. Open ODBC Data Sources (32-bit) from the Start Menu.
  9. From the User DSN tab, click on Add.
  10. From the data sources, select Oracle in OraClient12Home3_32bit. (It should have been created automatically).
  11. If you face any error, download and install the following:
    Microsoft Visual C++ 2010 x86 Redistributable – 10.0.xxxxx
  12. Click Finish.
  13. Enter the following values:
    Data Source Name: Any name of your choice
    TNS Service Name: auto_claims (same name from tnsnames.ora file)
    User ID: UserID (same from tnsnames.ora file)
  14. Click on Test Connection.
  15. It will prompt for a password. Enter the password and Click OK.
  16. It should say, Connection Successful.
  17. In UiPath Studio, take a Database Connect activity.
  18. Click on Configure Connection.
  19. Click on Connection Wizard.
  20. Click on Microsoft ODBC Data Source and Click OK.
  21. Select the DSN you created before from the Use user or system data source name dropdown.
  22. Provide User name and Password below that.
  23. Click Test Connection. It should be successful.
  24. Select the Provider as System.Data.Odbc
  25. Create a connection object and use it wherever you want!!

Regards,
Hiren

9 Likes
24

Nice details.
I had oracle express (as probably most people do, since it is free) and I configured it.
Just Instant Client should be in 32 bit not 64 bit (this happened to me).

I am going to try to configure the connection with one more way and maybe record it because it was pretty hard for me to configure all of that

25

Hello,

Has this worked for anybody? I’ve been able to test the connection successfully within Studio, however the workflow execution fails with the attached error. Thanks for your help in advance!

Capture
Capture862×370 19.2 KB

26

Where is the TNSNAMES.ora file located?

Try performing a TNSPING in the command prompt.
Link:- Tnsping - Oracle FAQ

27

Hello @Prashant_08,

I was able to resolve this using this thread:
[Connection to Oracle]

Thanks for replying!
Gunjan

1 Like
28

I type your mentioned below info into the CONNECT activity and it works to fetch data in Oracle databse. Hope it is helpful for everyone.

ProviderName: “System.Data.OracleClient”
ConnectionString: “SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myHostNam)(PORT=myPort))(CONNECT_DATA=(SERVICE_NAME=mySID)));uid=myUsername;pwd=myPwd;”

1 Like
32

Hi,

I am trying Connecting UiPath with Oracle
1.I have Downloaded the client of the same version as Oracle DB. (In this case, it was 12.1.0.2.0)
2. Installed InstantClient.
3. Created a tnsnames.ora file with the following data:
auto_claims=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.x x.xxx)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=auto_claims)
)
)
4. Placed the tnsnames.ora file under the instant client folder

Capture2222
Capture2222767×247 4.49 KB

5. Created an environment variable TNS_ADMIN with the value instant folder name
6. Open ODBC Data Sources (64-bit) from the Start Menu.
7. From the User DSN tab, clicked on Add.
8. From the data sources, I selected Oracle in OraClient12Home3_32bit. (Which have been created automatically)
Given the TNS Service and username and password as given in the TNSnames.ora but it showing the following error
Capture111

Thanks in advance

33

@logerror
@lakshman

34

@PragmaticProgrammer - I am facing this issue
image

35

This issues dont have anything to do with Uipath in itself… Usually is a mistake in mixing applications architectures, use only 32 bits drivers and you will be ok.

1 Like
36

Please check out this post -