11G DB Console with EM Grid Agent
Posted by John Hallas on February 10, 2009
This blog shows how to run DB console in conjunction with Enterprise Manager Grid.
Why would I want to do both, well purely because DB console is at 126.96.36.199 whereas the latest version of EM Grid agent is 10.2.0.4. The new db console has additional functionality to manage RAC, RMAN and Data Guard which is not available from EM.
The initial errors I received when trying to create a db console repository was that the SYSMAN user already existed. This is created within the database as part of the DBCA build. Once that user was dropped I received one error after another until I finally got the order of commands correct. From the source database (not the EM OMS database)
Now we drop the repository (if it exists) and any existing public synonyms or views that may cause the repository create to fail. Bug 6111734 details some issues in this area and Metalink note 470246.1 gives some information, but not much
It requires some input and then lists all the actions that are taking place. Note the use of quiesce database.
The repository can be created in the normal manner using either