DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: 2055 distributed txn error across DB link from 8.1.7 to 8.1.6

  1. #1
    I get this:
    =============
    POSPROD.RTNYC.COM:posprod> @test_pos_admin_pkg
    ERROR:
    ORA-02067: transaction or savepoint rollback required


    declare
    *
    ERROR at line 1:
    ORA-02055: distributed update operation failed; rollback required
    ORA-00920: invalid relational operator
    ORA-02063: preceding line from POSPROD
    ORA-02063: preceding 2 lines from POS_TO_QA
    ORA-06512: at "POSPROD.POS_ADMIN_PKG", line 359
    ORA-06512: at line 9


    error -1 still updates the business table (where id = ID)
    Error accessing package DBMS_APPLICATION_INFO
    ERROR:
    ORA-02067: transaction or savepoint rollback required
    ==========
    I am simply doing an update inside a package across a DB link. I am doing it to several databases. We are in the process of upgrading from 8.1.6.3 to 8.1.7.3. Only 1 DB is upgraded so far, and I get this error now against it.

    I did remake the DB link, and restarted the listener. No help.


    any ideas?

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    For a distributed transaction,
    - Disable table level lock
    - Create public rollback segments

  3. #3
    There are public RBS... how do I disable table locks across the link?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width