ORA-12012: error on auto execute of job 56960 in the alert log file
experts,
i am getting following error continuously. when i check alert log file i can see the following information. could you please help to fix this problem..
Errors in file /opt/mis/oracle/admin/QS5X
ORA-12012: error on auto execute of job 56960
ORA-27369: job of type EXECUTABLE failed with exit code: Not owner
Mon Jul 14 20:31:34 2008
Errors in file /opt/mis/oracle/admin/QS5X
ORA-12012: error on auto execute of job 56960
ORA-27369: job of type EXECUTABLE failed with exit code: Not owner
Mon Jul 14 20:36:34 2008
Errors in file /opt/mis/oracle/admin/QS5X
ORA-12012: error on auto execute of job 56960
ORA-27369: job of type EXECUTABLE failed with exit code: Not owner
Mon Jul 14 20:41:34 2008
Errors in file /opt/mis/oracle/admin/QS5X
ORA-12012: error on auto execute of job 56960
ORA-27369: job of type EXECUTABLE failed with exit code: Not owner
i am getting following error continuously. when i check alert log file i can see the following information. could you please help to fix this problem..
Errors in file /opt/mis/oracle/admin/QS5X
ORA-12012: error on auto execute of job 56960
ORA-27369: job of type EXECUTABLE failed with exit code: Not owner
Mon Jul 14 20:31:34 2008
Errors in file /opt/mis/oracle/admin/QS5X
ORA-12012: error on auto execute of job 56960
ORA-27369: job of type EXECUTABLE failed with exit code: Not owner
Mon Jul 14 20:36:34 2008
Errors in file /opt/mis/oracle/admin/QS5X
ORA-12012: error on auto execute of job 56960
ORA-27369: job of type EXECUTABLE failed with exit code: Not owner
Mon Jul 14 20:41:34 2008
Errors in file /opt/mis/oracle/admin/QS5X
ORA-12012: error on auto execute of job 56960
ORA-27369: job of type EXECUTABLE failed with exit code: Not owner
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
what did you find when you looked at the job in the scheduler view?
who owned the executable?
who owned the executable?
Did you see any errors by running those queries which i have posted already.
ASKER
Thanks for reply.
i am very sorry late response. from the error message i could not find which job is failed.
we have so many jobs in my database.
i want to find which job is failed. i could not able to get this information.
i am very sorry late response. from the error message i could not find which job is failed.
we have so many jobs in my database.
i want to find which job is failed. i could not able to get this information.
Can you post the output from
select * from dba_scheduler_jobs where job_type = 'EXECUTABLE'
select * from dba_scheduler_jobs where job_type = 'EXECUTABLE'
ASKER
i just upload one file. could you please the attached file.
where is it attached?
to find the failed jobs, you can use any of the below :
select * from dba_scheduler_jobs
where owner ='SCOTT' -- change owner name accordingly
and failure_count > 0
select * from dba_scheduler_job_log
where owner ='SCOTT' -- change owner name accordingly
and status = 'FAILED'
select * from dba_scheduler_job_run_deta
where status ='FAILED'
and owner ='SCOTT' -- change owner name accordingly
select * from dba_scheduler_jobs
where owner ='SCOTT' -- change owner name accordingly
and failure_count > 0
select * from dba_scheduler_job_log
where owner ='SCOTT' -- change owner name accordingly
and status = 'FAILED'
select * from dba_scheduler_job_run_deta
where status ='FAILED'
and owner ='SCOTT' -- change owner name accordingly
ASKER
i want to find the cause why it is failing. can any one explain how to get the information.