ORA-29390: some resource plans are not part of any top-plan

Cause : An attepmt was mdae to craete or mdoify som eplans i nthe penidng areat hat aren ot parto f any tpo-plan

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

Remove htese plasn are tr yvalidatoin again.

update : 26-07-2017

ORA-29390 - some resource plans are not part of any top-plan
ORA-29390 - some resource plans are not part of any top-plan

  • ora-02801 : Operations timed out
  • ora-07214 : slgunm: uname error, unable to get system information.
  • ora-14645 : STORE IN clause cannot be specified for Range List objects
  • ora-36994 : (XSRELGID11) The SURROGATE DIMENSION workspace object must be numeric.
  • ora-01482 : unsupported character set
  • ora-10581 : Can not modify redo log header during test recovery
  • ora-16511 : messaging error using ksrget
  • ora-30458 : 'string.string' cannot be refreshed because the refresh mask is string
  • ora-01350 : must specify a tablespace name
  • ora-09834 : snyGetPortSet: failed to collect info on a port.
  • ora-28261 : CURRENT_USER can not be used in PLSQL Definer's Right procedure.
  • ora-30024 : Invalid specification for CREATE UNDO TABLESPACE
  • ora-10270 : Debug shared cursors
  • ora-32053 : operation not supported
  • ora-19670 : file string already being restored
  • ora-32696 : HTI: No free slot
  • ora-25146 : EXTENT MANAGEMENT option already specified
  • ora-27036 : translation error, unable to expand file name
  • ora-01254 : cannot end online backup - file string in recovery manager backup
  • ora-12525 : TNS:listener has not received client's request in time allowed
  • ora-12712 : new character set must be a superset of old character set
  • ora-07576 : sspexst: $GETJPIW failure on process ID string
  • ora-01002 : fetch out of sequence
  • ora-13404 : invalid ultCoordinate parameter
  • ora-24079 : invalid name string, names with AQ$_ prefix are not valid for string
  • ora-02706 : osnshs: host name too long
  • ora-29251 : Index1 is greater than Index2 in call to dbms_sql.bind_array
  • ora-32616 : missing DIMENSION BY keyword in MODEL clause
  • ora-01841 : (full) year must be between -4713 and +9999, and not be 0
  • ora-25235 : fetched all messages in current transaction
  • 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.