SymRep and Job Queue problem
Date: 1997/03/06
Message-ID: <5floo0$44n$1_at_relief.cts.com>#1/1
All,
I keep getting the following error when I try to execute any job in the job queue. It basically fails because of insufficient privileges. This job is part of a Symmetric Replication environment. Repadmin has all the privileges required as I ran the dbms_repcat procedure which sets him up as the global administrator.
If more info is required please let me know.
TIA, Phil M.
Partial contents of job queue
1 select substr(job, 1,5) job, substr(log_user, 1, 10) log_user,
2 substr(priv_user, 1, 10) priv_user, substr(schema_user, 1,
10) schem
a_us,
3 broken, failures, what
4* from dba_jobs
comisp2> /
JOB LOG_USER PRIV_USER SCHEMA_US B FAILURES ----- ---------- ---------- ---------- - -------- WHAT
45 REPADMIN REPADMIN REPADMIN N 6 dbms_refresh.refresh('"REPADMIN"."MERCH"');
46 REPADMIN REPADMIN REPADMIN N 6 dbms_refresh.refresh('"REPADMIN"."INV"');
Output from manual execution of job queue
comisp2> execute dbms_job.run('46');
begin dbms_job.run('46'); end;
*
ERROR at line 1:
ORA-12011: execution of 1 jobs failed
ORA-06512: at "SYS.DBMS_IJOB", line 242
ORA-06512: at "SYS.DBMS_JOB", line 218
ORA-06512: at line 1
Contents of SNPx process trace file
- SESSION ID:(9.121) 1997.03.05.22.20.06.000 ORA-12012: error on auto execute of job 46 ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_SNAPSHOT", line 271 ORA-06512: at "SYS.DBMS_IREFRESH", line 413 ORA-06512: at "SYS.DBMS_REFRESH", line 171 ORA-06512: at line 1 Wed Mar 5 22:25:06 1997 Wed Mar 5 22:25:06 1997