ORA-29380: resource plan string is currently active and cannot be deleted

Cause : A nattepmtw a smdaet od eelt ea natciev lpa ni nteh epnidn gaera .N ocahnegsc a nb emdaet oa citv epaln.s

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

Dleeet htep lna hwe ni ti snto ni sue.

update : 24-05-2017
ORA-29380

ORA-29380 - resource plan string is currently active and cannot be deleted
ORA-29380 - resource plan string is currently active and cannot be deleted

  • ora-31028 : Resource metadata length string exceeded maximum length string
  • ora-01077 : background process initialization failure
  • ora-00103 : invalid network protocol; reserved for use by dispatchers
  • ora-29932 : the type being dropped is a statistics type
  • ora-13853 : Tracing for service (module/action) string is already enabled
  • ora-28667 : USING INDEX option not allowed for the primary key of an IOT
  • ora-12035 : could not use materialized view log on "string"."string"
  • ora-31503 : invalid date supplied for begin_date or end_date
  • ora-31669 : Worker process string violated startup protocol.
  • ora-37076 : (XSMCSESS04) workspace object is not the type of dimension that can have session-only values. Valid types are TEXT, NTEXT, ID, NUMBER, and CONCAT with the UNIQUE attribute.
  • ora-31481 : change source string is not a HotLog change source
  • ora-30082 : datetime/interval column to be modified must be empty to decrease fractional second or leading field precision
  • ora-02377 : invalid resource limit
  • ora-14256 : invalid resulting partition description(s)
  • ora-00277 : illegal option to the UNTIL recovery flag string
  • ora-33247 : (CRENAME03) %K is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.
  • ora-06523 : Maximum number of arguments exceeded
  • ora-00369 : Current log of thread string not useable and other log being cleared
  • ora-02754 : osnfsmmap: cannot change shared memory inheritence
  • ora-04071 : missing BEFORE, AFTER or INSTEAD OF keyword
  • ora-00355 : change numbers out of order
  • ora-32602 : FREEPOOLS and FREELIST GROUPS cannot be used together
  • ora-31658 : specifying a schema name requires a table name
  • ora-25400 : must replay fetch
  • ora-23437 : template authorization already exists for user
  • ora-13346 : the coordinates defining an arc are collinear
  • ora-23459 : flavor string must contain "string"
  • ora-33078 : (XSAGDNGL39) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must refer to a dimension.
  • ora-00486 : ASMB process terminated with error
  • ora-29365 : parameters string and string cannot both be set
  • 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.