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 -> replication errors

replication errors

From: Ed Stevens <Ed_Stevens_at_nospam.noway.nohow>
Date: Fri, 07 Sep 2001 17:28:48 GMT
Message-ID: <3b9903a0.85395051@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 Fri Sep 07 2001 - 12:28:48 CDT

Original text of this message

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