Comparison between multiple databases
I have been trying to play around with OEM grid control 11g and trying to configure the comparisons between multiple databases. The theory behind it makes sense, but to actually configure and use the feature seems incredibly cumbersome. Is there any other way to import/export baselines than with datapump? Does anyone use this feature? I'm also guessing that the comparison does not compare the contents of db schema tables. Can anyone provide any feed back on how to get this going in a way that, once set up, it's pretty hands off for the DBA?
We are in a bit of a stuck spot since our environment has doubled in the last year, and we're starting to notice that some things are not consistent across all the databases. We have a total of aprox 30 databases and to check them manually or writing a script seems like it will take too much work and effort. We need to be able to audit the builds and make sure that everything is consistent across the board.