K Deleting Unwanted Oracle Management Agents

While upgrading from 12c Release 1 (12.1.0.1) to 12c Release 2 (12.1.0.2), you might see an error message stating that some Management Agents are still in Activation Pending state, or that the Deferred Data Migration Process (DDMP) or Accrued Data Migration Process (ADMP) is not complete. This indicates that the earlier release of the Enterprise Manager system is still undergoing a 2-system upgrade to 12c Release 1 (12.1.0.1).

To resolve this issue, wait until the DDMP and ADMP jobs are complete, and all Management Agents are switched over from the earlier release to 12c Release 1 (12.1.0.1). Then upgrade 12c Release 1 (12.1.0.1) to 12c Release 2 (12.1.0.2).

If you are sure you do not want to switch over some Management Agents from the earlier release to 12c Release 1 (12.1.0.1), then delete these unwanted Management Agents as described in Deleting Unwanted Management Agents, before you start the upgrade process.

However, for some reason, if you are unable to delete the unwanted Management Agents, then turn off the sanity check that checks for Managements Agents with Activation Pending state. This enables you to proceed with the upgrade process without encountering any such warning. To turn off the sanity check, run the following query on your 12c Release 1 (12.1.0.1) Management Repository.

MERGE INTO PRE_UPGC_MASTER_INFO DEST
   USING dual
     ON (DEST.property_name =  'ignore_upg_pending_activation_check')
   WHEN MATCHED THEN
     UPDATE SET DEST.property_value = 'TRUE'
   WHEN NOT MATCHED THEN
     INSERT (property_name, property_value) VALUES( 'ignore_upg_pending_ activation_check', 'TRUE' );