topic RE: Unable to connect the oracle database in blueprism in Product Forum

Unable to connect the oracle database in blueprism

VinayGondesi — Wed, 08 Jul 2020 16:00:00 GMT

Hi Team,

Unable to connect and open the oracle database from Blueprism. I am getting an error like OraOLEDB.DLL is not registered in your local machine.

I have different ways to connect and i am using sql Oracle developer to connect the database.
Please help to me to resolve this issue..

And i am using the below provider to connect but no use.

Please share any video or else steps to connect the oracle database and i am newly learning the blueprism. Please guide me on this issue.

"Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=number))(CONNECT_DATA=(SERVICE_NAME=svname)));User Id=sys;Password=pw;DBA Privilege=SYSDBA;"

------------------------------
Vinay Gondesi
------------------------------

RE: Unable to connect the oracle database in blueprism

AmiBarrett — Wed, 08 Jul 2020 18:55:00 GMT

You may need to try the following in a command prompt as administrator. I suspect the path will change based on the version you're using.

1) Use the "cd" command to navigate to the location of your OraOLEDB.dll
2) Use the following command based on if you're using an x86 or x64 version or Oracle:
64-bit Oracle: c:\Windows\system32\regsvr32.exe OraOLEDB.dll
32-bit Oracle: c:\Windows\SysWOW64\regsvr32.exe OraOLEDB.dll

Alternatively, you can add the \bin folder of where you installed the Oracle client into your system PATH.

------------------------------
Ami Barrett
Sr Product Consultant
Blue Prism
Plano, TX
------------------------------

RE: Unable to connect the oracle database in blueprism

lookman — Thu, 09 Jul 2020 15:14:00 GMT

Hi Vinay.

Just to confirm, you are NOT trying to use Oracle for the BluePrism installation. BP only supports MSSS as the BP installation database.

jack

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------