This discussion is archived
0 Replies Latest reply: Nov 15, 2011 5:11 AM by 900330 RSS

ODP.NET for RAC  throw exception ora-01031?

900330 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points