Is there any problem with RAC?

quangnd · Post by **quangnd** » Thu 24 Jun 2010 10:48

Hi, We are using dotConnect for Oracle 5.25.39.0 to connect with Oracle 10g (10.2.0.2). When DB is normal one, every thing is OK. But when our customer upgrade to RAC (10.2.0.4), very serious problem happend. Our program is following very simple logic:
step 1: query UNSENT records
step 2: sent a record to other system
step 3: trans = conn.BeginTransaction()
step 3: mark this record with SENT status using update command
step 4: trans.Commit();
step 5: return to step 1
Usually, we select several row sent from previous loop. We think dotConnect has serious bug with trans.Commit(); If previous loop we sent 60 records, our program will resent 10 to 20 last sent record.
It bring us serious problems.
Please help.

Shalex · Post by **Shalex** » Fri 25 Jun 2010 13:12

1. Please use dbMonitor (download link, documentation) to control the SQL queries sent to the database.
2. Could you please send us a small test project with the DDL/DML script to reproduce the problem in our environment? Why did you begin transaction only on the step 3? What does "other system" mean? It is not clear where you "send" (does "send" mean "insert"?) and select records from. Anyway, try using dbMonitor.
3. Are there any exceptions? If yes, please send us your call stack. Make sure that you don't use the same connection object in several threads simultaneously.
4. RAC is supported in the OCI mode. In the Direct mode you can connect only to one database instance. Which mode are you using?