How to connect to a specific instance in a RAC when server side balance is configured

From: qihua wu <staywithpin_at_gmail.com>
Date: Tue, 16 Oct 2007 16:50:06 +0800
Message-ID: <2689c1070710160150o3fde2d82l66246a578fd316d2@mail.gmail.com>

We have a RAC env and want to connect to a specific instance, the tns entry I used is something like

mydb1 =
  (DESCRIPTION =
(SDU = 32768)
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(Host = node1)(Port = 1521))     )
(CONNECT_DATA =

      (SERVICE_NAME = mydb)
      (INSTANCE_NAME = mydb1)

    )
  )

But it still connected to the other instance. I think the server side balance is configured, so I am wondering whether the server side balance will balance the connect regardless of the client side tnsnames.ora setting. One colleague told me to delete the line (SERVICE_NAME = mydb), but it still didn't work.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 16 2007 - 03:50:06 CDT