Invalid synonyms
553803Feb 1 2007 — edited Mar 20 2007Hi,
I've got several alerts on my repository database. Among them, are 14 invalids objects, 1 job failure and 1 job broken.
Broken job is MGMT_CNTR_TT.CLEAN_UP_OLD_TICKET_RECS. It fails with :
ORA-12012: erreur d'exécution automatique du travail 21
ORA-01403: aucune donnée trouvée
ORA-06512: à "SYSMAN.MGMT_CNTR_TT", ligne 145
ORA-06512: à "SYSMAN.MGMT_CNTR_TT", ligne 171
ORA-06512: à ligne 1
Invalid objects are synonyms :
select object_name,OBJECT_TYPE from dba_objects where status <> 'VALID';
OBJECT_NAME OBJECT_TYPE
------------------------- -------------------
MGMT$METRIC_DETAILS SYNONYM
MGMT$METRIC_HOURLY SYNONYM
MGMT$TXN_PERF_RAW SYNONYM
MGMT$TXN_PERF_HOUR SYNONYM
MGMT$TXN_PERF_DAY SYNONYM
MGMT$STEP_METRICS_RAW SYNONYM
MGMT$GRP_METRICS_RAW SYNONYM
MGMT$STEP_METRICS_HOURLY SYNONYM
MGMT$GRP_METRICS_HOURLY SYNONYM
MGMT$STEP_METRICS_DAILY SYNONYM
MGMT$GRP_METRICS_DAILY SYNONYM
MGMT_METRICS_RAW SYNONYM
MGMT_METRICS_1HOUR SYNONYM
MGMT_METRICS_1DAY SYNONYM
Yesterday, i already had this invalid synonyms. I dropped them and created again. Today they are invalid again.
Any ideas ?
I'm running Grid Control 10g release 3 . The repository is running on 10gR2 database. Both are hosted on a Linux RedHat AS4 server.