Results 1 to 3 of 3

Thread: 9i upgrade

  1. #1
    Join Date
    Sep 2003
    Posts
    11

    Unanswered: 9i upgrade

    Hi,

    We upgraded our production during last week from oracle 8i to 9i (9.2.0.3). We have many dbms jobs and they are failing after the upgrade. Our DBA mentioned that there are no known issues for the 8i to 9i upgrade for this to happen. But since we did not have any production changes during this time upgrade could be the most likely reason for this. Please find the error message

    ERROR at line 1:
    ORA-02055: distributed update operation failed; rollback required
    ORA-02068: following severe error from CUSTMAMP
    ORA-03113: end-of-file on communication channel
    ORA-06512: at line 4

    I think the error may be happening in exception handling.


    Any inputs will be helpful.

    Thanks.

  2. #2
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    This error arises becuse a failure during a distributed update operation may not have rolled back all effects of the operation. Since some sites may be inconsistent with others, the transaction must roll back to a savepoint or roll back entirely.
    SATHISH .

  3. #3
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    HI,

    You either Roll back to a savepoint or roll back the entire transaction and resubmit the rolled-back statements.
    SATHISH .

Posting Permissions

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