Connecting to Oracle Database

database
studio

#1

Scenario: Connecting to Oracle Database

Steps to reproduce: Started a sequence and selected Database connection and configured and no errors were present.

Current Behavior: While running, getting exception in Main. Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. All the Oracle components installed on the machine are 64 bit

Expected Behavior: UI path should connect to the database as per configuration.

Studio/Robot/Orchestrator Version:

Last stable behavior:
Last stable version:
OS Version: Windows 10 64 bit
Others if Relevant: (workflow, logs, .net version, service pack, etc): Microsoft windows 10 pro 64 bit .net 4.0.30319.42000


How to connect to ORACLE Database
#2

Hello,

I had identical issue and spend a whole day to find a solution.
I don’t habe my VM here so I cannot give you precise instruction.

I’ve found that using “Oracle instant client (32bits/64bits)” works much better than Oracle Client full installation.
And also you MUST install Microsoft visual C++ redistributable (32bits/64bits). This is necessary and obviously NOT documented by Oracle. Damn !

I had more chance using 32bits Oracle Instant Client + 32bits visual C++ redistributable.

Kind regards,
Alex.


#3

Hi Alex,

Thanks for your quick help. I have installed 32 bit oracle client and it worked fine for me.

Regards,
Vishal Kumar


#4

Hi, Alex and fahuet
i want to connect with oracle database 12c with the following String. It doesn’t work. I am not sure if the string needs to be modified. i want to know your opinion.
"Data Source=OracleDatebaseTest;User ID=c##uipathrobot;Password=[xxxxx]"
with best regards


How to connect to ORACLE Database
#5

Hi,

I believe the connection string should be like

Data Source=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xyx)(PORT = Port_Number)) (CONNECT_DATA = (SERVER = DEDICATED)(SID=Service_Name)));User Id=user;Password=pwd;

Thanks,
Vishal Kumar


#6

Hi, Vishal,
i tried according your suggestion with the following String. Please check if any value should be change and i don’t know what do you mind with (Server=Dedicated), the oracle data base 12c is installed on my laptop.

Data Source=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = Oracle)(SID= OracleDatabaseTest)));User Id=SYSTEM;Password=password;


#7

Hi,

Is the SID value OracleDatabaseTest is correct ?

Thanks,
Vishal Kumar


#8

Hi,

My Database server was configured that way. Please check this for more info

Purpose : To direct the listener to connect the client to a specific type of service handler.
Usage Notes : Put this parameter under the CONNECT_DATA parameter.
Values:

  1. dedicated to specify whether client requests be served by dedicated server.
  2. shared to specify whether client requests be served by a dispatcher or shared server.
  3. pooled to get a connection from the connection pool if database resident connection pooling is enabled on the server.
    Notes: Shared server must be configured in the database initialization file in order for the client to connect to the database with a shared server process.The USE_DEDICATED_SERVER parameter in the sqlnet.ora file overrides this parameter.

#9

@ thank you vishal, i will try it.