Oracle Database Errors or Warnings from Error ORA-29349 to ORA-29360


ORA-29349: tablespace ‘string’ already exists
Cause: Tried to plug-in a tablespace which already exists.
Action: Drop the offending tablespace if possible. Otherwise use a different method (e.g., import/export) to move data.
ORA-29351: can not transport system, sysaux, or temporary tablespace ‘string’
Cause: The referred tablespace is either the system tablespace, the sysaux tablespace, or a temporary tablespace.
Action: Do not include this tablespace in the transportable set.
ORA-29352: event ‘string’ is not an internal event
Cause: The DBMS_SYSTEM.WAIT_FOR_EVENT procedure was called with an event name that is not an internal event.
Action: Check the list of events from X$KSLED and verify the event name parameter passed to the WAIT_FOR_EVENT procedure.

ORA-29353: The transportable list is too long.
Cause: The transportable list exceeds the buffer size of 32767.
Action: Reduce the list of tablespaces to transport.
ORA-29355: NULL or invalid string argument specified
Cause: The named argument was either invalid or specified as a NULL
Action: Specify non-null, valid arguments.
ORA-29356: These parameters can be specified only for directives that refer to consumer groups
Cause: The below parameters were specified as an argument to procedure CREATE_PLAN_DIRECTIVE or UPDATE_PLAN_DIRECTIVE of package DBMS_RESOURCE_MANAGER.where the GROUP_OR_SUBPLAN argument is a resource plan. “ACTIVE_SESS_POOL_P1”, “QUEUEING_P1”, “PARALLEL_DEGREE_LIMIT_P1”, “SWITCH_P1”, “SWITCH_P2”, “SWITCH_P3”, “MAX_EST_EXEC_TIME”, “UNDO_POOL”
Action: Specify these parameters only for consumer group directives.

ORA-29357: object string already exists
Cause: The name specified as argument to procedure CREATE_PLAN, CREATE_CONSUMER_GROUP, or CREATE_CATEGORY of package DBMS_RESOURCE_MANAGER is already in use.
Action: Specify an unused name.
ORA-29358: resource plan string does not exist
Cause: An invalid plan name was specified as an argument to procedure UPDATE_PLAN of package DBMS_RESOURCE_MANAGER.
Action: Specify an existing plan name.
ORA-29359: invalid method name string specified for resource plan string
Cause: An invalid method was specified as an argument to procedure CREATE_PLAN or UPDATE_PLAN of package DBMS_RESOURCE_MANAGER.
Action: Specify a valid method name.
ORA-29360: retry operation. Too much concurrent activity
Cause: An attempt was made to revoke the switch consumer group privilege from a user for his/her initial consumer group but someone is modifying the user in another session.
Action: Retry the operation later.

Above are list of Oracle Database Errors or Warnings from Error ORA-29349 to ORA-29360 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.

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 *