Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to force connection to one node of a RAC

Samuel RabiniJun 23 2011 — edited Jun 23 2011
Hi,
I'm working on an Oracle Database 11g Release 11.1.0.6.0 - 64bit Production With the Real Application Clusters option.

I noticed that whem my applications (write intensive) are all connected to the same node, they write more than a double of records than if their connections are balanced though the rac. This is because Cluster Wait Events increase a lot.

As I would like to keep the HA feature of a RAC, I would not to force the connection to a single node. I would let the tnsnames (or some other components) to try redirect connection first to one node and, JUST in case it's not available, than try to redirect the connection to the other one.

At this moment my tnsnames look like this:
EVODB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.130)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = EVODB)
      (INSTANCE_NAME = EVODB1)
    )
  )

EVODB2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.140)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = EVODB)
      (INSTANCE_NAME = EVODB2)
    )
  )

EVODB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.130)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.140)(PORT = 1521))
    (LOAD_BALANCE = no)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = EVODB)
    )
  )
And I'm using EVODB as tns service name.
Yesterday the LOAD_BALANCE tag was set to yes, I tried to change it to no but nothing changed.

Is the a chance I can achieve my goal?

Thanks in advance.
Samuel
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2011
Added on Jun 23 2011
4 comments
5,328 views