none
system.data.oracleclient支持oracle的RAC么?? RRS feed

  • 问题

  • 如题。

     PROD =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.9.240.4)(PORT = 1521))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.9.240.6)(PORT = 1521))
        (LOAD_BALANCE = yes)
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = prod)
        )
      )

    连接串

      Data Source=prod;User ID= xx;Password=xx;Max Pool Size=100;Min Pool Size=0;Connection Lifetime=120;

    能连接上,但是不知道load balancing有效没有?

    2011年11月16日 7:36

答案

  • Runtime Connection Load Balancing

    Enables Oracle Database to make intelligent service connection decisions based on the connection pool that provides the optimal service for the requested application based on current workloads. The JDBC, ODP.NET, and OCI clients are integrated with the load balancing advisory; you can use any of these client environments to provide runtime connection load balancing.

     

    本身OCI支持,是不是就不用改动。

    ODP.NET也支持,但是搞了半天,权限不足,无解。

    2011年11月17日 1:55