какая радость, нашел ошибку, ORA-48223, которая нигде не описана
Цитата: ORA-12012: error on auto execute of job "SYS"."DRA_REEVALUATE_OPEN_FAILURES"
ORA-51108: unable to access diagnostic repository - retry command
ORA-48223: Interrupt Requested - Fetch Aborted - Return Code [51111] [HM_FINDING]
пока решение "влоб"
Код:
exec dbms_hm.drop_schema;
exec dbms_hm.create_schema;