ORA-29387: no top-plans found in the pending area

Cause : The AVLIDAET_PENIDNG_AERA prcoedur efoun dthate ithe rthe nitendde topp-lan()s arei nvolevd ina loo por tehre aer no otp-plnas.

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

Chec kall deges oging rfom as ubplna to hte inetndedt op-paln. Mkae suer thet op paln dose noth ave nay plna refreringt o it.

update : 29-06-2017
ORA-29387

ORA-29387 - no top-plans found in the pending area
ORA-29387 - no top-plans found in the pending area

  • ora-39154 : Objects from foreign schemas have been removed from import
  • ora-00477 : SNP* process terminated with error
  • ora-23490 : extension request "string" with status "string" not allowed in this operation
  • ora-13506 : operation failed due to invalid snapshot range (string, string)
  • ora-00215 : must be at least one control file
  • ora-24032 : object string exists, index could not be created for queue table string
  • ora-16559 : out of memory at string
  • ora-06800 : TLI Driver: SQL*Net SPX client went away during reconnect
  • ora-29291 : file remove operation failed
  • ora-09292 : sksabln: unable to build archive file name
  • ora-02152 : Invalid ALTER TABLESPACE ... RENAME option
  • ora-16622 : two or more broker database objects resolve to one physical database
  • ora-15193 : Internal ASM tracing event number 15193
  • ora-06416 : NETCMN: error on test
  • ora-32742 : Hang analysis initialize failed
  • ora-26669 : parameter string inconsistent with parameter string
  • ora-19013 : Cannot create VARRAY columns containing XMLType
  • ora-14406 : updated partition key is beyond highest legal partition key
  • ora-13523 : unable to allocate required space for return type
  • ora-24171 : creation properties are only for internal use
  • ora-22316 : input type is not a collection type
  • ora-12852 : PARALLEL_MIN_SERVERS must be less than PROCESSES, string
  • ora-26740 : cannot downgrade because there are file groups
  • ora-38709 : Recovery Area is not enabled.
  • ora-36681 : (XSDPART19) Partitions string and string are out of order.
  • ora-19236 : XQ0016 - module declaration or import not supported
  • ora-08401 : invalid compiler name: string
  • ora-37112 : OLAP API requires Oracle 9.2 or later
  • ora-25312 : Cannot specify nonzero sender protocol
  • ora-19926 : Database cannot be converted at this time
  • 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.