My Oracle Support Banner

Resource Plan Related To Window Is Not Clear After Closing Corresponding Window On RAC (Doc ID 2404055.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

Resource plan related to window is not clear after closing corresponding windoweven after applying 13817037

One of the databases having the issue is named "test01" and it has two instances, "test01p1" and "test01p2".

The resource_manager_plan parameter has a value test01_INITIAL_PLAN in spfile for all the instances.

When daily maintenance window closes, one of the instances goes back to the resource manager plan specified in the parameter (test01_INITIAL_PLAN) but the other one clears the resource manager plan so it ends up using the INTERNAL_PLAN.

However both of the instances should remain with "test01_INITIAL_PLAN" (because that is what the resource_manager_plan parameter is configured to in both instances) after the maintenance window closes.

test01p1

------------

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.