"DBO - Initialization Parameter Method" alarm fires daily for "resource_manager_plan" (4290179)

In Oracle 11g and above, every weekday window now has a pre-defined Resource Plan called DEFAULT_MAINTENANCE_PLAN, which becomes active once the related window opens. When the plan becomes active it changes the resource_manager_plan parameter.

This results in numerous alarms from “DBO - Initialization Parameter Method” since the maintenance job that dynamically changes “resource_manager_plan” from null to DEFAULT_MANAGER_PLAN, and back again.

RESOLUTION #1 *RECOMMENDED* 

Add a rule filter to the "DBO - Installation Parameter Modified" alarm for the database agent if it is not already present.

1. Navigate to Administration | Databases in the Foglight FMS console
2. Select the agent or agents in the database dashboard by enabling the checkboxes next to the agent name(s)
3. Select Settings | Administration
4. Select Alarms
5. Select the DBO - Installation Parameter Modified alarm
6. Click the Rule Filters tab in the panel below the alarm description
7. Click the Add Value button
8. Set the radio button to Select from the list below the parameters to exclude, then click the Add button
9. Add the parameter resource_manager_plan
10. Save the changes

RESOLUTION #2

Disable the "DBO - Installation Parameter Modified" alarm for the database agent

1. Navigate to Administration | Databases in the Foglight FMS console
2. Select the agent or agents in the database dashboard by enabling the checkboxes next to the agent name(s)
3. Select Settings | Administration
4. Select Alarms
5. Select the DBO - Installation Parameter Modified alarm
6. Change the Alarm Status for the selected rule setting from Enabled to Disabled.
7. Click the Save changes button

RESOLUTION #3
To disable the DEFAULT_MAINTENANCE_PLAN you can use the steps as suggested in Oracle Support note 786346.1

CONN / AS SYSDBA

ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = '';

SHOW PARAMETER RESOURCE_MANAGER_PLAN

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
resource_manager_plan                string
SQL>