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 : 23-04-2017
ORA-29388

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-02259 : duplicate UNIQUE/PRIMARY KEY specifications
  • ora-30205 : invalid Character set
  • ora-13606 : the specified task parameter element string is out of range for parameter string.
  • ora-13509 : error encountered during updates to a AWR table
  • ora-30475 : feature not enabled: string
  • ora-25202 : invalid value NULL, string should be non-NULL
  • ora-37102 : (XSVPART02) Invalid partition name string.
  • ora-25469 : data not specified for alias: string column name: string
  • ora-31197 : Error in processing file string
  • ora-13020 : coordinate is NULL
  • ora-19722 : datafile string is an incorrect version
  • ora-31004 : Length string of the BLOB in XDB$H_INDEX is below the minimum string
  • ora-15110 : no diskgroups mounted
  • ora-28582 : a direct connection to this agent is not allowed
  • ora-12040 : master rollback segment option not support by master site string
  • ora-36779 : (XSPGPOOLOUT) Invalid parameter value. Olap_page_pool_size must be between must be between 2097152 and 2147483647. Olap_page_pool_size remain unmodified.
  • ora-38734 : Flashback log is inconsistent; belongs to another database.
  • ora-29530 : could not create shortened name for string
  • ora-23417 : unknown materialized view type: string
  • ora-07231 : slemcc: invalid file handle, seals do not match.
  • ora-19658 : cannot inspect string - file is from different resetlogs
  • ora-25301 : Cannot enqueue or dequeue user buffered messages to a database with version lower than 10.2
  • ora-29833 : indextype does not exist
  • ora-14186 : number of sub-partitions of LOCAL index must equal that of the underlying table
  • ora-01291 : missing logfile
  • ora-06608 : LU6.2 Driver: Reset occurred in receive state
  • ora-12027 : duplicate filter column
  • ora-24028 : cannot create a reciever non-repudiable single consumer queue
  • ora-24068 : cannot start queue string, queue table string is being migrated
  • ora-30400 : identical JOIN KEY clauses
  • 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.