ORA-07459: cannot restore the RESOURCE_MANAGER_PLAN parameter

Cause : An attempt was made to internally restore the RESOURCE_MANAGER_PLAN parameter to the value before it was internally set. This failed because the current plan was set by the user and therefore did not need to be restored.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

No action needed.

update : 24-04-2017

ORA-07459 - cannot restore the RESOURCE_MANAGER_PLAN parameter
ORA-07459 - cannot restore the RESOURCE_MANAGER_PLAN parameter

  • ora-19586 : %s k-byte limit is too small to hold piece directory
  • ora-08103 : object no longer exists
  • ora-29658 : EXTERNAL NAME clause is not compatible with its supertype
  • ora-07580 : spstp: $GETJPIW failure
  • ora-33217 : (CINSERT20) Custom member values cannot be added to concat dimension workspace object, or to any of its bases, because it is not defined as UNIQUE.
  • ora-25141 : invalid EXTENT MANAGEMENT clause
  • ora-01647 : tablespace 'string' is read only, cannot allocate space in it
  • ora-16706 : no resource guard is available
  • ora-12450 : LOB datatype disabled in LBAC initialization file
  • ora-13220 : failed to compare tile with the geometry
  • ora-22313 : cannot use two versions of the same type "string"
  • ora-13039 : failed to update spatial index for element string.string.string
  • ora-30131 : number of keys being set exceeds allocation
  • ora-16569 : Data Guard configuration is not enabled
  • ora-33309 : (DBVALID05) SEVERE ERROR: Record number used but not allocated (PS number)
  • ora-08268 : create_ora_addr: cannot close nameserver
  • ora-33009 : (XSAGDNGLPREC) In AGGMAP workspace object, PRECOMPUTE may only be specified either for the entire AGGMAP or for individual RELATION statements.
  • ora-19906 : recovery target incarnation changed during recovery
  • ora-29336 : Internal error [string] [string] from DBMS_PLUGTS
  • ora-10389 : parallel query server interrupt (cleanup)
  • ora-39058 : current object skipped: string of type string
  • ora-36995 : (XSRELGID12) There are duplicate values in the surrogate dimension gid. Use the levelorder option to resolve the ambiguity.
  • ora-29954 : domain index partition is marked LOADING/FAILED/UNUSABLE
  • ora-10917 : TABLESPACE GROUP cannot be specified
  • ora-30352 : inconsistent numeric precision or string length
  • ora-23432 : master site string already exists
  • ora-16765 : Redo Apply is unexpectedly online
  • ora-22606 : pickler image handle [string] is not well-formed
  • ora-15156 : cluster in rolling upgrade from version [string] to [string]
  • ora-30135 : OCI Thread operation fails
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.