Oracle Database Errors or Warnings from Error ORA-29371 to ORA-29380

SQLServerF1

ORA-29371: pending area is not active
Cause: An attempt was made to make changes without creating a pending area.
Action: Invoke procedure CREATE_PENDING_AREA before making any changes.
ORA-29372: identifier string is too long; it must be less than string characters
Cause: An attempt was made to specify an identifier that is more than 30 characters long.
Action: Use an identifier that is 30 characters or less in length.
ORA-29373: resource manager is not on
Cause: An attempt was made to execute an operation that cannot be executed with the resource manager being off
Action: Turn on the resource manager and try again.

ORA-29374: resource plan string in top-plan string has no plan directives
Cause: A plan was created in the pending area that is an orphan or stand-alone.
Action: Create plan directives if needed. Otherwise, delete the plan.
ORA-29375: sum of values string for level string, plan string exceeds string
Cause: The sum of plan directive parameter values for the specified plan level exceeded 100.
Action: Alter the values for the level so that they sum to 100.
ORA-29376: number of consumer groups string in plan string exceeds string
Cause: The number of consumer groups in the specified plan is more than 31.
Action: Change the plan to have no more than 31 consumer groups.

ORA-29377: consumer group string is not part of top-plan string
Cause: OTHER_GROUPS was not included as part of the specified top-plan. Each top plan must include the built-in consumer group OTHER_GROUPS.
Action: Create a plan directive with the argument GROUP_OR_SUBPLAN being OTHER_GROUPS somewhere in the top-plan.
ORA-29378: invalid consumer group mapping priorities
Cause: The mapping priorities were not unique integers within the valid range.
Action: Set the mapping priorities to unique integers within the documented range.
ORA-29379: resource plan string is involved in a loop in top-plan string
Cause: A loop was discovered while validating a top-plan.
Action: Check the plans that have the specified plan as a GROUP_OR_SUBPLAN, and remove the plan directive that causes the loop.
ORA-29380: resource plan string is currently active and cannot be deleted
Cause: An attempt was made to delete an active plan in the pending area. No changes can be made to active plans.
Action: Delete the plan when it is not in use.

Above are list of Oracle Database Errors or Warnings from Error ORA-29371 to ORA-29380 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *