-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|