Setting up a Database to Monitor in OEM

After doing initial configuration and setup , a OEM dashboard on login will look like as below showing the admin server and the various resources under the server:

To add a database to monitor in the OEM, follow the below steps:

1. Go to Resources -> Database. A  form for all the database details will appear.Fill the form with the database details and click on submit

2. Once added , it will redirect to database listing page , with all the options related to the added database available as links.Click on configuration link to edit the default configuration to modify various startup paramters like -n,-Mn,-S,-BiBufs,-AiBufs etc.

3. -S ,-n client type(4gl,sql or both)  etc can be edited by choosing "servergroup.<dbname>.defaultconfiguration.defaultservergroup" from the below page.

Click on "configuration.<dbname>.defaultconfiguration " to edit the default configurations after clicking edit on the loaded screen.

4. Edit the required parameters and click on save.

Note: All these configurations are saved in "<DLC PATH>/properties/conmgr.properties" file.We can directly edit in the conmgr.properties to reflect the configurations we want for the particular database.


5. We can start / stop the database now from directly OEM tool using start database button, start agent will automatically start with the database if monitored checkbox is ticked for the database.It will start collecting starts for the database and monitor the database for any errors in logs or db shutdown.