Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MGMT$DB_TABLESPACES & MGMT$DB_DATAFILES not upto date

1723552Sep 23 2014 — edited Oct 1 2014

Hi,

OEM version : 11.1.0.1

OEM Repository version : 11.2.0.2

Agent version : 10.2.0.5

It seems to be last collection timestamp for MGMT$DB_TABLESPACES and MGMT$DB_DATAFILES views shows two months old for few databases.

Agents are up and running fine. What could be the problem ?

  1* select distinct collection_timestamp ,target_name  from MGMT$DB_DATAFILES

group by collection_timestamp,target_name order by target_name

SQL> /

COLLECTIO TARGET_NAME

--------- ----------------------------------------

24-JUL-14 KAP

17-SEP-14 KAQ

24-JUL-14 KD1

24-JUL-14 KOP

Please advice.

Thanks.

This post has been answered by Courtney Llamas-Oracle on Sep 23 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2014
Added on Sep 23 2014
2 comments
1,250 views