Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Replication Help

Re: Replication Help

From: Arulmozhi Sengodan <Arulmozhi.Sengodan_at_us.bosch.com>
Date: Wed, 2 Feb 2000 09:17:37 -0500
Message-ID: <879eas$ikj$1@proxy2.fe.internet.bosch.de>


I am using HP-UX 10.20. Looks like I am missing some setup script in Advanced Replication.

The error I seem to getting is:

/*-- Connection to: SYSTEM_at_B.WORLD --*/

/*---
Creating user 'REPADMIN' at site 'System390' ---*/

create user REPADMIN identified by REPADMIN;

/*---
Granting admin privileges to user 'REPADMIN' at site 'System390' ---*/

begin
 dbms_repcat_admin.grant_admin_any_schema(  username => 'REPADMIN');
end;
/
/******** Error:

ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYSTEM.DBMS_REPCAT_ADMIN" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2

********/

/*---
Registering user 'REPADMIN' as propagator at site 'System390' ---*/

begin

   dbms_defer_sys.register_propagator(username => 'REPADMIN'); end;
/
/******** Error:

ORA-06550: line 2, column 4:
PLS-00905: object SYSTEM.DBMS_DEFER_SYS is invalid
ORA-06550: line 2, column 4:

PL/SQL: Statement ignored
********/

/*---
Granting privileges to user 'REPADMIN'
---*/

grant execute any procedure to REPADMIN;


Tapan Trivedi <tapan.trivedi_at_abbnm.com> wrote in message news:3897435B.DC949F97_at_abbnm.com...
> What OS is this on ??

>

> Arulmozhi Sengodan wrote:
>

> > I am using Oracle 8.0.4 and Replication Manager 1.6.0.0.0 and the one
> > obvious thing that I can understand is that the relevant packages (like
> > dbms_repcat) seem to be missing. What package/procedure do I run to get
this
> > going on my system. I have Oracle8 Enterprise edition.
> >
> > Wayne Menzie <waynem_at_bosmedtechdotcom.nospam> wrote in message
> > news:8ECC790EEwayneshammalammading_at_216.64.31.80...
> > > Arulmozhi.Sengodan_at_us.bosch.com (Arulmozhi Sengodan) wrote in
> > > <874662$cm2$1_at_proxy2.fe.internet.bosch.de>:
> > >
> > > >Hi ,
> > > >
> > > >I am a newbie and want some help with Setting up Replication. I used
the
> > > >Replication manager and tried creating Master Site. I received the
> > > >following error:
> > >
> > > <error details snipped>
> > >
> > > What version of Oracle and Replication Manager are you using? If you
are
> > > using 8i and 2.04 respectively, don't use the Replication Manager. It
is
> > > beta software that doesn't always work properly.
> > >
> > > Read the Replication API reference for your Oracle version and use the
> > > scripts from the examples to set up replication.
> > >
> > > Wayne Menzie

> Received on Wed Feb 02 2000 - 08:17:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US