Hello,
I have an oracle database which works as clusters. My Oracle database has two different IP address and I want to make an OraSession with them. The issue here is, how can I check and control which of the database ip ( cluster is active ).
For example
Db1 with ip xx.xx.xx.11
Db2 with ip xx.xx.xx.12
Only one of them is active and it switches from 11 to 12 or 12 to 11 sometimes depending on load balancer.
How can I control this with Orasession component in delphi 7?
Thank you in advance
Ora Session Problem
Re: Ora Session Problem
ODAC supports Oracle RAC. When using the OCI mode, connection parameters are set in TNSNAMES.ORA, and RAC is accessed similarly to connection to a single Oracle instance. In Direct Mode, the following connection string is used:
At this, ODAC will connect to the first available server listed in ConnectString.
Code: Select all
ConnectString := 'Provider Name=Oracle;Direct=True;Server=DBServer1,DBServer2;Port=1521;SID=ORCL;User ID=scott;Password=tiger';