0 Replies Latest reply: Nov 15, 2011 7:11 AM by 900330 RSS

    ODP.NET for RAC  throw exception ora-01031?

      db service: 64bit AIX
      app service: client + ODAC 32bit 2003

      PROD =
      (load_balance = yes)
      (failover = on)
      (ADDRESS = (PROTOCOL = TCP)(HOST = fafimgdb1-vip)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = fafimgdb2-vip)(PORT = 1521))
      (INSTANCE_NAME = prod1)
      (INSTANCE_NAME = prod2)


      not only prod1,prod2 but also PROD ,sqlplus and pLsql can connect ,and userid have sysdba privilege.

      but my app excute connection.open() throw exception ora-01031 ,
      connstring="user id=scott;password=tiger;data source=PROD ;load balancing=true;"

      oracle document says:
      This feature can only be used with an Oracle RAC database and only if "pooling=true". If "Load Balancing=true" is set and the connection attempts to connect to a single-instance database, an OracleException is thrown with an error of "ORA-1031: insufficient privileges."

      i have no idea,so please help me.thanks.

      Edited by: user13562532 on 2011-11-15 上午4:50

      Edited by: user13562532 on 2011-11-15 上午5:10