A Snapshot Problem

From: Ole Ivar Gundersen <ole.ivar.gundersen_at_circle.no>
Date: 3 Aug 1998 18:34:32 GMT
Message-ID: <01bdbf0a$e6576fb0$2507c881@monitor>

I have scheduled my snapshots to be updated every hour, but it doesn't work. It works when I run manually refresh with Replication Manager.

I run Oracle 7.3.4 on NT 4.0.

I think is got something to do with the fact that the database is taken offline every night for backup.
Here's a sample of the Alert Log:

oo
SMON: enabling cache recovery SMON: enabling tx recovery Tue Jul 28 08:23:15 1998 Completed: alter database "gnus" open Tue Jul 28 08:23:16 1998 Errors in file D:\orabase\admin\GNUS\bdump\gnusSNP1.TRC: ORA-12012: error on auto execute of job 2 ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_SNAPSHOT", line 271 ORA-06512: at "SYS.DBMS_IREFRESH", line 416 ORA-06512: at "SYS.DBMS_REFRESH", line 171 ORA-06512: at line 1

Tue Jul 28 08:24:47 1998
Thread 1 advanced to log sequence 1327
Current log# 1 seq# 1327 mem# 0: D:\ORABASE\GNUS\LOG1A_GNUS.DBF Current log# 1 seq# 1327 mem# 1: E:\ORABASE\GNUS\LOG1B_GNUS.DBF Tue Jul 28 08:26:59 1998
Errors in file D:\orabase\admin\GNUS\bdump\gnusRECO.TRC: ORA-02019: connection description for remote database not found ORA-02019: connection description for remote database not found

oo
Any ideas, anyone?

Received on Mon Aug 03 1998 - 13:34:32 CDT