Page 1 of 1

SEHA connect string in direct more

Posted: Wed 24 Aug 2022 07:11
by albourgz
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.