“ORA-7452: resource plan ”” does not exist” occurred during upgrade from 11.2 to 12.2

dbtut

5 years ago

You may see this error in the database alert log file during upgrade from 11.2 to 12.2.

Opening with Resource Manager plan: ''
ORA-7452: resource plan '''' does not exist

1 2	Opening with Resource Manager plan: '' ORA-7452: resource plan '''' does not exist

The reason for this error is that the resource_manager_plan value was set as single quotes during the upgrade.

The error is only seen in the alert log file. No action is required for the error. It can be easily ignored.