OraFAQ Forum: Replication » error in creating replication group

Home » Server Options » Replication » error in creating replication group

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error in creating replication group [message #366469]

Thu, 01 July 1999 19:38

chanora
Messages: 5
Registered: June 1999
Location: USA

Junior Member

Hi guys,
I am getting this error while creating group.
i will be grateful to u id if u answer me.

begin
dbms_repcat.create_master_repgroup(
gname => 'empdep',
qualifier => '',
group_comment => '');
end;
/
/******** Error:
ORA-00439: feature not enabled: Advanced replication
ORA-06512: at "SYS.DBMS_SNAP_INTERNAL", line 123
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 608
ORA-06512: at "SYS.DBMS_REPCAT", line 469
ORA-06512: at line 2

Report message to a moderator

Re: error in creating replication group [message #366472 is a reply to message #366469]

Fri, 13 August 1999 17:09

Rajeeva
Messages: 20
Registered: October 1998

Junior Member

YOu need to run the repcat.sql and repcatad.sql scripts to enable replication. Also make sure the DBMS_SNAPSHOT package is valid afterwards

Report message to a moderator

Re: error in creating replication group [message #366474 is a reply to message #366469]

Wed, 25 August 1999 14:07

Mark Johnson
Messages: 5
Registered: August 1999

Junior Member

# Install the RepMgr catalog as the INTERNAL user.
connect internal/pswd
@$ORACLE_HOME/rdbms/admin/catrep.sql;

Report message to a moderator

Re: error in creating replication group [message #366475 is a reply to message #366472]

Wed, 25 August 1999 14:22

MarkJ
Messages: 17
Registered: July 1999

Junior Member

The package DBMS_Snapshot will be listed as invalid in Oracle 7.x after running catrep.sql. This bug is supposed to be fixed in 8.x.

Report message to a moderator

Previous Topic:	if mas def site fails
Next Topic:	ORA-01011: Cannot use v7 compatibility mode when talking to v6 server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 05:00:10 CDT 2024