Re: Q: unable to start snp 8.1.5 nt(ora-12012)?

It doesn't know about the SYS.DBMS_DEFER_SYS table because whoever is running this script does not have permission to access the table. (I'd also make sure that the table *actually* exists, obviously)

Permission must be *explicitly* granted to this user using the following statement, for example:

GRANT SELECT ANY TO user;

Then it should work.

In article <83dng4$ttg$1_at_nnrp1.deja.com>,   tedchyn_at_yahoo.com wrote:
> Sir, after setting up job_queue_processing =7,Following error message
> appears in alert.log(all snp process failed)
>
> Errors in file D:\Oracle\admin\world\bdump\orclSNP4.TRC:
> ORA-12012: error on auto execute of job 1
> ORA-06550: line 1, column 135:
> PLS-00201: identifier 'SYS.DBMS_DEFER_SYS' must be declared
> ORA-06550: line 1, column 129:
> PL/SQL: Statement ignored
>
> what are the possible cause for this ?
> thanks in advance
> Ted Chyn
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 17 1999 - 12:09:41 CST