ORA-02062...What next?

Morning folks!

Checking my alert logs this morning I dicovered the following entry:

        ORA-02062: distributed recovery received DBID d258e0a3, expected ae705c43

The trusty error messages book says: ORA-02062 distributed recovery received DBID string, expected string
Cause: A database link at a coordinator no longer points to the expected database. Link may have been redefined, or a different database mounted. Action: Restore the link definition or the remote database. Okay, I found the dbid links in sys.dba_2pc_neighbors. We moved a database to another machine night before last, and this transaction was part of a stored procedure. Tracked the error to a pending transaction in sys.dba_2pc_pending. Tried to do a: rollback force '10.82.172'; where 10.82.172 is the local_trans_id. Got another error:

        ORA-02058: no prepared transaction found with ID 10.82.172 There is a commit# assigned to the transaction in sys.dba_2pc_pending, the state is "collecting," and the mixed flag is set at "no". Since my rollback failed, can I manually delete the entries from theses tables, should I try a commit force, or will this somehow dissappear on it's own? Could I manually change the state to "prepared" and then try a rollback(this suggestion has to be the result of brain damage - I can visualize the corruption from here!)?
ANY ideas? Other than the commit and rollback options, the book says after 200 seconds, DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME will cause the lock to disappear. We're way past that.

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438 Received on Thu Aug 03 2000 - 11:40:59 CDT