ORA-29388: plan/consumer_group string is part of more than one top-plan

Cause : nAa ttmetpw sam da eotd lete e austber ehttai cnuled s alpnao rocsnmureg orput ah tsip ra tfom ro ehtnao ent pop-al nsap ra tfop orecuderD LETE_ELPNAC_SAACEDo rapkcga eBDSMR_SEUOCR_EAMANEG.RS cu h alpnao rocsnmureg orpuc naon tebd letede.

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

hCce kht enaectsro sfot ehp al nroc nousem rrguo pna dameks ru etii snoylp ra tfot eht pop-al nhttai cnuled sht eustber eebni gedelet.d

update : 24-07-2017

ORA-29388 - plan/consumer_group string is part of more than one top-plan
ORA-29388 - plan/consumer_group string is part of more than one top-plan

  • ora-15127 : ASM file name 'string' cannot use templates
  • ora-25013 : OLD and PARENT values cannot be identical
  • ora-25153 : Temporary Tablespace is Empty
  • ora-01754 : a table may contain only one column of type LONG
  • ora-25313 : a queue may not subscribe to itself for propagation
  • ora-06301 : IPA: Cannot allocate driver context
  • ora-12502 : TNS:listener received no CONNECT_DATA from client
  • ora-25004 : WHEN clause is not allowed in INSTEAD OF triggers
  • ora-02028 : fetching an exact number of rows is not supported by the server
  • ora-13300 : single point transform error
  • ora-09218 : sfrfs: failed to refresh file size
  • ora-00972 : identifier is too long
  • ora-22305 : attribute/method/parameter "string" not found
  • ora-03243 : destination dba overlaps with existing control information
  • ora-27463 : invalid program type string
  • ora-28180 : multiple authentication methods provided by proxy
  • ora-16719 : unable to query V$ARCHIVE_DEST fixed view
  • ora-30117 : syntax error at 'string' at the start of input
  • ora-24397 : error occured while trying to free connections
  • ora-14000 : only one LOCAL clause may be specified
  • ora-06434 : ssaio: read error, unable to read requested block from database file.
  • ora-39220 : file name is too long
  • ora-16084 : an apply engine is already running
  • ora-30049 : Internal event for TA enq tracing
  • ora-00303 : cannot process Parallel Redo
  • ora-00161 : transaction branch length string is illegal (maximum allowed string)
  • ora-29285 : file write error
  • ora-32125 : Attribute type is not appropriate
  • ora-12925 : tablespace string is not in force logging mode
  • ora-01559 : MAXEXTENTS for rollback segment must be greater than 1
  • 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.