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

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Fri, 17 Dec 1999 17:47:48 GMT
Message-ID: <385a7723.253216694@news.earthlink.net>

screwed up sys/catalog.
Try rerunning catalog, catproc

On Fri, 17 Dec 1999 16:14:01 GMT, 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.

---

In case I forgot to mention:
We use Oracle 7.3.4 on Solaris 2.6, 2.7 boxes

---

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Fri Dec 17 1999 - 11:47:48 CST