Error On Auto Execute Of Job Oracle
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
ora-12012 error on auto execute of job oracle_ocm . mgmt_config_job_2_2 ORA-12012 Auto Execute Error Tips Expert Oracle ora-12012 error on auto execute of job oracle_ocm . mgmt_config_job Database Tips by Burleson Consulting February 11, 2015 Question: I am receiving the following error in my Alert log. But ora-12012 error on auto execute of job oracle_ocm . mgmt_config_job_2_1 my job is not broken and there are no failures. Any idea what is going on and how I can resolve this? ORA-12012: error on auto execute of job 62 ORA-12005: may not schedule ora-12012: error on auto execute of job automatic refresh for times in the past dbms_refresh.refresh('"AAI"."A_REST"'); Broken = N Failure = 0 Interval = trunc(sysdate)+23/24 Last Date =10/21/2005 12:02:15 AM Next Date =10/21/2005 11:00:00 PM ORA-12012: error on auto execute of job 62 ORA-12005: may not schedule automatic refresh for times in the past How do I find out the cause of this ORA-12012 error and the accompanying ORA-12005 error? Answer: ORA-12012 error is a genericOra-12012 Error On Auto Execute Of Job Sys . Dra_reevaluate_open_failures
error and you need to look closer to find the real error code that indicates why the job failed. To diagnose any error, you start by using the oerr utility to display the ORA-12012 error: ORA-12012: Error on Auto Execute of Job Cause: An error was caught while doing an automatic execution of a job. Action: Look at the accompanying errors for details on why the execute failed. As is indicated by the utility, the required action is to look at the accompanying errors for details on why the execute failed. In this case, the accompanying error is: ORA-12005: may not schedule automatic refresh for times in the past. This means that there's something wrong with the part of your code dealing with the automatic refresh, specifically the interval. Your interval is set as follows: interval = trunc(sysdate)+23/24 The code you have written sets an interval where Oracle is trying to run the job at a time in the past, which it simply cannot do. So, change your interval to this: interval = trunc(sysdate+1)+23/24 And your Oracle job will run smooth as silk! An ORA-12012 error should come with an accompanying error that will basically tell you what you did wrong. Fix that, and a
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don
Ora-12012 Error On Auto Execute Of Job Sysman . Em_ecm_vcpu_job
Burleson Blog
ora-12012 error on auto execute of job 1 ORA-12012: error on auto execute of job SYS.BSLN_MAINTAIN_STATS_JOB Oracle Database Tips by Burleson Consulting January 5, 2016 Question: I ora-12012 error on auto execute of job sys . ora$at_ keep seeing the following ORA-12012_error_on_autoexecute message in my alert log: ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB" ORA-06502: PL/SQL: numeric or value error ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073 How do http://www.dba-oracle.com/t_ora_12012_error_on_autoexecute.htm I address this error? Answer: Pursuant to MOSC note 1413756.1, this is a bug fixed in 11.2.0.4. In the alternative, you can apply patch number 10110625 if it is available for your release of Oracle. Oracle Training from Don Burleson The best on site "Oracle training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, http://www.dba-oracle.com/t_ora_12012_error_on_autoexecute_bsln_maintain_stats_job.htm right at your shop! Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page. Burleson Consulting The Oracle of Database Support Oracle Performance Tuning Remote DBA Services Copyright © 1996 - 2016 All rights reserved by Burleson Oracle is the registered trademark of Oracle Corporation. ��DBA Zone Stay updated via RSS Blog Stats 142,850 hits Recent Posts Change Listener portsRAC Setting up InstanceCaging oratop - monitoringtool 11gR2 RAC recoverytest oracle.sysman.emSDK.core.target. DuplicateEntityException: ORA-20500 Categories ASM (7) Dataguard (2) Datapump (1) Export (1) Flashback (2) Grid Control https://oracledbazone.com/2012/04/17/ora-12012-error-on-auto-execute-of-job-sys-bsln_maintain_stats_job-2/ (2) Installs (1) Objects (4) ORA- error (1) RAC (11) RMAN (5) Space (1) Statspack (1) Tools (1) Uncategorized (3) Unix (1) Wallet (1) ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB" Posted: April 17, 2012 in ORA- error 10 Error in Alert error on log Errors in file /wload/test/app/oracle/diag/rdbms/TEST/TEST/trace/TEST_j000_7733378.trc: ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB" ORA-06502: PL/SQL: numeric or value error ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073 ORA-06512: at line 1 Sat Mar 24 23:01:18 2012 Error from trace file *** 2012-03-24 23:00:13.943 *** SESSION error on auto ID:(23.6871) 2012-03-24 23:00:13.943 *** CLIENT ID:() 2012-03-24 23:00:13.943 *** SERVICE NAME:(SYS$USERS) 2012-03-24 23:00:13.943 *** MODULE NAME:(DBMS_SCHEDULER) 2012-03-24 23:00:13.943 *** ACTION NAME:(BSLN_MAINTAIN_STATS_JOB) 2012-03-24 23:00:13.943 ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB" ORA-06502: PL/SQL: numeric or value error ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073 ORA-06512: at line 1 Cause Table DBSNMP.BSLN_BASELINES contains inconsistent information that is causing the job to fail. Check the job status SQL> select log_date,status from dba_scheduler_job_run_details where job_name='BSLN_MAINTAIN_STATS_JOB'; LOG_DATE STATUS -------------------------------------------------- -------------------- 10-MAR-12 11.00.13.501250 PM +00:00 FAILED 03-MAR-12 11.00.10.603238 PM +00:00 FAILED 17-MAR-12 11.00.14.793987 PM +00:00 FAILED 24-MAR-12 11.00.13.980545 PM +00:00 FAILED Role of BSLN_MAINTAIN_STATS_JOB This job runs the BSLN_MAINTAIN_STATS_PROG program on the BSLN_MAINTAIN_STATS_SCHED schedule. The program BSLN_MAINTAIN_STATS_PROG will keep the default baseline’s statistics up-to-date Check the DBSNMP.BSLN_BASELINES table SQL> select * from DBSNMP.BSLN_BASELINES; DBID