ORA-29386: plan or consumer group string is mandatory and cannot be deleted or modified

Cause : An attempt was made to delete or modify the specified mandatory plan or consumer group.

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

Do not attempt to delete or modify mandatory plans and consumer groups.

update : 28-06-2017

ORA-29386 - plan or consumer group string is mandatory and cannot be deleted or modified
ORA-29386 - plan or consumer group string is mandatory and cannot be deleted or modified

  • ora-02249 : missing or invalid value for MAXLOGMEMBERS
  • ora-27032 : failed to obtain file size limit
  • ora-01691 : unable to extend lob segment string.string by string in tablespace string
  • ora-13273 : dimension metadata table string does not exist
  • ora-06816 : TLI Driver: could not set the SPX SAP address
  • ora-04076 : invalid NEW or OLD specification
  • ora-12667 : Shared server: outbound transport protocol different from inbound
  • ora-07683 : sou2os: $SETPRV reset error
  • ora-24050 : subscribers are not supported for exception queue string
  • ora-19019 : Invalid context passed to DBMS_XMLGEN.GETXML
  • ora-24076 : cannot perform operation string for NON_PERSISTENT queue string.string
  • ora-13030 : Invalid dimension for the SDO_GEOMETRY object
  • ora-02207 : invalid INITRANS option value
  • ora-06607 : LU6.2 Driver: Reset occurred in send state
  • ora-13129 : HHCODE column string not found
  • ora-32550 : Replacement occured despite hint to the contrary
  • ora-16559 : out of memory at string
  • ora-24143 : invalid evaluation context name
  • ora-25009 : Nested table clause allowed only for INSTEAD OF triggers
  • ora-25437 : duplicate table value for table alias: string
  • ora-14321 : cannot add/drop values to DEFAULT partition
  • ora-38788 : More standby database recovery is needed
  • ora-16742 : the standby database "string" has exhausted its quota
  • ora-01195 : online backup of file string needs more recovery to be consistent
  • ora-06260 : NETNTT: cannot write to remote process
  • ora-25243 : CONSUMER_NAME cannot be specified when dequeuing from exception queue string.string
  • ora-19609 : %s is from different backup set: stamp string count string
  • ora-30576 : ConText Option dictionary loading error
  • ora-00359 : logfile group string does not exist
  • ora-13480 : the Source Type is not supported
  • 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.