Home » RDBMS Server » Server Administration » ORA-12012:, ORA-23421:;ORA-06512:
ORA-12012:, ORA-23421:;ORA-06512: [message #60827] Tue, 09 March 2004 04:24 Go to next message
Marija
Messages: 5
Registered: October 2001
Junior Member
In the alert log there are errors:

ORA-12012: error on auto execute of job 7544
ORA-23421: job number 7544 is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_IJOB", line 514
ORA-06512: at "SYS.DBMS_IJOB", line 247
ORA-06512: at line 1

 

Can anyone help?

 

Becha

Report message to a moderator

Re: ORA-12012:, ORA-23421:;ORA-06512: [message #60840 is a reply to message #60827] Tue, 09 March 2004 12:35 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Can you execute the job manually (ie execute dbms_job.run(7544);), as the user who is trying to execute the job through dbms_job ?

Is this job(ie 7544) visible in ALL_JOBS ?

-Thiru

Report message to a moderator

Re: ORA-12012:, ORA-23421:;ORA-06512: [message #62214 is a reply to message #60827] Mon, 05 July 2004 23:17 Go to previous message
Jesper Haure Norrevang
Messages: 1
Registered: July 2004
Junior Member
I got the same errors when using DBMS_STATS.GATHER_SYSTEM_STATS with gathering_mode INTERVAL.

DBMS_STATS makes a new job to be run once after INTERVAL minutes. The errors in the alertlog comes when this job is run.

It is a bug in Oracle 9.0. It seems to be solved in 9.2.0.5 (if not before).

Check the table SYS.AUX_STATS$ to see the timestamps and the missing/old statistics.

Finally the article Understanding System Statistics
by Jonathan Lewis (http://otn.oracle.com/pub/articles/lewis_cbo.html) may be of interest.

Regards

Report message to a moderator

Previous Topic: archive logs
Next Topic: characterset
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 24 01:17:33 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.