Newbie - How do you install ODBC to connect to a RAC cluster?

[Zych]

Hello All,

We have an Oracle RAC cluster (10g) and I need to install an ODBC client to connect to the database. From what I understand there are two IP's that are Public and 2 that are virtual and another two that are Private. How does the ODBC know how to load balance between the two in an Active/Active environment?

Everything is running on a Microsoft platform.

Thanks,

Zych

 

[markrem]

Of course your ODBC Data Source is mapped to a tnsnames entry, not directly to an IP address. For example, in ODBC you create a datasource named SALES and map it to tnsnames.ora alias ORCL123.

On the client computer you install Oracle Client, and then you setup the file $ORACLE_HOME/network/admin/tnsnames.ora. In that file you simply copy/paste the database entries from the same file on the server. There, you are done.

Yes, there are two (or more) public IP addresses for the host, and then two (or more) public IP addresses for the Oracle VIP, and then one (or more) private IP addresses for the private interconnect. Out of all of these, your Oracle 10g RAC tnsnames.ora entries should use the public Oracle VIP addresses. Now, the public VIP address has two forms: a name and a number. It matters not which you use.


MarkRem
Author, Oracle Database 10g: From Nuts to Soup

http://www.remidata.com/book_nuts2soup.htm