ORA-29384: number of children for plan string exceeds string

Cause : An attemptw as mdae toc reat eor mdoify hte spceifie dplan ,but hte plna hasm ore htan 3 2chilrden.

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

Makes ure hte spceifie dplanp oint sto n omoret han 23 disitnct ondes.

update : 19-08-2017
ORA-29384

ORA-29384 - number of children for plan string exceeds string
ORA-29384 - number of children for plan string exceeds string

  • ora-08100 : index is not valid - see trace file for diagnostics
  • ora-25527 : bad format of _DB_MTTR_SIM_TARGET
  • ora-24851 : failed to connect to shared subsystem
  • ora-25232 : duplicate recipients specified for message
  • ora-04050 : invalid or missing procedure, function, or package name
  • ora-09987 : unable to attach to SGA in READ-ONLY mode
  • ora-12598 : TNS:banner registration failed
  • ora-12211 : TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA
  • ora-31051 : Requested access privileges not supported
  • ora-15079 : ASM file is closed
  • ora-12437 : invalid policy option: string
  • ora-06313 : IPA: Shared memory failed to initialise
  • ora-31656 : cannot use TABLESPACE_EXPR filter with transportable mode
  • ora-30928 : Connect by filtering phase runs out of temp tablespace
  • ora-04016 : sequence string no longer exists
  • ora-36612 : (XSLMS01) invalid OLAP message number: value
  • ora-39500 : failed to notify CRS of a Startup/Shutdown event for database "string", instance "string" (ignored)
  • ora-32839 : property string is reserved, names with MGWPROP$_ prefix are not valid
  • ora-19999 : skip_row procedure was called
  • ora-39137 : cannot specify a TABLE_EXISTS_ACTION of string for a job with no metadata
  • ora-07217 : sltln: environment variable cannot be evaluated.
  • ora-06928 : CMX: wrong ORACLE_SID
  • ora-26711 : remote table does not contain a primary key constraint
  • ora-25252 : listen failed, the address string is a non-persistent queue
  • ora-25302 : Operation not possible for non-buffered queue string
  • ora-25509 : operation on "string"."string".string not allowed
  • ora-39042 : invalid transform name string
  • ora-02717 : osnpfs: incorrect number of bytes written
  • ora-31053 : The value of the depth argument in the operator cannot be negative
  • ora-16525 : the Data Guard broker is not yet available
  • 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.