ORA 12012 01426 06512

[Zaheer]

Dear Erman,

I am facing following issue in my database alert file. Pl advice soln.

ORA-12012 error on auto execute of job "SYS"."ORA$AT_sa_spc_sy_32837"
ora-01426: NUMERIC OVERLFLOW
ora-06512: AT "SYS.DBMS_ADVISOR LINE 201
ora-06512: AT "SYS.DBMS_SPACE LINE 2480
ora-06512: AT "SYS.DBMS_SPACE LINE 2553


Regards

[ErmanArslansOracleBlog]

That job seems related with Auto Space advisor.

*As per document 1604533.1, apply the patch  -> 16621589
Don't forget to take the post actions of the patch (documented in its readme)

*Also,  if you are not using it, you can disable autospace advisor;

Workaround:

BEGIN
DBMS_AUTO_TASK_ADMIN.DISABLE(
client_name => 'auto space advisor',
operation => NULL,
window_name => NULL);
END;
/