How to Fix invalid XDB component in Database.
I opened up a similar discussion in the database administration area but after some additional research i think this may be the correct area to pose this question.
I ran the following script and found that there were 4 components that were invalid. Please let me know how do i fix them and how critical are these pieces. The database is a Grid Control repository database that was upgraded from 10G to 11GR2. I am running 11g on a Sun solaris platform.
the query was:
select substr(comp_id,1,15) comp_id,substr(comp_name,1,30) comp_name,substr(version,1,10) version,status