Replication error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Replication error

  1. #1
    Join Date
    Nov 2000
    Posts
    101
    Hi,

    I want to configure Advanced Replication.

    I have two sites one as master and another as snapshot.

    I could create the master objects and replication support in the master site.

    When i create the snapshot group in the snapshot site. It prompts an error:

    DECLARE
    CREATE_SNAPSHOT_REPGROUP VARCHAR2(10);
    BEGIN
    DBMS_REPCAT.CREATE_SNAPSHOT_REPGROUP('MG3','DBS3.TIL.COM','THIRDSNAPGROUP on FEB-23','ASYNCHRONOUS');
    END;

    /

    ERROR at line 1:
    ORA-06550: line 1, column 8:
    PLS-00201:
    identifier 'SYS.DBMS_REPCAT_UTL2@DBS3.SSTIL.COM' must be declared
    ORA-06550: line 1, column 8:
    PL/SQL: Statement ignored
    ORA-06550: line 1, column 7:
    PLS-00201: identifier 'SYS.DBMS_REPCAT_UNTRUSTED@DBS3.SSTIL.COM' must be
    declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored
    ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 2215
    ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1539
    ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
    ORA-06512: at "SYS.DBMS_REPCAT", line 1045
    ORA-06512: at line 4


    Could any one tell me what is the problem.


    Thanks in advance.

    bye
    gandhi



  2. #2
    Join Date
    Nov 2000
    Posts
    57

    Replication error

    Did u run Catrep.sql....on both the databases...?

    If not run it immediately and also check if any invalid objects are there from user_objects and then let me know...

    my mail id is shrik_m@yahoo.com

    Srikanth

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