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

Thread: Replication Tool Error

  1. #1
    Join Date
    Nov 2003
    Posts
    5

    Unhappy Replication Tool Error

    Hello,

    I want to perform Asynchronous Multimaster Replication with Oracle 9i R2 on Red Hat Linux 9.For test purpose i created 2 DB on the same system.
    I tried with scripts first but got errors(i believe script dont have syntax or logical error) and i tried with GUI Replication Management Tool,Still i am getting the same error...here is the error..

    STACK TRACE _____________
    ORA-04068 existing state of packages has been discarded
    ORA-04063 package boby "SYS.DBMS_DEFER_SYS" has errors
    ORA-06508 PL/SQL couldnot find program unit being called
    ORA-06512 at line 2

    i have executed catrep.sql and i verfied DBA_REPCATALOG with base tables..Can anyone help me...pls

    regards,
    Cherrish Vaidiyan

  2. #2
    Join Date
    Apr 2003
    Location
    South Carolina
    Posts
    148
    From system account,
    find out what objects are invalid ...
    Try compiling them and
    sql> sho error
    to find out what their problem is ...

    HTH
    Gregg

  3. #3
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    try running catalog and catproc again

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