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
RAC Connection
-
- Posts: 3
- Joined: Sun 12 Oct 2008 19:15
What is the connection string?
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 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
-
- Posts: 3
- Joined: Sun 12 Oct 2008 19:15
Error:
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?
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.
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:
Code: Select all
ConnectionString="User Id=scott;Password=tiger;Server=(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)))"