Compile Invalid Objects
SherrieKDec 27 2012 — edited Dec 31 2012We recently upgraded to EM12CR2 from OEM 10.2 and are looking for the location to compile invalid objects. In OEM 10.2 the path was All Metrics --> Invalid Objects by Schema --> Invalid Object Count: <schema>. You could them click on the count number, get to objects and recompile them as SYS.
In EM12CR2 I can go to the database, Monitoring --> All Metrics and see Invalid Objects, Invalid Objects by Schema. For example, I can see that there are 11 invalid objects for SCHEMA1. But I can't drill down into which objects those are and then compile them. When I click on the number, which in my mind is equivalent to the above OEM steps, I get 'no data to display'.
This used to be a simple method for us to make sure all objects compile after a deployment, now that we upgraded I don't want to lose that.
As a side node, I understand that we can do this with a SQL script, or through SQLPLUS, but I'm looking for the EM12CR2 path and method to accomplish this.
sherrie