SymRep and Job Queue problem

From: Phil Melendez <pme_at_cts.com>
Date: 1997/03/06
Message-ID: <5flopu$44n$2@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

Received on Thu Mar 06 1997 - 00:00:00 CST