Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> problem: insert into remote table (dblink) hangs after migration 8.0.6 to 9.2.0
Hi, all.
I have a distributed database system, that, until recently, consisted
of Oracle 8.0.6. databases.
It has a main database, where most of the action takes place, and 10-20
smaller remote databases, connected with dblinks.
Recently we migrated the main database to Oracle 9i. The remote databases remained 8.0.6.
After adjusting the tnsnames to the new global naming conventions, all the dblinks seem to work correctly. We can do selections and small inserts, so the dblinks work fine.
But sometimes, when our application tries to insert data on several remote tables (via a synonym) in one PL-SQL block, it hangs on the first insert.
When I use TOAD to look at the sessions on both databases, we see:
- there are no blocked or blocking locks on either sides
Any suggestions on what to check, where to look, or links to relevant documentation are more than welcome.
JanR Received on Fri Nov 17 2006 - 07:47:38 CST