Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> replication errors
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 Fri Sep 07 2001 - 12:28:48 CDT