Re: How to configure application server to connect to a two-node oracle RAC database

From: Steve Howard <stevedhoward_at_gmail.com>
Date: 30 May 2006 08:54:21 -0700
Message-ID: <1149004460.985033.136570@i40g2000cwc.googlegroups.com>

The OCI driver uses the Oracle network configuration file (tnsnames.ora) on the client (application server, in this case) for connectivity definitions. This is where you can configure load balancing and failover options.

An example is below...

YOUR_DB_NAME =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip-node1)(PORT = 2484))
(ADDRESS = (PROTOCOL = TCP)(HOST = vip-node2)(PORT = 2484))
(LOAD_BALANCE = yes)
(CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = your_service_name)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 90)
        (DELAY = 5)
      )

    )
  )

Read up on the docs at tahiti.oracle.com, as they go into great detail as to the different configuration options.

Regards,

Steve Received on Tue May 30 2006 - 10:54:21 CDT