Skip to Main Content
  • Questions

  • ORA-12012: error on auto execute of job 6 & ORA-01435

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Hariharan.

Asked: November 21, 2016 - 4:19 am UTC

Last updated: August 03, 2023 - 10:29 am UTC

Version: 12.1.0.2

Viewed 10K+ times! This question is

You Asked

Hi,


We are getting following error for EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS() job

Tue Nov 08 05:08:46 2016
Errors in file /u01/rop1/orarop1/db/diag/rdbms/rop1b/rop12/trace/rop12_j000_69953.trc:
ORA-12012: error on auto execute of job 6
ORA-01435: user does not exist

This job ran every minute. Checked that the job has no history or record of broken.

SQL> select job, schema_user, to_char(last_date,'DD-MON-YYYY HH24:MI:SS') "last_date", to_char(next_date,'DD-MON-YYYY HH24:MI:SS') "next_date",
2 interval, what, broken, failures from dba_jobs
3 where job = '6';

JOB SCHEMA_USER last_date next_date INTERVAL WHAT BRO FAILURES
--------------------------------------------------------------------------------------------------------------------------------------------------------------
6 SYSMAN 08-NOV-2016 10:26:35 08-NOV-2016 10:27:35 sysdate + 1 / (24 * 60) EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); N 0

As this is an automated job executed by EM could you please assist the customer to find out why it's throwing this error OR can they ignore the error as the SYSMAN user exists and they are able to login to our 12C OEM using SYSMAN.




Thanks,

and Chris said...

EMD_MAINTENANCE controls maintenance jobs for Enterprise Manager.

If you're not using EM then you can remove this. You can find the following instructions in MOS note 444033.1:

1. If Database Control is not required, then this job can be removed :

- Log in as sysman user on the database
- Note down the value of the job_queue_processes parameter in the database :

SQL> show parameter job_queue_processes
- Set the job_queue_processes to 0 and check that there are no dbms_jobs running :

SQL> alter system set job_queue_processes=0;
SQL> select * from dba_jobs_running;
Re-run the second sql query a few times, till the output of the query returns "no rows selected".

- Login to the database as the SYSMAN user and run the following SQL scripts to submit this job :

SQL> @<ORACLE_HOME>\sysman\admin\emdrep\sql\core\latest\admin\
admin_remove_dbms_jobs.sql;

OR

SQL> exec sysman.emd_maintenance.remove_em_dbms_jobs;
SQL> commit;


If you are using EM, you could try removing it as above and re-creating it (from the same MOS note):


2. If the job has been accidentay removed, follow these steps to re-submit it :

- Login to repository as sysman user.
- Ensure that the job_queue_processes parameter has been set to a value > 1 :

SQL> show parameter job_queue_processes
- To submit the job :

SQL> @<ORACLE_HOME>\sysman\admin\emdrep\sql\core\latest\admin\
admin_submit_dbms_jobs.sql;

OR

SQL> exec emd_maintenance.submit_em_dbms_jobs;
- Recompile the invalid objects :

For 10g and 11.1.0.6 Database
SQL> exec emd_maintenance.recompile_invalid_objects;
For 11.1.0.7.0 and above databases:
SQL> exec emd_maint_util.recompile_invalid_objects;
- Check that the EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS job has been created in the sysman schema.


Or just restarting the jobs (MOS note 285012.1):


If you want to stop and restart the jobs, you can do this using these routines:
- Stop
exec emd_maintenance.remove_em_dbms_jobs;
- Start/Restart:
exec emd_maintenance.submit_em_dbms_jobs;

Rating

  (3 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Hariharan Senthil pandiyan, November 21, 2016 - 10:54 am UTC

Thanks for the update, but why ? and how to find that user ?

ORA-12012: error on auto execute of job 6
ORA-01435: user does not exist --- ??


Thanks,

Connor McDonald
November 22, 2016 - 12:53 am UTC

Is there any more information in /u01/rop1/orarop1/db/diag/rdbms/rop1b/rop12/trace/rop12_j000_69953.trc ?

If you run the task manually from SQL Plus, does the same error reproduce ? If so, you could run it with trace/waits/binds and get more details

Thanks,

A reader, November 28, 2016 - 8:40 am UTC


Gulfcareer

Gulfcareer, August 03, 2023 - 6:08 am UTC

it is good
Connor McDonald
August 03, 2023 - 10:29 am UTC

I'm glad :-)
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.