how to use direct mode at oraccle RAC

[daizhicun]

for example :
My oracle use RAC;

in a client PC, my tnsnames.ora is:

TEST=
(DESCRIPTION =
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.101)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.102)(PORT=1521))
)
(CONNECT_DATE = (SERVER_NAME=TEST)
)
)

SO ,in direct mode , k only can use one of server's ip ;

begin
UniConnection1.SpecificOptions.Add('Oracle.Direct=True');
UniConnection1.Username := 'xxx';
UniConnection1.Password := 'xxx';
UniConnection1.Server := '192.168.1.101:1521:sn=TEST';
end;

I don't know how to use RAC in direct mode;

can i set:

UniConnection1.Server := '(192.168.1.101:1521)(192.168.1.102:1521):sn=TEST';

[AlexP]

hello,

Presently, the RAC technology is not supported in the Direct mode (automatic server switch). You can connect to one of the servers only. Full support of RAC is planned for one of the next versions.

[Daril]

Hi,
I wonder to any progress in RAC support for Direct Mode or still this option is not supported.

Than you Daril

[AlexP]

No, this feature is not yet implemented.

[cosullivan]

Hi,

Do you have any timeline on when RAC support under Direct Mode will be available? Is it still in the plan?

Thanks,
Cain

[AlexP]

The next UniDAC version will include a possibility to specify a server both as a record from the tnsnames.ora file and as a list of nodes (ip,port). UniDAC will attempt to connect to the first node in turn.

[cointec]

Does the current version of Oracle supports RAC in directo mode?

If yes, is there any example?

Thank you

[AlexP]

To connect to RAC, you should set the following Server property:

Code: Select all

scott/[email protected],n2.domain:PORT1,PORT2:SID

[cointec]

Thank you, then when the connection is lost, UniConnection reconnects automatically to the second, third server?

[AlexP]

Yes, if you set the RetryMode variable to rmReconnect or rmReconnectExecute in the onConnectionLost event handler, then on connection loss with one node there will occur an attempt to connect to the next node.