Direct Connection to a RAC server

[jjeffman]

Hello,

I have a RAC Oracle server which can be connected using Oracle client and the following TNS entry:

Code: Select all

ENTRY1.WORLD,ENTRY1=
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = server1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = server2-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = server3-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORASRVC )
        (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
)

There are workstations which do not have Oracle client and there is no intention of install it, so I need to use direct connection to connect to a RAC Oracle service. How can I configure a Direct connection, which are the TOraSession parameters values ?

HOST=
PORT=1521
SERVER=SN?SID?

Does the connection works if server1-vip is a DNS name ?

Thank you very much.

Jayme Jeffman

[MaximG]

ODAC supports Oracle RAC in Direct Mode. For example :

Code: Select all

 OraSession.Server := 'server1-vip,server2-vip,server3-vip:1521:ORASRVC';  

The Server value may contain one Oracle node in RAC or a list of nodes (server1-vip, server2-vip, server3-vip). Thus, ODAC will connect to the first available server listed in this property.

[jjeffman]

Maxim, thank you very much for answering me.

I am not familiar with Oracle RAC configuration, so I wonder if I can have the same structure on the 'Port' parameter like 1521,1525,1534 :

Code: Select all

     OraSession.Server := 'server1-vip,server2-vip,server3-vip:1521,1525,1534:ORASRVC';  

Best regards.

Jayme Jeffman

[jjeffman]

Hello Maxim,

Never mind, I have tryied to make a connection using multiple (same) ports and it works fine, so I guess it will work if each host has a different port for the Oracle listener. The Oracle SID or SN must be unique, though.

Best regards,

Jayme Jeffman

[MaximG]

We are glad that you found a necessary solution. Please don't hesitate to contact us with questions concerning ODAC usage.