Using the Oracle Access control group under the Torasession Control link under Delphi

Using the Oracle Access control group under the Torasession Control link under Delphi
Database, using
ORSN1. Options.direct:=true;
ORSN1. Server:=ip:port:sid;
ORSN1. Username:=username;
ORSN1. Password:=password;
ORSN1. Connect;
You can link successfully, which is linked by using the SID method.
But if the login database uses the service name method, the program does not link up, reason,
That's because Delphi ODAC and Oracle RAC
Direct mode does not the support RAC. You can connect with only one fixed server
In RAC.
The direct mode in the ODAC control does not support Oracle RAC and can only link to a certain RAC instance.
If you want to use the ODAC control to connect to an Oracle RAC, you need to oracel install the client and do not use the direct mode.
The link is consistent with the ADO connection to Oracle.

Follow the instructions to install the Oracle client, and after installation, look for the Tnsnames.ora file
Increase in file

Dmsii=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.73) (PORT = 1521))
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.74) (PORT = 1521))
(load_balance = ON)
(FAILOVER = ON)
(Connect_data =
(service_name = DMSII)
(Failover_mode =
(TYPE = Select)
(METHOD = BASIC)
(retries = 30)
(DELAY = 5)
)
)
)
Note that there can be no spaces before dmsii
Program code Modification
ORSN1. Username:=username;
ORSN1. Password:=password;
ORSN1. server:= service name;
ORSN1. Connect;
Link.

Using the Oracle Access control group under the Torasession Control link under Delphi