SEHA connect string in direct more

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
albourgz
Posts: 160
Joined: Wed 06 May 2009 12:17
Location: belgium

SEHA connect string in direct more

Post by albourgz » Wed 24 Aug 2022 07:11

Hi,

I would like to connect to an oracle 19.14 standard edition High Availability (this is what replaces RAC), in direct mode.
In rac I usually have 2 instances

Code: Select all

ConnectionString=rac-1-vip.ci.lan:1522:CIGI1,rac-2-vip.ci.lan:1522:CIGI2
In SEHA there is only one instance, and an automatic failover to 2nd node if the first one has an issue (same instance), so no CIGI1/CIGI2.

Problem:

Code: Select all

ConnectionString=rac-1-vip.ci.lan:1522:CIGI
works,

Code: Select all

ConnectionString=rac-1-vip.ci.lan:1522:CIGI,rac-2-vip.ci.lan:1522:CIGI
doesn't.

Is there any special syntax to specify the SEHA nodes?

Thanks.

Post Reply