Thursday , March 28 2024

ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB”

 

When the BSLN_MAINTAIN_STATS_JOB job ends with ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB” and “ORA-06502: PL/SQL: numeric or value error” errors, the baseline information that causes the problem must be deleted.

This error is usually caused by the baseline created for a deleted instance.

Possible errors will be as follows:

When we query existing baseline information, the data that causes the problem is the data in the row where the deleted instance is. Or, the data in the row where the data in the LAST_COMPUTE_DATE column is different from the others is problematic. These rows must be deleted.

According to the above information, the row that causes the problem is the row with “ORCL4 instance”. We delete this record as follows.

Then, when we run the related job, it will be completed successfully.

Loading

About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *

Categories