Xref: alice comp.databases.oracle.misc:52347 comp.databases.oracle.server:83041 comp.databases.oracle.tools:39437
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!bignews.mediaways.net!news2.fe.internet.bosch.de!not-for-mail
From: Arulmozhi Sengodan <Arulmozhi.Sengodan@us.bosch.com>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools
Subject: Re: Replication Help
Date: Wed, 2 Feb 2000 09:17:37 -0500
Organization: Bosch Group
Lines: 91
Message-ID: <879eas$ikj$1@proxy2.fe.internet.bosch.de>
References: <874662$cm2$1@proxy2.fe.internet.bosch.de> <8ECC790EEwayneshammalammading@216.64.31.80> <874ps6$r0g$1@proxy2.fe.internet.bosch.de> <3897435B.DC949F97@abbnm.com>
X-Trace: proxy2.fe.internet.bosch.de 949501084 19091 172.16.1.231 (2 Feb 2000 14:18:04 GMT)
X-Complaints-To: usenet@internet.bosch.de
NNTP-Posting-Date: 2 Feb 2000 14:18:04 GMT
X-Newsreader:  Microsoft Outlook Express 5.00.2014.211
X-MSMail-Priority:  Normal
X-Priority:  3
X-MimeOLE:  Produced By Microsoft MimeOLE V5.00.2014.211

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@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@abbnm.com> wrote in message
news:3897435B.DC949F97@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@bosmedtechdotcom.nospam> wrote in message
> > news:8ECC790EEwayneshammalammading@216.64.31.80...
> > > Arulmozhi.Sengodan@us.bosch.com (Arulmozhi Sengodan) wrote in
> > > <874662$cm2$1@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
>