Re: Advanced Replication of Procedures, Functions, and Packages

Unfortunately, I don't have a script for most of it because I am using Oracle Replication Manager (version 2.0). All I am doing is as follows:

1. At the masterdef site, I use Replication Manager to create the master group with one other master site.
2. I compile my stored procedure to the masterdef site. At this point the other site does not have the procedure (or any similarly named object). The procedure is very simple (e.g., "begin null; end;")
3. I then use Replication Manager to add the stored procedure to the master group. The procedure is created on the other site as a result.
4. I then make a trivial change to my stored procedure (e.g., add a comment) and compile it to the masterdef site. The procedure is never replicated to the other site, regardless of what changes are made to the masterdef site.

Both servers are set to the same time zone and have the same time, so that is not an issue. The timestamp of the changed procedure on the masterdef site is later than the timestamp of the original procedure on the other site. In addition, the procedure will not replicate to the other site even if the procedure is dropped from the other site without dropping it from the masterdef site.

At one point we did have a problem where Replication Manager created public database links, which the jobs could not use (they kept returning ORA-01004 because no username was specified in the link). We substituted private database links for those and at that point, any tables we also added to the master group (independent of the stored procedure) replicated data changes.

Pete Sharman <psharman_at_us.oracle.com> wrote in message news:37D7D58E.95F28066_at_us.oracle.com...
> OK, so no errors anywhere, including the snapshot trace files? Then can
you
> send us the steps you're going through? If you've got it all in a script,
send
> that rather than describing it in words, because it's easier to see what's
> missing from a script.
>
> Pete
>
> "Chris R. Donnelly" wrote:
>
> > It simply won't replicate the procedure on updates. There are no error
> > messages from either Oracle Replication Manager or in the databases'
dump
> > directories (i.e., the database jobs are running successfully). The
> > procedure is replicated only when it is first added to the master group
and
> > no other time (even if the procedure is later dropped on the
non-masterdef
> > server).
> >
> > // Chris
> >
> > Pete Sharman <psharman_at_us.oracle.com> wrote in message
> > news:37D597B6.DB1B1496_at_us.oracle.com...
> > > Chris
> > >
> > > Bit difficult to tell what's going wrong from what you've described.
Is
> > there
> > > an error message you're getting, or is it just not replicating the
> > procedure?
> > >
> > > Pete
> > >
> > > "Chris R. Donnelly" wrote:
> > >
> > > > Hi everyone,
> > > >
> > > > I have set up multimaster replication between two Oracle 8i
databases.
> > The
> > > > objects I am replicating between the two masters are a table and a
> > stored
> > > > procedure. The table data is replicating normally (i.e., a change
on
> > one
> > > > database propagates to the other as expected). However, when I make
a
> > > > change to the stored procedure on the masterdef database, it does
not
> > > > replicate the changes in the procedure to the other database, either
> > > > automatically or by manual execution. I have tried using both
> > Replication
> > > > Manager as well as directly executing the procedures in the
DBMS_REPCAT
> > > > package to no avail, as well as both synchronous and asynchronous
> > > > replication (preferably using asynchronous). What do I need to do
to
> > > > replicate the stored procedure's DDL?
> > > >
> > > > // Chris
> > >
>
Received on Thu Sep 09 1999 - 12:50:40 CDT