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

    ODP.NET for RAC  throw exception ora-01031?

    900330
      Enviorment:
      db service:10.2.0.5 64bit AIX
      app service: 11.2.0.1 client +11.2.0.1.2 ODAC 32bit 2003

      tnsnames.ora:
      PROD =
      (DESCRIPTION =
      (load_balance = yes)
      (failover = on)
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = fafimgdb1-vip)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = fafimgdb2-vip)(PORT = 1521))
      )
      (CONNECT_DATA =
      (SERVICE_NAME = PROD)
      (SERVER = DEDICATED)
      (INSTANCE_NAME = prod1)
      (INSTANCE_NAME = prod2)
      (failover_mode=(type=select)(method=basic)(retries=20)(delay=20))
      )

      )

      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