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 errors

Re: replication errors

From: Sathish Balas <sathishudercor_at_home.com>
Date: Sun, 09 Sep 2001 00:00:55 GMT
Message-ID: <Xiym7.13389$NK.1276662@news1.rdc1.va.home.com>


Do u have a db link owned by user who owns the snapshot logs and snapshots ?

Thanks
Sathish

"Ed Stevens" <Ed_Stevens_at_nospam.noway.nohow> wrote in message news:3b9903a0.85395051_at_ausnews.austin.ibm.com...
> We are configuring our first replication environment. Worked through
> all replication wizards in DBA Studio to establish master site,
> snapshot site, snapshot group, etc. Don't *think* we missed
> anything. When we created the snapshot group on the snapshot server,
> we
> were plesantly surprised to see that it created and populated the
> tables from the master site. So far so good.
>
> Next, we modified a row in a user table on the master site, waited
> well past the refresh interval and the change never showed up in the
> snapshot database. Looking through the alert logs, we found the
> following in the snapshot side:
>
> Thu Sep 06 08:55:13 2001
> Errors in file e:\oradmin\smsz\bdump\smszSNP2.TRC:
> ORA-12012: error on auto execute of job 41
> ORA-01031: insufficient privileges
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674
> ORA-06512: at "SYS.DBMS_IREFRESH", line 577
> ORA-06512: at "SYS.DBMS_REFRESH", line 211
> ORA-06512: at line 1
>
> I assume this job failure explains why the change didn't show up in
> the snapshot database. I looked at the referenced trace file, but
> didn't
> see anything any more informative.
>
> --
> Ed Stevens
> (Opinions expressed do not necessarily represent those of my employer.)
Received on Sat Sep 08 2001 - 19:00:55 CDT

Original text of this message

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