Devart Forums

Hi.

We have been using OraDirect.NET in our application but allways in DirectMode.

It is possible to explain how we configure the connection string to connect to a RAC?

In Java we use something like:


jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.10)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.11)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=ORACLE_SERVICE_NAME)))



How do i configure this with OraDirect? Must I use OCI? That implies me to install the Oracle client tools on the server?

Thanks,

JF

In direct mode the RAC option of Oracle database is not supported. It is supported in OCI mode. All the parameters of tnsnames.ora have to contain Oracle client settings.

What is the connection string to use on OCI?

I have placed the file .ora on the same directory as .config on my IIS application and i turned off Direct Mode.

What i need to do more? Can you paste a sample of a connection string to connect to a RAC .ora file configuration?

Thanks

I have this exception:


Message: Can not obtain Oracle client information from registry. Check if Oracle
client software installed.

I have installed the Basic on c:\instantclient. The path environment variable is pointing to the directory as:

C:\instantclient;XXX;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem

Any suggestions?

The instantclient libraries should be put into the current folder (bin).
The machine should not have any other Oracle clients (there are known conflicts associated with registry).
As an alternative, you can use ConnectionString in the following form instead of editing the tnsnames.ora file:
Please note that application should have permission on unmanaged modules loading.