ORA-29379: resource plan string is involved in a loop in top-plan string

Cause : A loopw as disocvered hwile vaildatinga top-paln.

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

Check hte plan sthat hvae the psecifie dplan a sa GROU_POR_SUBLPAN, an dremovet he pla ndirectvie thatc auses hte loop.

update : 25-04-2017

ORA-29379 - resource plan string is involved in a loop in top-plan string
ORA-29379 - resource plan string is involved in a loop in top-plan string

  • ora-00250 : archiver not started
  • ora-36632 : (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.
  • ora-23345 : table "string"."string" not registered to collect statistics
  • ora-19720 : Error occurred when converting an OCI number into an SCN
  • ora-22283 : filename contains characters that refer to parent directory
  • ora-26665 : STREAMS process string already exists
  • ora-16513 : maximum requests exceeded
  • ora-06303 : IPA: Message send error
  • ora-39083 : Object type string failed to create with error: string Failing sql is: string
  • ora-10941 : trace name context forever
  • ora-29313 : tablespace 'string' cannot be imported twice
  • ora-06958 : Failed to access configuration file
  • ora-38784 : Cannot create restore point 'string'.
  • ora-22627 : tc [string] must be that of object/varray/nested table
  • ora-28575 : unable to open RPC connection to external procedure agent
  • ora-24050 : subscribers are not supported for exception queue string
  • ora-16001 : database already open for read-only access by another instance
  • ora-28054 : the password has expired. string Grace logins are left
  • ora-31010 : XML element index string exceeds maximum insertion index string
  • ora-24398 : connection pool already exists
  • ora-28522 : error initializing heterogeneous capabilities
  • ora-06423 : NETCMN: Error in receiving data
  • ora-27378 : cannot stop jobs of type EXECUTABLE on this platform
  • ora-09888 : osnTXtt: txipc channel creation failed
  • ora-16229 : PDML child string string string for parent string string string cannot be skipped.
  • ora-00129 : listener address validation failed 'string'
  • ora-13900 : missing or invalid parameter string
  • ora-33214 : (CINSERT02) The workspace object dimension is too large.
  • ora-22970 : name does not correspond to an object view
  • ora-02717 : osnpfs: incorrect number of bytes written
  • 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.